将一张表的一列值赋给另一张表的一列

           DataTable  dt1 = new DataTable();    
            dt1 = userpursecollection.DataTable; //获取的是一个表的数据
            dt2.Columns.Add("amount");
            dt2.Columns.Add("transferid");
            dt2.Columns.Add("createtime");
            foreach (DataRow col in dt1.Rows)
            {
                DataRow row = dt2.NewRow();
                row["amount"] = col["amount"];
                row["transferid"] = col["transferid"];
                row["createtime"] = col["createtime"];
                dt2.Rows.Add(row);
               
            }
            DataList1.DataSource = dt2;
            DataList1.DataBind();