DataSets - Size Issue
-
I've been trying to find the best way to load data from SQL into a DataGridView. Obviously I could just load it into a DataSet with a SqlDataAdapter and set the dataSource of the DGV to the DataSet, but i'm having issues because there are 120,000 records that need to be loaded, and this takes quite a while to load DataSet from the adapter. I guess this isn't an issue with the DGV, but loading the data into the dataset. Nathan Lindley
-
I've been trying to find the best way to load data from SQL into a DataGridView. Obviously I could just load it into a DataSet with a SqlDataAdapter and set the dataSource of the DGV to the DataSet, but i'm having issues because there are 120,000 records that need to be loaded, and this takes quite a while to load DataSet from the adapter. I guess this isn't an issue with the DGV, but loading the data into the dataset. Nathan Lindley
-
Maybe you should only grab the number of records that you are going to display in the grid at a time?
-
Well i was going to have them be able to scroll through the list instead of forcing them to search for a specific set of records, but that seems to be the only way. Thanks Nathan Lindley
I guess my only other suggestions for making it faster are to make sure that you are selecting ONLY the columns that you absolutely need in the grid, and to do everything you can (in terms of formatting) in the SQL statement so that you do not have to loop through the records to format after you have retrieved them. Good Luck.
-
I guess my only other suggestions for making it faster are to make sure that you are selecting ONLY the columns that you absolutely need in the grid, and to do everything you can (in terms of formatting) in the SQL statement so that you do not have to loop through the records to format after you have retrieved them. Good Luck.