//查询所有用户数据
public static List<UserInfo> GetAll()
{
string strSql = "SELECT USERID,USERNAME,PASSWORD FROM USERINFO";
DBHelper db = AppRoot.DBConnect;
IDataReader dr = db.DoQuery(strSql);
List<UserInfo> users = new List<UserInfo>();
while (dr.Read())
{
UserInfo userInfo = new UserInfo();
userInfo.UserName = dr["USERID"].ToString();
userInfo.UserName = dr["USERNAME"].ToString();
userInfo.Password = dr["PASSWORD"].ToString();
users.Add(userInfo);
}
dr.Close();
return users; }请问这样写是否正确?
public static List<UserInfo> GetAll()
{
string strSql = "SELECT USERID,USERNAME,PASSWORD FROM USERINFO";
DBHelper db = AppRoot.DBConnect;
IDataReader dr = db.DoQuery(strSql);
List<UserInfo> users = new List<UserInfo>();
while (dr.Read())
{
UserInfo userInfo = new UserInfo();
userInfo.UserName = dr["USERID"].ToString();
userInfo.UserName = dr["USERNAME"].ToString();
userInfo.Password = dr["PASSWORD"].ToString();
users.Add(userInfo);
}
dr.Close();
return users; }请问这样写是否正确?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货