data adapter command type advise

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

In data adapter I have a choice to select command types text, stored
procedure or table direct. Which one is most appropriate for sql server 2005
backend.

Many Thanks

Regards
 
In most cases, you should choose Stored Procedure, meaning, you specify a
stored procedure's name, which has already be created in the targeting SQL
Server database, doing the required SELECT/UPDATE/DELETE...
 

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

Reusing Adapter/Command Builder without disposing 1
VS 2003 & SQL 2005 Data Adapter Error 6
Strongly Typed DataSets and "Refresh the data table" Option 6
Stored procedure advise 3
Type is invalid error 3
Re: Parameter size for NVARCHAR(MAX) data type? 0
Warning! Serious design flaw dataset / table adapter designer 8
Command builder question 1

Back
Top