Filling a specific column of a datatable with data

Question

how would I fill the second column of data in a datatable.

I can fill the first by

foreach (int somevalue in somelist)

{

   mytable.rows.add(somevalue);

}

what about adding data to the second column later?

---

chuckdawit

Answer 1

You should notice it that your somelist should be something like Array，and then you can do that very easy！

But please make sure that YOUR ARRAYLIST'S COUNT SHOULD BE EQUAL OR LESS THAN THAT OF COLUMNS OF A DATATABLE！

 DataTable dt = new DataTable();
            //Suppose two columns……
            dt.Columns.Add("id", typeof(int));
            dt.Columns.Add("name",typeof(string));

            //An array
            ArrayList al = new ArrayList();
            al.Add(1);
            al.Add("DDDD");
            dt.Rows.Add(al.ToArray());

See MSDN of DataRowCollection' Add method——

public DataRow Add(
	params Object[] values
)

---

   QQ我：
下载MSDN桌面工具(Vista,Win7)
我的博客园
慈善点击，点击此处

Answer 2

Simple,

int i=0;
foreach (int somevalue in somelist)
{ 
   mytable.rows[i++][1] = somevalue;  //Add value to second column of each row
 }

---

Please mark this post as answer if it solved your problem. Happy Programming!

Answer 3

or:

DataTable table = new DataTable();
//create columns and fill it...
for (int i = 0; i < table.Rows.Count; i++)
{
     table.Rows[i][1] = "some value";
}

---

Mitja