如何将值存储到一个数据表到另一个数据表? [英] how to store value in to one data table to another datatable?
本文介绍了如何将值存储到一个数据表到另一个数据表?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
DataTable dtdcnomissing = new DataTable();
dtdcnomissing.Clear();
dtdcnomissing = objRetailBAL.DCNOMissing(objRetailPL);
DataTable dtimport = new DataTable();
DataTable dtmissingreport = new DataTable();
for (int i = 0; i <= dtdcnomissing.Rows.Count - 1; i++)
{
dtmissingreport.Clear();
objRetailPL.dcnoint = Convert.ToInt32(dtdcnomissing.Rows[i]["id"].ToString());
dtmissingreport = objRetailBAL.DCNOMissingReport(objRetailPL);
dtimport = dtmissingreport.Clone();
foreach (DataRow dr in dtmissingreport.Rows)
{
dtimport.ImportRow(dr);
}
}
GVDCNoMissingReport.DataSource = dtimport;
GVDCNoMissingReport.DataBind();
我想将dtmissingreport数据表值存储到dtimport datatable中......但是我没有得到正确的结果.. 。我怎么能存储这个..
I want to store dtmissingreport datatable values into dtimport datatable ...but i am not getting the correct result...How can i store this..
推荐答案
try
{
DataTable dtdcnomissing = new DataTable();
dtdcnomissing.Clear();
dtdcnomissing = objRetailBAL.DCNOMissing(objRetailPL);
DataTable dtimport = new DataTable();
DataTable dtmissingreport = new DataTable();
for (int i = 0; i <= dtdcnomissing.Rows.Count - 1; i++)
{
dtmissingreport.Clear();
objRetailPL.dcnoint = Convert.ToInt32(dtdcnomissing.Rows[i]["id"].ToString());
dtmissingreport = objRetailBAL.DCNOMissingReport(objRetailPL);
if (dtimport.Rows.Count == 0)
dtimport = dtmissingreport.Clone();
foreach (DataRow dr in dtmissingreport.Rows)
{
dtimport.ImportRow(dr);
}
}
GVDCNoMissingReport.DataSource = dtimport;
GVDCNoMissingReport.DataBind();
}
这篇关于如何将值存储到一个数据表到另一个数据表?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文