Question

请问各位大侠，这个问题该怎样解决？ 下面是asp.net采用三层架构 web.config配置文件

<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\xinwen.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />
下面是出现错误的代码
public int checkLogin(string loginName, string loginPwd) {
SqlConnection myConn = Getconnection(); SqlCommand myCmd = new SqlCommand("select count(*) from User where admin=@loginName and password =@loginPwd,myConn"); myCmd.Parameters.Add(new SqlParameter("@loginName", SqlDbType.VarChar, 20)); myCmd.Parameters["@loginName"].Value = loginName; myCmd.Parameters.Add(new SqlParameter("@loginPwd", SqlDbType.VarChar, 50)); myCmd.Parameters["@loginPwd"].Value = loginPwd; myConn.Open(); int i = (int)myCmd.ExecuteScalar(); myCmd.Dispose(); myConn.Close(); return i; }
错误类型

谁能帮忙解决一下！感谢了！

Answer 1

SqlCommand myCmd = new SqlCommand("select count(*) from User where admin=@loginName and password =@loginPwd,myConn");
上面的语句你最后一个双引号标错位置了
应改为
SqlCommand myCmd = new SqlCommand("select count(*) from User where admin=@loginName and password =@loginPwd",myConn);

Answer 2

楼上正解
myConn不应该是sql字符串中的内容

Answer 3

楼上正解
myConn不应该是sql字符串中的内容