DataSet 的使用

Question

DataSet ds1 = ...数据库//自定义
DataSet ds2 = new DataSet();ds2 = ds1.clone();
//prebalance<receivablemoney 数据库字段
DataRow[] dr1 = ds1.Tables[0].Select("prebalance<receivablemoney");...
问题：请教各位高手，怎样将dr1 存入ds2中？提前谢谢各位！

Answer 1

 protected void Page_Load(object sender, EventArgs e)
    {        string sqlAllCustomers = "SELECT * FROM adminMag";
        string cnStr = @"Data Source=fhj-2edfb3d5c20\sql2005;Initial Catalog=OA_DataBase;User ID=sa;Password=1";        using (SqlConnection cn = new SqlConnection(cnStr))
        {
            cn.Open();
            SqlCommand cmd = new SqlCommand(sqlAllCustomers, cn);
            SqlDataAdapter adpt = new SqlDataAdapter(cmd);
            DataTable dtCust1 = new DataTable("Customers");
            adpt.Fill(dtCust1);            dtCust1.PrimaryKey = new DataColumn[] { dtCust1.Columns["a_id"] };            DataTable dtCust2 = dtCust1.Clone();
            DataRow row1 = dtCust2.NewRow();
            row1["a_id"] = 4;
            row1["a_name"] = "Some Company";
            dtCust2.Rows.Add(row1);
            DataRow row2 = dtCust2.NewRow();
            row2["a_id"] = 5;
            row2["a_name"] = "Some Other Company";
            dtCust2.Rows.Add(row2);
            DataSet ds = new DataSet("MySillyDataSet");
            //ds.Tables.Add(dtCust1);
            //ds.Merge(dtCust2);
            //和下面的方法一样
            dtCust1.Merge(dtCust2);
            this.GridView1.DataSource = dtCust1;
            this.GridView1.DataBind();
        }    }看看，我的这个就明白了