data adapter command type advise

[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

 

[Norman Yuan]

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...