Single SP or several of them

[Vlad]

I'm using several stored procedures to populate all controls (text boxes,
grids, combos) on the form with data. Is there any advantages of using a
single stored procedure with multiple Select statements to fill DataSet and
then use different DataTables for appropriate controls?
For testing I do not have a big volume of data to play with it in order to
see the difference, but the real database is going to contain much more
data.
Thank you
Vlad

 

[Herfried K. Wagner [MVP]]

Hello,

I'm using several stored procedures to populate all controls (text boxes,
grids, combos) on the form with data. Is there any advantages of using a
single stored procedure with multiple Select statements to fill DataSet and
then use different DataTables for appropriate controls?

Notice that there is a newsgroup for .NET+database (ADO .NET) questions:

news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet

HTH,
Herfried K. Wagner