C# DataReader

来源：互联网发布：nba2k16捏脸中国人数据编辑：程序博客网时间：2024/06/05 10:37

转自 http://www.cnblogs.com/BinBinGo/p/6399856.html

            //1   连接字符串            string connectionString                = "server=127.0.0.1;integrated security=true;database=MSPetShop4";            // = "server=.;uid=sa;pwd=SQL@5;database=AdventureWorks2012";            // = "server=.;user id=sa;password=SQL@5;database=AdventureWorks2012";            //2 实例化数据库连接            using(System.Data.SqlClient.SqlConnection connection = new SqlConnection(connectionString))            {                string sql = "SELECT 客户,产品,数量 FROM dbo.A";                connection.Open();                System.Data.SqlClient.SqlCommand command = new SqlCommand(sql, connection);                //通过数据库中的游标来辅助读取查询结果.                System.Data.SqlClient.SqlDataReader reader = command.ExecuteReader();                //DataReader 通过方法Read 来读取一行记录,Read方法返回结果为bool.DataReader 会自动进一取数据.                //读取到的数据保存在DataReader对象内                while(reader.Read())                {                    //通过                    string kh = reader.GetString(0);                    string cp = reader.GetString(1);                    int sl = reader.GetInt32(2);                    Console.WriteLine(kh + "," + cp + "," + sl);                }                //DataReader读取之后游标也需要关闭                reader.Dispose();            }            Console.ReadLine();

//1 连接字符串string connectionString ="server=127.0.0.1;integrated security=true;database=MSPetShop4";// = "server=.;uid=sa;pwd=SQL@5;database=AdventureWorks2012"; // = "server=.;user id=sa;password=SQL@5;database=AdventureWorks2012"; //2 实例化数据库连接using(System.Data.SqlClient.SqlConnection connection = new SqlConnection(connectionString)) { string sql = "SELECT 客户,产品,数量 FROM dbo.A"; connection.Open(); System.Data.SqlClient.SqlCommand command =new SqlCommand(sql, connection); //通过数据库中的游标来辅助读取查询结果. System.Data.SqlClient.SqlDataReader reader = command.ExecuteReader();//DataReader 通过方法Read 来读取一行记录,Read方法返回结果为bool.DataReader 会自动进一取数据. //读取到的数据保存在DataReader对象内while(reader.Read()) { //通过string kh = reader.GetString(0);string cp = reader.GetString(1);int sl = reader.GetInt32(2); Console.WriteLine(kh +"," + cp + "," + sl); }//DataReader读取之后游标也需要关闭 reader.Dispose(); } Console.ReadLine();

阅读全文

0 0