Passing an input parameter to an access query

  • Thread starter Thread starter Steven C
  • Start date Start date
S

Steven C

Hi, I'm sure there is a really simple way to do this...

I'm trying to pass an input paramater to an Access query using OleDb.
I know it can be achieved using a command object but this only seems
to be able to create a datareader object and I want a dataset. Does
any one know how to pass an input paramateter to get a dataset back?

Thanks in advance
Steven
 
Steven C said:
Hi, I'm sure there is a really simple way to do this...

I'm trying to pass an input paramater to an Access query using OleDb.
I know it can be achieved using a command object but this only seems
to be able to create a datareader object and I want a dataset. Does
any one know how to pass an input paramateter to get a dataset back?
Click to expand...

Use a DataAdapter, specifying the command and then using Fill.
 
Back
Top