Assign new stored procedure to data adapter

  • Thread starter Thread starter Patrick Frutiger
  • Start date Start date
P

Patrick Frutiger

Hi NG,

can I assign another stored procedure as select statement to a data adapter
during runtime ?

thanxx for answer

P@rick
 
Yes, just set the DA"s select command (and each other one individually) to
the proc name and make sure the command type is set properly. Also, you
can't use a CommandBuilder with procs so if you're using one, you'll have
some trouble.

Cheers,

Bill
 
thanxx, it works!

Cheers, P@rick

William Ryan said:
Yes, just set the DA"s select command (and each other one individually) to
the proc name and make sure the command type is set properly. Also, you
can't use a CommandBuilder with procs so if you're using one, you'll have
some trouble.

Cheers,

Bill
Click to expand...
 

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

data adapter command type advise 1
Feedback from stored procedure 5
SQL Update/Insert using SqlDataAdapter and Stored Procedure 1
Strongly Typed DataSets and "Refresh the data table" Option 6
Stored Procedure return values 3
Transactions + multiple table adapters 3
Table Adapter Configuration Wizard replaces data table name with stored procedure's 1
Stored procedures and sql Adapters 2

Back
Top