Access Query in C#

Question

Hi, please help!

I have a Access db with a few tables. I want to use DataView and bind a Query using only the query name. I am able to bind the tables but not the query name. Is there a way to do this without using connection string SELECT*FROM etc etc. I need to run different queries from the same table once the DataSet is created:

dataGridView1.DataSource = dataView1;

DataView dataView1 = new DataView(JobQuery);

...so I basically want to replace JobsTable with JobsQueryName. The Access db is part of the solution (app) and the queries are created like tables in Access.

There must be an easier way to do this

DataTable JobQuery = jobManagerDBDataSet.JobsTable;