Progressbar with dataset and SQL stored procedure

[HomerJS]

I am using vb.net 2003 and want to use a progress bar while a dataset is loaded. The dataset is bound to a grid which does take some time to load.

 

[ca8msm]

Do you know exactly how many records will be returned?


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[HomerJS]

It will vary.

 

[ca8msm]

So how would you know exactly what percentage you had returned in order to set the progress bar?

I'm sure you know where I'm going with this question...


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[HomerJS]

That's a question I had myself, and why I asked it.

 

[ca8msm]

That was actually a rhetorical question. If you don't know what percentage of records have been returned you cannot create a true progressbar.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[HomerJS]

So how would it be done if the number of records returned was known?

 

[TekMem]

Is it possible to count total records using select statement count (*) ...Prior to loading Dataset?

 

[HomerJS]

yes