C# Web App: How to go through for loop adding string to datarow??

[dmj07]

Hi,

I need some help in creating a dataset that I can bind to a datalist after it has added a set of strings to it:

DataSet ds = new DataSet();
DataTable dt = new DataTable("table");
ds.Tables.Add(dt);
dt.Columns.Add("id");
dt.Columns.Add("description");
dt.Columns.Add("price");
 
for (int i = 0; i < Data.Count; i++)
{
string id = sourceofdata[i].id  //Here is the main problem ** needs to be a cell item
 
string description = sourceofdata[i].description
}
 
DataList1.Datasource = ds;
DataList1.DataBind();

[vekipeki]

Use the DataTable.NewRow() method to get a new row instance for that table, then set the individual columns for that row, something like this:

for (int i = 0; i < sourceOfData.Length; i++)
{
    DataRow dRow = dt.NewRow();
    dRow["id"] = sourceOfData[i].Id;
    dRow["description"] = sourceOfData[i].Desc;
    dRow["price"] = sourceOfData[i].Price;
    dt.Rows.Add(dRow);
}
 
dataList.DataSource = dt; // bind to a table
 

[DonBytes]

If sourceofdata is another table that looks the same you can use:

foreach (DataRow dr in sourceofdata.Rows)
{
...
}

if it's another DataSet:

foreach (DataRow dr in sourceofdata.Tables[0].Rows)
{
...
}

Change 0 to the index you want or the name of the table as string.

[jcatubay]

Hi did anyone have any problem using this code?

for (int i = 0; i < sourceOfData.Length; i++)
{
DataRow dRow = dt.NewRow();
dRow["id"] = sourceOfData[i].Id;
dRow["description"] = sourceOfData[i].Desc;
dRow["price"] = sourceOfData[i].Price;
dt.Rows.Add(dRow);
}

Everytime I use this, the first dRow does not have any data, it's all null. But then the next time this executes "dt.Rows.Add(dRow); ", the one being inserted is the last dRow which is in i-1. So when I have 5 dRows, the first one is empty then then I'm not getting the last dRow.

I followed pretty much the exact code just the naming is different. What am I doing wrong?