110,534
社区成员
发帖
与我相关
我的任务
分享
为什么要用强类型dataset 貌似是net1.1的
List<实体类>不是更好么~
public static List<User> GetFailureWebIcon()
{
const string sql = "SELECT * FROM User";
List<User> list = new List<User>();
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Userentity = new User();
entity.ID = Convert.ToInt32(dr["ID"]);
entity.Name = dr["EntName"] as string;
... ...
list.Add(entity);
}
}
return list;
}