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.
 
You must log in or register to reply here.

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

passing parameters from text box to sql 4
select string for oleDB 3
IList or an IListSource error??? 2
DB2 Multi Value Parameter 5
Observing the Elements passed through an Expression of IQueryable<T> 7
Creating a DLL that would bridge an unmanaged Delphi call to managedC# 9
Passing parameters via MS Query to Access 1
Query from Excel to Access - Passing Parameters? 8

Back
Top