登录窗口中,验证输入的ID和PASSWORD是否与数据库lczf里的User表的一致,代码如下:

[align=left]public partial class FormLogin : Form

[/align]

[align=left]
{

[/align]

[align=left]
#region Static Fields

[/align]

[align=left]
public static SqlConnection cnn;

[/align]

[align=left]
public static SqlDataAdapter da;

[/align]

[align=left]
public const string ConnectionString = "Data Source=LCZF;Initial Catalog=lczf;Integrated Security=True";

[/align]

[align=left]
#endregion

[/align]

[align=left]

[/align]

[align=left]
public FormLogin()

[/align]

[align=left]
{

[/align]

[align=left]
InitializeComponent();

[/align]

[align=left]
}

[/align]

[align=left]

[/align]

[align=left]

[/align]

[align=left]
private void buttonLogin_Click(object sender, EventArgs e)

[/align]

[align=left]
{

[/align]

[align=left]
string name = textBoxLoginName.Text, word = textBoxLoginPassWord.Text;

[/align]

[align=left]

[/align]

[align=left]
cnn = new SqlConnection();

[/align]

[align=left]
cnn.ConnectionString = ConnectionString;

[/align]

[align=left]
cnn.Open();

[/align]

[align=left]
SqlCommand cmd = cnn.CreateCommand();

[/align]

[align=left]
= "SELECT UserName,PassWord FROM User";

[/align]

[align=left]
SqlDataReader dr = cmd.ExecuteReader();

[/align]

[align=left]
while (dr.Read())

[/align]

[align=left]
{

[/align]

[align=left]
if ((dr.GetValue(0).ToString()) == (name.ToString()))

[/align]

[align=left]
{

[/align]

[align=left]
if (dr.GetValue(1).ToString() == (word.ToString()))

[/align]

[align=left]
{

[/align]

[align=left]
textBoxLoginName.Text = "true";

[/align]

[align=left]
}

[/align]

[align=left]
}

[/align]
}

运行后错误出现在:  SqlDataReader dr = cmd.ExecuteReader();
错误提示:          [size=3][font=宋体]在关键字 'User' 附近有语法错误。[/size][/font]
[size=3]
[/size]
[size=3][font=宋体]错误是否是出现在[size=2]public const string ConnectionString = "Data Source=LCZF;Initial Catalog=lczf;Integrated Security=True";[/size][/size][/font]
[font=宋体]还是在 = "SELECT UserName,PassWord FROM User";[/font]
[font=宋体]请各位DX指教
[/font]

谢谢楼上的兄弟指教!
我从别的地方知道了问题所在:User是个关键字,所以提示"在关键字 'User' 附近有语法错误。"
解决办法:  将user加上[ ]即可

谢谢告诉我解决办法的兄弟

我是按照楼上DX的做法解决的,即:  select * from [User]
不必改表名,加上[ ]就可以了

谢谢各位DX