如何合并两个DataSet数据集

创建DataSet对象两种方法：

【1】初始化DataSet类的新实例：public DataSet()

【2】用给定的名称初始化DataSet类的新实例：public DataSet(string)  

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

合并两个DataSet的实例：

      protected void Button4_Click(object sender, EventArgs e)
        {
            //合并
            string conString = "data source=127.0.0.1;database=codematic;user id=sa;password=";
            SqlConnection myConnection = new SqlConnection(conString);
            myConnection.Open();

            string strSQL = "SELECT * FROM P_Product";
            DataSet ds1 = new DataSet();
            SqlDataAdapter adapter1 = new SqlDataAdapter(strSQL, myConnection);
            adapter1.Fill(ds1, "Product");

            strSQL = "SELECT * FROM P_Category";
            DataSet ds2 = new DataSet();
            SqlDataAdapter adapter2 = new SqlDataAdapter(strSQL, myConnection);
            adapter2.Fill(ds2, "Category");

            myConnection.Close();

            ds1.Merge(ds2, true, MissingSchemaAction.AddWithKey);//ds1就是合并后的DataSet了

            GridView1.DataSource = ds1.Tables["Product"];
            GridView1.DataBind();

            GridView2.DataSource = ds1.Tables["Category"];
            GridView2.DataBind();

        }