求助

[过客823]

string ConnString = "Data Source=localhost;Initial Catalog=EmailMessage;User ID=sa;Password=sa";

SqlConnection Conn = new SqlConnection(ConnString);
Conn.Open();
string QueryStr = "select count(*) from TAB_UserInfo where UserID=" + TextBoxUserName.Text + "and+Password=" + TextBoxPassword.Text;

SqlCommand cmd = new SqlCommand(QueryStr, Conn);
int count = Convert.ToInt32(cmd.ExecuteScalar()); 最后一行 "="附近有语法错误

[porschev]

 string QueryStr = "select count(*) from TAB_UserInfo where UserID='" + TextBoxUserName.Text + "' and Password='" + TextBoxPassword.Text + "'";

[mngzilin]

and前面要有空格，后面加号换成空格，单引号的问题上面已经说了

[xlhkw]

and后少个"

[洪爷爷]

[Quote=引用 1 楼 porschev 的回复:]
C# code


string QueryStr = "select count(*) from TAB_UserInfo where UserID='" + TextBoxUserName.Text + "' and Password='" + TextBoxPassword.Text + "'";
[/Quote]

字符字段值要加单引号，别忘了结帖，，调试下有问题再问