动态把一个databale复制到另一个databale

比较笨的办法，自己先创建一个datatable ，然后把数据库读到的datatable写入其中，就可以实现动态绑定列了

 protected void Page_Load(object sender, EventArgs e)
    {

 datatable  dtbing = new DataTable();

        dtbing.Columns.Add(“1”, Type.GetType("System.Int32"));
        dtbing.Columns.Add(”mingchengid“, Type.GetType("System.String"));
        dtbing.Columns.Add(“panname”, Type.GetType("System.String"));
        dtbing.Columns.Add(”weiname“, Type.GetType("System.String"));
        dtbing.Columns.Add(“ceshi1”, Type.GetType("System.String"));

        dtbing.Columns.Add(”ceshi2“, Type.GetType("System.String"));
        dtbing.Columns.Add(ceshi3, Type.GetType("System.String"));
        dtbing.Columns.Add(ceshi4, Type.GetType("System.String"));

        dtbing.Columns.Add(ceshi5, Type.GetType("System.String"));
        dtbing.Columns.Add(ceshixiangmuyi, Type.GetType("System.String"));
        dtbing.Columns.Add(ceshixiangmuer, Type.GetType("System.String"));

        dtbing.Columns.Add(ceshixiangmusan, Type.GetType("System.String"));
        dtbing.Columns.Add(bidui, Type.GetType("System.String"));
        dtbing.Columns.Add(fuzhi, Type.GetType("System.String"));

        dtbing.Columns.Add(shijian, Type.GetType("System.String"));
        dtbing.Columns.Add(ceshilunciid, Type.GetType("System.String"));
        dtbing.Columns.Add(yiqiname, Type.GetType("System.String"));

    }

 

 protected void Button1_Click(object sender, EventArgs e)//填充
    {                 SqlCommand cmd = new SqlCommand("select * from tabres where 激光器id="+TextBox3.Text,con);
                SqlDataAdapter sda = new SqlDataAdapter(cmd);
                DataSet ds = new DataSet();
                sda.Fill(ds);
                getvalues(ds.Tables[0]);

}

void getvalues(DataTable dtt)
    {
       // int a = ds.Tables[0].Rows.Count;
        for (int i = 0; i < dtt.Rows.Count; i++)
        {
            DataRow dr = dtbing.NewRow();
            dr[0] = dtt.Rows[i][0];
            dr[1] = dtt.Rows[i][1];
            dr[2] = dtt.Rows[i][2];
            dr[3] = dtt.Rows[i][3];
            dr[4] = dtt.Rows[i][4];
            dr[5] = dtt.Rows[i][5];
            dr[6] = dtt.Rows[i][6];
            dr[7] = dtt.Rows[i][7];
            dr[8] = dtt.Rows[i][8];
            dr[9] = dtt.Rows[i][9];
            dr[10] = dtt.Rows[i][10];
            dr[11] = dtt.Rows[i][11];
            dr[12] = dtt.Rows[i][12];
            dr[13] = dtt.Rows[i][13];
            dr[14] = dtt.Rows[i][14];
            dr[15] = dtt.Rows[i][15];
            dr[16] = dtt.Rows[i][16];

            dtbing.Rows.Add(dr);

        }
        GridView2.DataSource = dtbing;
        GridView2.DataBind();
    }