ado.net datacolumn   

string strConn, strSQL;
strConn = @"Data Source=Gigs-PC;Initial Catalog=Northwind;Integrated 
Security=True;";
strSQL = "SELECT OrderID, CustomerID FROM Orders";

SqlDataAdapter da = new SqlDataAdapter(strSQL, strConn);
DataSet ds = new DataSet();
DataTable tbl = ds.Tables.Add("Customers");
DataColumn col = tbl.Columns.Add("CustomerID");
DataColumn col1 = tbl.Columns.Add("OrderID");
DataRow row = tbl.Rows.Add("10");
DataRow row1 = tbl.Rows.Add("11");
DataRow row2 = col1.Table.Rows.Add("11");

foreach (DataRow roww in tbl.Rows)
     Console.WriteLine(roww["CustomerID"]);

foreach (DataRow roww in tbl.Rows)
     Console.WriteLine(roww["OrderID"]);


How I can add rows to OrderID column? Why is this code only adding rows to 
CustomerID?



thanks!

date: Thu, 31 Jul 2008 13:42:38 +0200   author:   gigs

Re: ado.net datacolumn   

The Add method takes a "params" array of values. Add the values for each 
column as so:

.Rows.Add("123","456");

where 123 goes in the first column (of the new row), and "456" into the 
second.

Marc

date: Thu, 31 Jul 2008 12:57:50 +0100   author:   Marc Gravell