string NewConn = Server.MapPath("DB1.MDB");
string ConnectionStr = "Data Source =" + NewConn + ";Mode = Share Deny None;Jet OLEDB:Engine Type = 5;Provider = Microsoft.Jet.OLEDB.4.0";
OleDbConnection Conn = new OleDbConnection(ConnectionStr);//连接Access
Conn.Open();
string sql = "select * from member where user = 'Mary'";//Sql查询语句
OleDbDataAdapter Comm = new OleDbDataAdapter(sql, Conn); //执行SQL
DataSet ds = new DataSet();//建立数据集表
Comm.Fill(ds,"member");//将执行SQL后所得数据插入
Conn.Close(); Label1.Text = ds.Tables[0].Rows[0]["user"].ToString();
//将查询到第一个表某条记录中某字段赋值给Label1:
if (ds.Tables[0].Rows.Count < 1)
{
Response.Write("请注册!");
}
//如果为真,说明没有该记录(可用在注册时检验用户名是否已存在,但用在登录时则显示输入错
else
{
Response.Redirect("1.aspx");
}
//如果是注册则写入表红色部分要怎么写呢?这里是想做一个登录,如果查到数据库内有相应的条目就登录成功,如果没有就跳转到1.aspx...但现在无论输入对与错都跳到1.aspx里去了..哪里错了呢?
string ConnectionStr = "Data Source =" + NewConn + ";Mode = Share Deny None;Jet OLEDB:Engine Type = 5;Provider = Microsoft.Jet.OLEDB.4.0";
OleDbConnection Conn = new OleDbConnection(ConnectionStr);//连接Access
Conn.Open();
string sql = "select * from member where user = 'Mary'";//Sql查询语句
OleDbDataAdapter Comm = new OleDbDataAdapter(sql, Conn); //执行SQL
DataSet ds = new DataSet();//建立数据集表
Comm.Fill(ds,"member");//将执行SQL后所得数据插入
Conn.Close(); Label1.Text = ds.Tables[0].Rows[0]["user"].ToString();
//将查询到第一个表某条记录中某字段赋值给Label1:
if (ds.Tables[0].Rows.Count < 1)
{
Response.Write("请注册!");
}
//如果为真,说明没有该记录(可用在注册时检验用户名是否已存在,但用在登录时则显示输入错
else
{
Response.Redirect("1.aspx");
}
//如果是注册则写入表红色部分要怎么写呢?这里是想做一个登录,如果查到数据库内有相应的条目就登录成功,如果没有就跳转到1.aspx...但现在无论输入对与错都跳到1.aspx里去了..哪里错了呢?
string NewConn = Server.MapPath("DB1.MDB");
string ConnectionStr = "Data Source =" + NewConn + ";Mode = Share Deny None;Jet OLEDB:Engine Type = 5;Provider = Microsoft.Jet.OLEDB.4.0";
OleDbConnection Conn = new OleDbConnection(ConnectionStr);//连接Access
Conn.Open();
string sql = "select * from member where user = 'Mary'";//Sql查询语句
OleDbCommand cmd=new OleDbCommand(sql,Conn);
OleDbDataReader dr= cmd.ExecuteReader(); //执行SQL
if(dr.read())
Response.Redirect("1.aspx");
else
Response.Write("请注册!");
dr.close();
Conn.Close();
if (ds.Tables[0].Rows["name"] != "") //看一下如果为空,就是没找到对应的数据.
{
那要怎么改呢..难道赋值不要- -?其实这个count我没看懂...