Question

简单的ASP.nit 登录代码；实现功能为从表中查询注册信息，实现登录 没分了。不好意思啊 请大虾们帮帮忙啊

Answer 1

OleDbConnection conn = new OleDbConnection("provider=microsoft.jet.oledb.4.0; data source=数据库");
OleDbCommand cmd = new OleDbCommand("select count(*) from 表 where users=1 and pwd=1", conn);
conn.Open();
int s=0;
s = int.Parse(cmd.ExecuteScalar().ToString());
if(s>0)
Response.Write("登陆成功");
else Response.Write("登陆失败");