Setting SQL parameter to data Adapter

[sethindeed]

Was wondering.
Suppose I define my dataAdapter as "Select * From mytable" with the data adapter wizard, is there a way to modify the SQL query so that my data adapter returns a new result set at RUNTIME ?

thx

 

[wayko]

you can edit the command on the property or you can dim a new sqlcommand text

 

[Robby]

Look at the top section where .NET places all the design-time code, you can modify the Select statement there or simply create the dataAdapter at run-time.

 

[quwiltw]

Put a question mark in the SQL statement for the parameter, then at runtime add a parameter to the sqlcommand object. Were going down a similar path in this post if youre interested.
http://www.computerhelp.forum/showthread.php?s=&threadid=69500

 

[sethindeed]

Thanx guys.
Suppose my dataadapter is referring to tblStuff in an access database.
If I use DisposeCommand, can I refer to another table with the same dataadapter ?

thx !

 

[quwiltw]

Im not sure what DisposeCommand is but theres nothing about a dataadapter that prevents you from modifying it at runtime (ie. redefining its selectcommand).