ADO.NET高级程序设计读书笔记(二)

ADO.NET中支持DataReader作为数据源，同事支持批处理查询，之前没系统的看ADO.NET的时候都不知道，直到现在才知道，同时还支持将批处理查询保存在多个结果集中，分别作为不同的数据绑定控件的数据源。下面代码中用ArrayList作为数据源的时候DbDataRecord是需要声明命名空间using System.Data.Common

     protected   void  Page_Load( object  sender, EventArgs e)
     ... {
        //GridView1.AllowPaging = true;
        ArrayList ReadList = new ArrayList();
        SqlConnectionStringBuilder ConStr = new SqlConnectionStringBuilder();
        ConStr.DataSource = ".";
        ConStr.InitialCatalog = "NorthWind";
        ConStr.IntegratedSecurity = true;
        SqlConnection Con = new SqlConnection(ConStr.ToString());
        try
        ...{
            Con.Open();
            //批处理查询
            SqlCommand Cmd = new SqlCommand("SELECT customerid,address FROM Customers"+";"+"SELECT categoryid,categoryname FROM Categories", Con);
           // SqlDataReader Dr = Cmd.ExecuteReader(CommandBehavior.CloseConnection);
            SqlDataReader Dr = Cmd.ExecuteReader(CommandBehavior.KeyInfo);

            if (Dr.HasRows)
            ...{
                //*********************************
                //数据源为arraylist
                //foreach (DbDataRecord rec in Dr)
                //{
                //    ReadList.Add(rec);

                //}              
                //GridView1.DataSource = ReadList;
                //GridView1.DataBind();
                //************************************

                //**********************************
                //数据源为dataReader
                //while (Dr.Read())
                //{
                //    GridView1.DataSource = Dr;
                //    GridView1.DataBind();
                //}
                //************************************


                //******************************
                //dataReader的批处理查询
                    while (Dr.Read())
                    ...{
                        GridView1.DataSource = Dr;
                        GridView1.DataBind();
                       
                    }

                    if (Dr.NextResult())
                    ...{
                        GridView2.DataSource = Dr;
                        GridView2.DataBind();
                    }
                //********************************
            }

            Dr.Close();
        }
        catch (Exception ex)
        ...{
            throw ex;
        }
        finally
        ...{
            Con.Dispose();
        }
     
    }