主题：急，数据库调试出错，求帮助

急急急

小弟初学数据库开发，今天调试程序出现错误，请大虾帮助：

private void btnLogin_Click(object sender, EventArgs e)
        {
           // string sql ;
           // sql  = "Select UserID, UserPassword  From User Where UserID='" + txtUserName.Text ;
            string oleDbConnection = @"provider=Microsoft.Jet.OLEDB.4.0; Data Source = E:\徐贻波\项目\图书馆管理系统项目设计\DATA\BookManage.mdb";
            OleDbConnection connection = new OleDbConnection( oleDbConnection );
            OleDbCommand cmd = connection.CreateCommand();
            cmd.CommandText = " select UserID, UserPassword "+
                " from User"+
                " where UserID='" + txtUserName.Text;
            connection.Open();
            OleDbDataReader reader = cmd.ExecuteReader();
            if ( !reader.HasRows)
            {
                MessageBox.Show("用户名错误，请重新输入。", "提示信息", MessageBoxButtons .OK , MessageBoxIcon.Error);
                txtUserName.Focus();
                return;
            }
            else
            {
            //读取数据库的内容，并与输入的进行比较；
                while (reader.Read())
                {
                    //判断用户输入是否正确
                    if (reader["txtUserPassword"].ToString().Trim() != txtPassword.Text.Trim())
                    {
                        MessageBox.Show("密码错误，请重新输入。", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        txtPassword.Focus();
                        return;
                    }
                    else
                    {
                        reader.Close();
                        connection.Close();
                        this.Hide();
                        frmAdmin newFrmAdmin = new frmAdmin();
                        newFrmAdmin.Show();
                    }
                }
            }

调试时说From子句语法错误！

请各位帮助

在能是sql语句中出现了关键字了，你把这句改改：

            cmd.CommandText = " select UserID, UserPassword "+
                " from User"+
                " where UserID='" + txtUserName.Text;

改为如下的语句再试一下，这里没有数据也没办法为你调试：

            cmd.CommandText = " select [UserID], [UserPassword] "+
                " from [User]"+
                " where [UserID]='" + txtUserName.Text;

以上是在数据表中的字段加上[]，以告知是字段而不是关键字

这个是winform的程序啊

谢谢了，我调试看看

谢谢leapApple，

8错，那里面的User是关键字，不能直接写

恩，[]还真好用，呵呵