Connection to database duration and Progress display in WinForm C#

Question

Hi,

Is there a way to count database connection duration and to display something graphical to show that it is in progress.

ProgressBar is not the good solution here because we cannot know the final duration when we query the server.

Sam Hobbs · Answer

I am not sure how to use a timer for that. You can use a wait cursor easily enough and I think that is the best thing to do. I assume you only need to do this for one form. Try the following. Cursor InitialCursor = this .Cursor; this .Cursor = Cursors.WaitCursor; // connect this .Cursor = InitialCursor;

Sam Hobbs · Answer

Just look in this web page. Look to the right side of here for " Our recommended articles ". The hard part is estimating the amount of time that will be requiredto open the connection, or somehow determining that a portion of the processing ahs occured. My guess is that it is very difficult to do.

Samio · Answer

What do you think about this : //Connect Button Click mStartTick = Environment.TickCount; //First Data retrieval decimal number; number = (Environment.TickCount - mStartTick) / 1000; label4.Text = "Elapsed time to connect: " + number.ToString("F2", CultureInfo.CreateSpecificCulture("fr-FR")) + " sec"; it worked for me, but could not get time format with precison '0.00' example: 4,39 s

Samio · Answer

Thank you Sam, Sorry Suthish, I thought you mean link to another web pages. I have already seen these articles, as you said Sam "The hard part is estimating the amount of time that will be requiredto open the connection" so I would ask for a method to put a timer to count the duration taken to connect, to evaluate every time if is there any delay, and also I would ask if is there any Windows Form Control to show that the connection is in progress (i.e. arrow turns on himself) , like those used by youtube when videos are loading.

Samio · Answer

Hi Suthish, Is there any link to Your recommended articles ? Thank you

Suthish Nair · Answer

Try, Our recommended articles

Connection to database duration and Progress display in WinForm C#

Answers (6)