how to specify row in datatable

Question

how to specify row in datatable and move between datatable rows and can i give this row to datareader?

Jignesh Trivedi · Answer

hi, DataReader object provides a read only , forward only, high performance mechanism to retrieve data from a data store, so i think you cannot move data from datatable to datareader. to move datarow form one table to other table var logEntries = new DataTable() //Fill logEntries data table ... ... // Move Row from logEntries to datatable. var dataTable = new DataTable(); dataTable.Columns.Add("EntryType"); dataTable.Columns.Add("TimeGenerated"); dataTable.Columns.Add("Message"); dataTable.Columns.Add("Category"); for (int loop = logEntries.Count - 1; loop >= 0; loop--) { var row = new[] { logEntries[loop].EntryType.ToString(), logEntries[loop].TimeGenerated.ToString(), logEntries[loop].Message, logEntries[loop].Category }; dataTable.Rows.Add(row); } please refer http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q308909 hope this will help you.

how to specify row in datatable

Answers (1)