作者:乔山办公网日期:
返回目录:excel表格制作
将一个datatable的值赋给另一个datatable的三种方法总结:e68a84e8a2ade799bee5baa6e997aee7ad94363
方法一:new一个新行,给每个列去赋值。
DataTable dt1 = new DataTable();
DataTable dt2 = new DataTable();
DataRow NewRow = dt2.NewRow();
NewRow['ID'] = dt1.Rows[i]['ID'].ToString();
NewRow['No'] = dt1.Rows[i]['No'].ToString();
NewRow['Name'] = dt1.Rows[i]['Name'].ToString();
dt2.Rows.Add(NewRow);
方法二:克隆DataTable的表结构,再进行填值
DataTable dtCloneTable = new DataTable('NodeInfo');
dtCloneTable = dtInfo.Clone();
foreach (DataRow r in dtInfo.Rows)
{
DataRow r2 = dtCloneTable.NewRow();
r2.ItemArray = r.ItemArray;
dtCloneTable.Rows.Add(r2);
}
方法三:直接复制datatable
dt2 = dt1.Copy();
首先 datatable 需要百构建度 datacolumn
datatable dt=new datatable();
dt.columns.add(new datacolumn("列名"))
添加数版据()
{权
datarow dr=dt.newRows();
dr["xxx"]=xxx;
...
dt.Rows.Add(dr);
}
两个表的数复据结构需要一制样。百
C# code
DataTable dt1;
DataTable dt2;
DataRow row = dt1.Rows[X];
dt2.Rows.Add(row);
2008-12-04 01:35 推荐度: 0 次
苯办法了。知
C# code
DataRow row2 = dataTable2.NewRow();
for(int k = 0; k < row1.Table.Columns.Count)
{
row2[k] = row1[k]; // row1是dataTable1的道一行
}
dataTable2.Rows.Add(row2);
2008-12-04 01:35 推荐: 0 次
C# code
DataTable dt = new DataTable();
dr=所要添加到dt的DataRow。
dt.Rows.Add(dr.ItemArray);
//dataset导出EXCEL public void CreateExcel(DataSet ds, string FileType, string FileName) { //try //{ //HttpResponse resp; //resp = Page.Response; Response.Clear(); Response.Charset = "UTF-8"; Response.Buffer = true; Response.Co...