How to display progress bar whilw inserting multiple records to database

Question

0.00/5 (No votes)

See more:

Hi all,

Thanks in Advance,

Please give sample code for displaying the progress bar while inserting the multiple record to database,
Am insering multiple records by using for loop, on each loop an statement is inserted to database, untile the loop ends i have to display the progress bar how can i achive this, Please help,

Thanks in Adavance,
Siva

Posted 22-Mar-12 19:53pm

MemberCva

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Clifford Nelson · Answer 1 · 2012-03-22T20:20:00

Solution 2

In order to by a progress bar, you have to create it, either on the current form where you make it visible, or as a separate modal form (meaning cannot interact with parent form while modal form is open). If you want the progress bar to show progress, you really can't with a database call unless you break the inster/delete/etc into separate parts. Basically you have to do the progress bar yourself. Knowing true progress can be diffucult, and this is why many times you will see progress bars that do not appear linear; it is difficult to know what the progress really is. Wish that there was a feedback on SQL calls that would give progress.

ANother thing is that you will want to do the SQL call on a background thread, probably using a BackgroundWorker. Suggest you search the site for sameple code for background workers. Here is one article: BackgroundWorker Threads and Supporting Cancel[^]

Hope this helps.

Posted 22-Mar-12 20:20pm

Clifford Nelson

Comments

ProEnggSoft 23-Mar-12 2:35am

Good explanation and link to article. 5!

MemberCva 23-Mar-12 3:10am

Thanks Clifford Nelson ,

How can i implement this in asp.net.

MemberCva 23-Mar-12 3:17am

Thanks MaulikDusara,

This is my code i have used here total is the no of scripts to be inserted.

RadProgressContext progress = RadProgressContext.Current;
progress.Speed = "N/A";

for (int i = 0; i < total; i++)
{
progress.PrimaryTotal = 1;
progress.PrimaryValue = total;
progress.PrimaryPercent = 100;

progress.SecondaryTotal = total;
progress.SecondaryValue = i;
progress.SecondaryPercent = i;

progress.CurrentOperationText = Filename + " Step " + i.ToString();

if (!Response.IsClientConnected)
{
//Cancel button was clicked or the browser was closed, so stop processing
break;
}

progress.TimeEstimated = (total - i) * 100;
//Stall the current thread for 0.1 seconds
System.Threading.Thread.Sleep(100);
}

The scripts are inserted to db in another loop as u mentioned as datarows .
what else i have to do pls correct my codeing,

thanks in advance.
Siva

MaulikDusara · Answer 2 · 2012-03-22T20:19:00

Hi,

Your Solution :
This is very simple follow below steps.

1) Set Maximum value for Progress bar control with row count either from datatable or gridview etc..<br />
2) Set initial value to zero or minimum value of progress bar control.<br />
3) In your loop you need to increase your progress bar control's value with 1.

Sample Code:

C#

progressBar1.Maximum = dtTable.Rows.Count;
progressBar1.Value = progressBar1.Minimum;

foreach (DataRow vRow in dtTable.Rows)
{
    //TODO : Your INSERT, UPDATE, DELETE Or any Operation/Execution
    progressBar1.Value++;
}