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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

fill dataset from Sql Server stored procedure? 10
Multiple select statements in a single stored procedure. 2
basic dataset/table question 1
Extract Single Record from Dataset filled from SP Output 6
multiple tables within a dataset 4
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
How best to keep data set and db in synch 5
How to pass array of records from VB text box to SQL Server SP 2

Back
Top