Question

string sql = "select * from user where user_name='" +t1.Text.Trim()+ "' and user_password='"+t2.Tex

string sql = "select * from user where user_name='" +t1.Text.Trim()+ "' and user_password='"+t2.Text.Trim()+ "'";错在哪里啊？
protected void Button1_Click(object sender, EventArgs e)
{
string str="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server .MapPath ("App_Data/user.mdb");
OleDbConnection conn = new OleDbConnection(str);
conn.Open();
string sql = "select * from user where user_name='" +t1.Text.Trim()+ "' and user_password='"+t2.Text.Trim()+ "'";
OleDbCommand oledbcommand = new OleDbCommand(sql, conn);
OleDbDataReader rd = oledbcommand.ExecuteReader();
int add=0;
while (rd.Read()) { add++; }
if(add ==0){
Response .Write ("需要进入系统！");}
else
{ Response .Redirect ("index.aspx");

}
各位大侠，请帮小弟看看这段asp.net中的代码，我点登录按钮时总是提示“from子句错误”，多谢了

Answer 1

你看看你的SQL语言 那些 SELECT FROM WHERE 等等是不是没有大写！还有select前面怎么还有“”？引号的地方又几处错误 你自己再看看应该是“”真是漏洞太多 你自己仔细看看
你好 是不是你的数据库from里面的表格名字和编程数据不符合 你看看对照下 看看数据库此名字存在吗 编程错误奥自己慢慢找 大家都很忙 编程和数据库不断比对

Answer 2

string sql = "select * from [user] where [user_name]='" +t1.Text.Trim()+ "' and [user_password]='"+t2.Text.Trim()+ "'";