What is common mistake in implement Datagrid?
Select an image from your device to upload
1: Binding the datagrid to a datareader instead of dataset, because the datareader is connected, i.e. you have to keep the connection open while the grid is there, while the dataset is disconnected, you can close the connection as soon as you have the data.
2: if you have huge number of records, don't use the normal paging technique, because even if you make the paging for every 50 records, each time you request the bind of the grid, it brings all the data from the server, so you have to use custom-paging in order to bring only current data.