Question

.net 连接sql数据库查询用那个SqlDataReader怎么往list里放

也就是 while(reader.read()){ stuInfo stu=new stuinfo stu.name=" "; stu.age = " "; } 里面怎么写 赋值

Answer 1

using (SqlDataReader reader = SQLHelp.ExecuteReader(CommandType.Text, sql))
{
List<Deal> list = new List<Deal>();

if (reader != null && !reader.IsClosed && reader.HasRows)
{
while (reader.Read())
{
list.Add(Fill(reader));
}
reader.Close();
}

return list;
}

Answer 2

循环添加 reader["Name"]

Answer 3

reader["Name"]