CODEWITHSUNDEEP
c#asp.net
ramarao
ramarao

Reputation: 63

how to store value in to one data table to another datatable?

 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);
            dtimport = dtmissingreport.Clone();
            foreach (DataRow dr in dtmissingreport.Rows)
            {
                dtimport.ImportRow(dr);
            }
        }

        GVDCNoMissingReport.DataSource = dtimport;
        GVDCNoMissingReport.DataBind();


    }

I want to store dtmissingreport datatable values into dtimport datatable ...but i am not getting the correct result...How can i store this..

Upvotes: 1

Views: 605

Answers (2)

Sambasiva
Sambasiva

Reputation: 1044

Try this below code..

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


}

Upvotes: 1

Hiral Nayak
Hiral Nayak

Reputation: 1072

Try Copy() instead of Clone() 

DataTable dtNew=yourOldDL.Copy();//it will copy data and structure

DataTable dtNew=yourOldDL.Clone();//it will copy structure only

Upvotes: 1

Related Questions