Cannot Create a Dataset for an OLEDB DataAdapter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have an OLEDB DataAdapter and cannot create a Dataset to use with the
adapter because the SelectCommand contains a parameter. Is there a work
around for this?

Any Help is appreciated.

Thank You
 
Chris - I'm not sure what you mean - in the designer or with code? Using
parameterized queries is definitely not an issue in code. Can you tell me a
little more aobut the problem.
 
Hi,

I'm trying to do this in the designer. I can graphically create the
DataAdapter using the wizard. I can build the Select Query using the Query
Builder and placing a ?
in the criteria field for the appropriate field. This all seems to work
fine, however once I try to graphically build the dataset using the wizard,
it throws an error because the parameter value is empty and will not let me
create a dataset.

Thanks
 
In the designer you can set a default value for the dataadapter.
(better late than never)
thanks
kes
 
Back
Top