public void SetCmd(OleDbConnection conn, OleDbCommand cmd, string sql)
{
if (conn.State != ConnectionState.Open)
{
conn.ConnectionString = strConn;
conn.Open();
}
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
}public void ExcRual0(string sql)
{
using (conn = new OleDbConnection(strConn))
{
cmd = new OleDbCommand();
SetCmd(conn, cmd, sql);
System.Web.HttpContext.Current.Response.Write(cmd.ExecuteNonQuery());
}
}obj DatArt = new obj();string name = txtAccount.Text.ToString();
string pwd = txtPwd.Text.ToString();
string sqlstring = "SELECT * FROM userinfo WHERE u_user=" + name + " AND u_pwd=" + pwd;
DatArt.ExcRual0(sqlstring);上面是我写的,可是一执行
string name = txtAccount.Text.ToString();
string pwd = txtPwd.Text.ToString();
string sqlstring = "SELECT * FROM userinfo WHERE u_user=" + name + " AND u_pwd=" + pwd;
DatArt.ExcRual0(sqlstring);
这个的时候就提示异常详细信息: System.Data.OleDb.OleDbException: 标准表达式中数据类型不匹配。源错误:
行 42: cmd = new OleDbCommand();
行 43: SetCmd(conn, cmd, sql);
行 44: System.Web.HttpContext.Current.Response.Write(cmd.ExecuteNonQuery());
行 45: }
行 46: }
{
if (conn.State != ConnectionState.Open)
{
conn.ConnectionString = strConn;
conn.Open();
}
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
}public void ExcRual0(string sql)
{
using (conn = new OleDbConnection(strConn))
{
cmd = new OleDbCommand();
SetCmd(conn, cmd, sql);
System.Web.HttpContext.Current.Response.Write(cmd.ExecuteNonQuery());
}
}obj DatArt = new obj();string name = txtAccount.Text.ToString();
string pwd = txtPwd.Text.ToString();
string sqlstring = "SELECT * FROM userinfo WHERE u_user=" + name + " AND u_pwd=" + pwd;
DatArt.ExcRual0(sqlstring);上面是我写的,可是一执行
string name = txtAccount.Text.ToString();
string pwd = txtPwd.Text.ToString();
string sqlstring = "SELECT * FROM userinfo WHERE u_user=" + name + " AND u_pwd=" + pwd;
DatArt.ExcRual0(sqlstring);
这个的时候就提示异常详细信息: System.Data.OleDb.OleDbException: 标准表达式中数据类型不匹配。源错误:
行 42: cmd = new OleDbCommand();
行 43: SetCmd(conn, cmd, sql);
行 44: System.Web.HttpContext.Current.Response.Write(cmd.ExecuteNonQuery());
行 45: }
行 46: }
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货