index.aspx.cs
---------------------------
String uid,pwd,sql;
uid = userid.Text;
pwd=pass.Text;
sql = String.Format("select id from usertatil where uid ='{0}' and pwd ='{1}'",uid,pwd);
int i = Convert.ToInt32(DB.OleDbScalar(sql));
-----------------------------------------------------
DB.cs
-----------------------------------------------------
public static string OleDbScalar(String Sql)
{
OleDbConnection con = createcon();
OleDbCommand cmd = new OleDbCommand(Sql, con);
con.Open();
string i = Convert.ToString(cmd.ExecuteScalar());
con.Close();
return i;
}
---------------------
问题:
在int i = Convert.ToInt32(DB.OleDbScalar(sql));
提示如标题的错误
如果去掉where uid ='{0}' and pwd ='{1}'就不会出错
如果原来的查询中的'{0}','{0}'去掉"'"也不会错
如果不用传值写在一起也不会错
String uid,pwd,sql;
uid = userid.Text;
pwd=pass.Text;
sql = String.Format("select id from usertatil where uid ='{0}' and pwd ='{1}'",uid,pwd);
OleDbConnection con = DBcreatecon();
OleDbCommand cmd = new OleDbCommand(Sql, con);
con.Open();
string i = Convert.ToString(cmd.ExecuteScalar());
con.Close();请问这里要如何改
---------------------------
String uid,pwd,sql;
uid = userid.Text;
pwd=pass.Text;
sql = String.Format("select id from usertatil where uid ='{0}' and pwd ='{1}'",uid,pwd);
int i = Convert.ToInt32(DB.OleDbScalar(sql));
-----------------------------------------------------
DB.cs
-----------------------------------------------------
public static string OleDbScalar(String Sql)
{
OleDbConnection con = createcon();
OleDbCommand cmd = new OleDbCommand(Sql, con);
con.Open();
string i = Convert.ToString(cmd.ExecuteScalar());
con.Close();
return i;
}
---------------------
问题:
在int i = Convert.ToInt32(DB.OleDbScalar(sql));
提示如标题的错误
如果去掉where uid ='{0}' and pwd ='{1}'就不会出错
如果原来的查询中的'{0}','{0}'去掉"'"也不会错
如果不用传值写在一起也不会错
String uid,pwd,sql;
uid = userid.Text;
pwd=pass.Text;
sql = String.Format("select id from usertatil where uid ='{0}' and pwd ='{1}'",uid,pwd);
OleDbConnection con = DBcreatecon();
OleDbCommand cmd = new OleDbCommand(Sql, con);
con.Open();
string i = Convert.ToString(cmd.ExecuteScalar());
con.Close();请问这里要如何改
int i = Convert.ToInt32(DB.OleDbScalar(sql));
这一句错误