Add the row to the datatable..

Question

Hi... I am a new learner.. i want to know how to insert the row in one DataTable after validation of each row in the database... i want to add row one by one...

Ravi Kumar · Answer

hi below example will add 10 rows in datatable DataTable dt = new DataTable(InvoiceBill); for (int i=0;i { DataRow row = dt.NewRow(); dt.Rows.Add(row); }

Vipul Malhotra · Answer

DataTable dtTable = new DataTable(); DataRow dtNewRow = dtTable.NewRow(); //add data to dtNewRow now. dtTable.Rows.Add(dtNewRow); This might be of more help. Please mark this as answer if it helps

Karthi Keyan · Answer

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..

Priyaranjan K S · Answer

Please share the code you are using . Are you trying to update the row or are you creating a new row in the DB table ?

Vipul Malhotra · Answer

Please share the code that you are using for inserting a new row in the DataTable. It seems that you are simply putting data in the DataTable whereas you need to use the below steps: 1. Create a new DataRow for that particular DataTable. 2. Add data to this newly created DataRow. 3. Add this DataRow to the DataTable. Please let me know in case of any concerns.

Karthi Keyan · Answer

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.

Priyaranjan K S · Answer

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