DataTableReader is invalid for current DataTable
-
hi, I am trying to get the data from datatable in to DataTableReader so i can read the data like datareader. I am getting error "DataTableReader is invalid for current DataTable" when trying to call the GetValues method on DataTableReader. Please shed some light. If it helps here is my code in C# 2.0 public void Execute() { using (DataTableReader dataTableReader = new DataTableReader(myDataTable)) { object[] values = new object[dataTableReader.FieldCount]; int fieldCount = dataTableReader.GetValues(values); string id= values[4].ToString(); string Type = values[0].ToString(); } } i am poppulating a datatable from SQL 2000 database and is getting 4 rows back ( i can see that in datatable viewer in debug mode). I am also able to get the field count on datatableReader which is 6 (=number of columns). However, when i get to the point where i need to get the values from the dataTableReader using dataTableReader.GetValues(values), that's where it breaks up and states "DataTableReader is invalid for current DataTable" Please shed some light
Thanks Needy