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