SqlDataReader对象可以绑定到数据集(如GridView)

 

           SqlDataReader对象可以绑定到数据集(如GridView)，

           代码如下：

 

           SqlConnection conn = new SqlConnection();
            conn.ConnectionString = ConfigurationManager.ConnectionStrings["teachConn"].ConnectionString;
            string strSql;

            strSql = "select s_no as 学号,s_name as 姓名,s_sex as 性别,s_birthday as 生日,s_department as 专业 from student where s_no=" +Int64.Parse(txtCheckCondition.Text.Trim().ToString());

            conn.Open();

            SqlDataReader dtReader = comm.ExecuteReader();

            //用SqlDataReader进行数据绑定,不能调用SqlDataReader的Read()方法(即dtReader.Read()),否则会错误的
            gvCheckCondition.DataSource = dtReader;
            gvCheckCondition.DataBind();
            dtReader.Close();
            dtReader.Dispose();           

            conn.Close();
            conn.Dispose();