异常详细信息: System.Data.SqlClient.SqlException: ',' 附近有语法错误。源错误:
行 30: SqlCommand cmd =new SqlCommand (sql,conn);
行 31: int num = 0;
行 32: num = (int)cmd.ExecuteScalar();
行 33: conn.Close();
行 34: if (num<0)源文件: c:\Users\stone\Desktop4\登录.aspx.cs 行: 32
行 30: SqlCommand cmd =new SqlCommand (sql,conn);
行 31: int num = 0;
行 32: num = (int)cmd.ExecuteScalar();
行 33: conn.Close();
行 34: if (num<0)源文件: c:\Users\stone\Desktop4\登录.aspx.cs 行: 32
試試
贴出来看看
{
string username = TextBox1.Text;
string password = TextBox2.Text;
using (SqlConnection conn = new SqlConnection(@"Data Source=STONE-PC\SQLEXPRESS;Initial Catalog=db_11_Data;Integrated Security=True;Pooling=False"))
{
conn.Open();
string sql = "select count (*) from Users where userName='"+username+"',and passWord='"+password+"'";
SqlCommand cmd =new SqlCommand (sql,conn);
int count = 0;
count = cmd.ExecuteScalar();
conn.Close();
}
源代码是这样的 老是报 count = cmd.ExecuteScalar(); 这里的错误!!
num = (int)cmd.ExecuteScalar();=>int num ;
int.TryParse((cmd.ExecuteScalar()??"").ToString(),out num);
其实3楼都已经告诉你sql错了,sql语句可以在数据库工具如management studio 中执行一下,可以检查一下错误