Single SP or several of them

  • Thread starter Thread starter Vlad
  • Start date Start date
V

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
 
Hello,

Vlad said:
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?
Click to expand...

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
 
Back
Top