![ADO.Net读取器获取数据库数据 ADO.Net读取器获取数据库数据](https://image.shishitao.com:8440/aHR0cHM6Ly9ia3FzaW1nLmlrYWZhbi5jb20vdXBsb2FkL2NoYXRncHQtcy5wbmc%2FIQ%3D%3D.png?!?w=700&webp=1)
string str = Configuration.ConfigurationManager.AppSettings[str].ToString();
string sql = "select * from company";
List<UserInfo> uf = new List<UserInfo>();
using (SqlConnection con = new SqlConnection(str))
{
using(SqlCommand cmd = new SqlCommand (sql,con))
{
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
UserInfo uInfo = new UserInfo();
uInfo.cName = dr[0].ToString();//姓名//..
uf.Add(uInfo);
}
}
}
return uf;