From SQL reader to textbox using DataTable or something else

Rui Ruivo

Hi everyone

I am trying to read from a SQL reader into something so that i can iterate latter.
I dont know if this is the best idea but... I need to read all data from the reader:
A DataTable appears to be a good option so i tryed dataTable.load(reader) but i cannot read from the Table after that.

Can someone point me in the right direction ?

The final objective is to populate a panel with other controls each of theme displayed in a certain manner with the data i get from the SQL query, This is why i want to be able to read every single value.

Any help will be much apreciate.

Best regards

Rui

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Srinivasan Ramamoorthi4y ago
Now you should able to access the datatable in the page lifecycle events. Let me know if you have any issues
Rui Ruivo4y ago
I fixed part of it.

My first mistake is to do the dataTable.Load(reader); outside the while.
Then another mistake is was not to have while (!reader.IsClosed);
Srinivasan Ramamoorthi4y ago
You should be able to use data table and bind the value to any controls. Check the scope of the datatable before binding to the controls or you can return the datatable from the dataaccess method to UI layer and bind it.

If you want to persist in the datatable during the User session, store in Session.