Dataset, DataReader, DataTable and XML
?Objective: Populate Grid from database
1. I am always giong to use one table so does it make sence to use data table in stead of data set. I can banch mark this but i would like to know your opinion. I have always used dataset so if i use data table now then may be in future i will get stuck with some constrain.
2. is it safe to assume that datatable will give me all those functionalities and properties as dataset.
3. Someone suggested i should use XML files instead, so like when a result set comes back from my database i should carete an xml file and bind that to my grid. As I have not done this before I am not raelly up for it but if i do use it do you think it will be a big performence difference?
4. datareader at all ? as i will be doing inserting , updating deleting
If u r further intrested in my solution then read below:
main objective : display reports in the grid based on selection criteria
report can be 10,000 rows
Currently I m using ASP.NET GridView contrl with AJAX and backend is SQL Server.
On page load I will display all the record in gridview and then filter that on client side.
i will appriciate any suggestions or critics.
all i m doing is trying to be a better developer
Peace