This code improves data loading for large database, very useful for windows applications which do not implement paging ffor data grids.
private DataTable dt = null;
private void LoadGrid(object sender, DoWorkEventArgs e)
{
dt = ...;
}
private void WorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
dgView.DataSource = dt;
dgView.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
}
private void LoadinBackground()
{
System.ComponentModel.BackgroundWorker bgWrkr = new System.ComponentModel.BackgroundWorker();
bgWrkr.DoWork += new System.ComponentModel.DoWorkEventHandler(LoadGrid);
bgWrkr.RunWorkerCompleted += new System.ComponentModel.RunWorkerCompletedEventHandler(WorkerCompleted);
bgWrkr.RunWorkerAsync();
}