Progress bar on filling dataset.. C# winforms

Faraz Akram

15y24.5kAzure

hi,
I am filling a dataset like (dataset.tableadapter.fill()) it is taking much time .... i need to show and fill a progress bar on a separat thread while adapter is filling and done once completed..

any help from MARS.. :)

would be encouriging.....

3 Replies

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

ansar mohiddin13y ago
Hi Faraz,

Please refer to the following link

http://perschluter.com/show-progress-dialog-during-long-process-c-sharp/

Regards,
Ansar
0
Prabhu Raja15y ago
Hi,

I had used ProgressBar, While Loading Data into the Datatable.But i doesn't have Experience in showing ProgressBar for DataAdapter.fill(). But i suggest a Link and Code Snippets, Hope It will Help You.

Try this Link, Which may help you

I have given a Sample Code Snippet, What i tried:

SqlConnection con = New SqlConnection( "Your Connection String");
SqlCommand cmd = new SqlCommand("select getDate() as CurrentDate", conn);
SqlDataReader da = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Columns.Add("column1", typeof(DateTime));

this.progressBar1.Value = 0;
while (da.Read())
{
DataRow tempRow = dt.NewRow();
tempRow[0] = Convert.DateTime(da[0].ToString());
dt.Rows.Add(tempRow);
this.progressBar1.Value++;
}
ds.Tables.Add(dt);
// sda.Fill(ds);
this.GridView1.DataSource = ds.Tables[0];

----------------------------------------------------------------
If this post helps you, then mark as "Correct Answer"
Thank You
0
Javeed M Shaikh15y ago
Fill the dataset in a separate thread and meanwhile in the interface thread run a loop that would check the target table row count and update the progress bar correspondingly.

Use either event OnRowUpdating or OnRowUpdated to fill your progress bar and PerformStep.

Please do not forget to mark "Accepted Answer".
0