Show Progress Bar....while executing long query

Question

5.00/5 (1 vote)

See more:

i have one sql query...which i executes in my c# windows application... using cmd.executeNonQuery();
and this cmd.executeNonQuery(); query takes executes in half or a minute time....
i want to show user on screen....the progress bar....with execution progress....
is that possible...how i will do that...

Posted 26-Feb-14 18:07pm

jayeshhh

Add a Solution

Comments

Alexander Sharykin 27-Feb-14 0:39am

if you execute a stored procedure or a function in this command, it is possible to organize a feedback and update progress in your application
but it won't work in case of a single update or delete query

Member 13116309 11-Apr-17 11:31am

how can i organize the feedback when i execute a stored procedure, which gives no output?

2 solutions

Add a Solution

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

agent_kruger · Answer 1 · 2014-02-26T18:33:00

sir, actually at the time of retrieving your data back you can't as it is unknown how much time it will take (depends on database). But at time of filling you can do so like this

Progressbar1.Maximum = Dt.Rows.Count;//Dt is your DataTable
for(int i=0;i<dt.rows.count;i++)>
{
    //Do Work
    Progressbar1.Value = i + 1;
}

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 2 · 2014-02-26T18:23:00

Solution 1

Check the following articles and implement in your project.

1. how to use progressbar control in windows application using c#.net[^]
2. ProgressBar[^]

Posted 26-Feb-14 18:23pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Show Progress Bar....while executing long query

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Show Progress Bar....while executing long query

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us