Insert a new row into DataTable

Question

I have a datatable filled with staff data like..

Staff 1 - Day 1 - Total Staff 1 - Day 2 - Total Staff 1 - Day 3 - Total Staff 2 - Day 1 - Total Staff 2 - Day 2 - Total Staff 2 - Day 3 - Total Staff 2 - Day 4 - Total 

I want to modify so that the result would be sth like..

Staff 1 - Day 1 - Total Staff 1 - Day 2 - Total Staff 1 - Day 3 - Total Total   -       - Total Value Staff 2 - Day 1 - Total Staff 2 - Day 2 - Total Staff 2 - Day 3 - Total Staff 2 - Day 4 - Total Total   -       - Total Value 

to be concluded, I need to insert the total row at the end of each staff record.

So, my question is how to insert a row into a datatable? Tkz..

Answer 1

@William You can use NewRow method of the datatable to get a blank datarow and with the schema as that of the datatable. You can populate this datarow and then add the row to the datatable using .Rows.Add(DataRow) OR .Rows.InsertAt(DataRow, Position). The following is a stub code which you can modify as per your convenience.

//Creating dummy datatable for testing DataTable dt = new DataTable(); DataColumn dc = new DataColumn("col1", typeof(String)); dt.Columns.Add(dc);  dc = new DataColumn("col2", typeof(String)); dt.Columns.Add(dc);  dc = new DataColumn("col3", typeof(String)); dt.Columns.Add(dc);  dc = new DataColumn("col4", typeof(String)); dt.Columns.Add(dc);  DataRow dr = dt.NewRow();  dr[0] = "coldata1"; dr[1] = "coldata2"; dr[2] = "coldata3"; dr[3] = "coldata4";  dt.Rows.Add(dr);//this will add the row at the end of the datatable //OR int yourPosition = 0; dt.Rows.InsertAt(dr, yourPosition);