Add the row to the datatable..

hi

below example will add 10 rows in datatable 

 

DataTable dt = new DataTable("InvoiceBill");

 

dt.Rows.Add(row);

} 

DataTable dtTable = new DataTable();

DataRow dtNewRow = dtTable.NewRow();

//add data to dtNewRow now.

 

dtTable.Rows.Add(dtNewRow);

 

This might be of more help.

 

 

 

yes.. i have simply add the data to the datatable.. ok.. i  going to do this with DataRow. 

i will reply after i complete. 

 

Thank you.. 

Brother,

               i explain clearly.. i am maintaining table in sql, and one datatable. there are many rows in sql table. first, i validate one row in database, if it is correct then store the values in datatable.  then again going to the db for validating if it's correct then want to store the values in the next row of the same datatable. i am using the for loop. at the second time of storing in datatable, the value is not inserting its updating. help me to solve this pblm.

Hi,

 

You may use this link to see how to update to the SQL .

http://www.rhyous.com/2012/06/06/how-to-insert-table-rows-using-a-datatable-in-csharp/

 

You may use this link to comapre the sql table with the front end Datatable for validations .Check the reply by rofansmanao .

http://stackoverflow.com/questions/9075159/how-to-insert-a-data-table-into-sql-server-database-table

 

Thanks,

Priyan

 

If you found this useful Please mark this as Answer