怎么判断数据是否存在???
username=TextBox1.Text;
pwd=TextBox2.Text;
OleDbConnection myConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+ Server.MapPath("new.mdb"));
string sql="slecle * from userlist where username="+username+"' and pwd="+pwd+""
OleDbDataAdapter myCommand = new OleDbDataAdapter(sql, myConnection);
DataSet ds = new DataSet();
帮我写完,谢谢了
问题点数:20、回复次数:6Top
1 楼cjol(我是谁)回复于 2005-01-28 11:47:42 得分 0
快来个人帮帮我呀,谢谢了Top
2 楼yanyzty(歪打正着)回复于 2005-01-28 11:53:27 得分 10
string sql="slecle count(*) from userlist where username="+username+"' and pwd="+pwd+""
OleDbDataAdapter myCommand = new OleDbDataAdapter(sql, myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds);
if(ds.Tables[0].Rows[0][0].Tostring=="0")
//无此用户Top
3 楼cjol(我是谁)回复于 2005-01-28 11:56:00 得分 0
不对吧,Top
4 楼wjssong()回复于 2005-01-28 11:58:53 得分 10
myCommand .SelectCommand = cmd;
myCommand .Fill(ds, "login");
if (ds.Tables("login").Rows.Count > 0)
//有记录
else
//没有记录
Top
5 楼AllenTing(今天你GC了吗???)回复于 2005-01-28 11:59:45 得分 0
myCommand.Fill(ds,"aa");
if(ds["aa"].Rows.Count>0)//有数据
{
}Top
6 楼pingnt(淡蓝色的雪)回复于 2005-01-28 12:00:33 得分 0
...
OleDbDataAdapter myCommand = new OleDbDataAdapter(sql, myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds);
if(ds.Tables[0].Rows.Count<=0)
//数据不存在Top




