ADO.Net的一个简单问题publicstaticvoidselectUserByUserName(Usersu){SqlConnectioncon=newSqlConnection(DB.sqlConStr);stringsqlStr="select*fromUserswhereUserName='"+u.userName+"'";SqlDataAdapterda=newSqlDataAdapter(sqlStr,c

Question

ADO.Net的一个简单问题public static void selectUserByUserName(Users u) { SqlConnection con = new SqlConnection(DB.sqlConStr); string sqlStr = "select * from Users where UserName='"+u.userName+"'"; SqlDataAdapter da = new SqlDataAdapter(sqlStr,con); DataSet ds = new DataSet("User"); da.Fill(ds,"User"); DataRowView drv = ds.Tables["User"].DefaultView[0]; u.userID = int.Parse(drv.Row["UserID"].ToString()); u.userPwd = drv.Row["UserPwd"].ToString(); u.userGroup=int.Parse(drv.Row["UserGroup"].ToString()); u.userState=int.Parse(drv.Row["UserGroup"].ToString()); u.lastLogID=int.Parse(drv.Row["LastLogID"].ToString()); } 如果查找到记录就返回TRUE，反之就返回FALSE，改怎么做啊？

Answer 1

if(ds.Tables["User"].Rows.Count>0) { return true; } else { return false; }