使用DataReader读取数据
List<User> allUsers = new List<User>();
SqlConnection conn = new SqlConnection(连接字符串);
SqlCommand cmd = new SqlCommand("SELECT语句",conn);
conn.Open();
using(SqlDataReader rdr = cmd.ExecuteReader())
{
while(rdr.Read())
{
User u = new User();
user.Id = (int)rdr["Id"];
user.LoginId = (string)rdr["LoginId"];
user.LoginPwd = (string)rdr["LoginPwd"];
user.Name = (string)rdr["Name"];
user.Address = (string)rdr["Address"];
user.Phone = (string)rdr["Phone"];
user.Mail = (string)rdr["Mail"];
user.UserRoleId = (int)rdr["UserRoleId"];
user.UserStateId = (int)rdr["UserStateId"];
allUsers.Add(u);
}
}
conn.Close();
return allUsers;
======================================================
SqlConnection conn = new SqlConnection(连接字符串);
SqlDataAdapter adapter = new SqlDataAdapter("SELECT语句",conn);
DataSet ds = new DataSet();
adapter.Fill(ds,"表名");
return ds.Tables[0];
最新文章
- leetcode算法分类
- iOS 视图与视图层次结构(内容根据iOS编程)
- WPF中的image控件的Source赋值
- hosts 本机DNS域名解析
- MapReduce、Hbase接口API实践
- gpg的一些常用操作
- My Sql 1067错误兼编码问题解决
- wuzhicms短信API 实例调用
- AndroidAnnotations部署
- 暑假集训(2)第一弹 -----Is It A Tree?(Poj308)
- C连接MySQL数据库开发之Linux环境完整示例演示(增、删、改、查)
- ZOJ-2587-Unique Attack(最小割的唯一性)
- 1_3 C语言解决求n!
- TypeScript知识点
- css 椭圆样式
- linux软连接
- php字符编码转换之gb2312转为utf8(转)
- Python Flask Jinja2模板引擎
- 51nod 1667 概率好题
- 数据库case,when学习