读书人

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

发布时间: 2013-11-09 17:06:34 作者: rapoo

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

?????????? 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();

读书人网 >编程

热点推荐