DataTable Show Empty Data

Sudheer Vasam

10y972.NET

0down votefavorite

if(session["cart"]!=null) {

DataTable da = new DataTable();

DataTable dtb = (DataTable)Session["cart"];

da = dtb.Clone();

DataRow dr = da.NewRow();

dr["ProductName"] = ds.Tables[0].Rows[0]["ProductName"];

dr["ProductImages"] = ds.Tables[0].Rows[0]["ProductImage"];

dr["Price"] = ds.Tables[0].Rows[0]["Price"];

da.Rows.Add(dr);

foreach(DataRow row in da.Rows )

   dt.ImportRow(row);

return dt;

}

Here dt comes with an Emptydata..............

Structure of datatable dt is .......

dt.Columns.Add("ProductImages", typeof(string));

dt.Columns.Add("ProductName", typeof(string));

dt.Columns.Add("Price", typeof(double));

c#-4.0

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Accepted answer

use

da = dtb.copy();// it contains schema and data both

Instead of da = dtb.Clone(); //because clone conatins only schema not data .

sourabh choubey10y ago
at first check that u have record in your datatable or not......
Vinay Singh10y ago
Hi
Try the below code
DataTabledt=newDataTable();
dt.Clear();
dt.Columns.Add("CountryName");
dt.Columns.Add("Population");
dt.Columns.Add("Code");
DataRowdataRow1=dt.NewRow();
dataRow1["CountryName"]="India";
dataRow1["Population"]="125Cr";
dataRow1["Code"]="IN";
dt.Rows.Add(dataRow1);
DataRowdataRow2=dt.NewRow();
dataRow2["CountryName"]="Pakistan";
dataRow2["Population"]="50Cr";
dataRow2["Code"]="PK";
dt.Rows.Add(dataRow2);
DataRowdataRow3=dt.NewRow();
dataRow3["CountryName"]="UnitedStates";
dataRow3["Population"]="25Cr";
dataRow3["Code"]="US";
dt.Rows.Add(dataRow3);
For detail check the link
How To Add Data In Datatable In C#.Net