Progress bar on filling dataset.. C# winforms

Question

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.....

Prabhu Raja · Answer

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

ansar mohiddin · Answer

Hi Faraz Please refer to the following link http://perschluter.com/show-progress-dialog-during-long-process-c-sharp/ R egards Ansar

Javeed M Shaikh · Answer

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.