Writing Dynamic Queries in Data Adapter

[Keroleen]

I wanna make a query that will detect the selected week and name of person.

 

I think maybe I put this in my datadapter?

 

SELECT employeeCode, friHours, monHours, satHours, sunHours, thuHours, timeSheetCode, tueHours, wedHours, weekNumber FROM tblTimeSheet WHERE ???????

 

 

it will output to a datagrid.

I only want a certain WEEK (weeknumber = 200403 for example)

But when I do make this procedure with out the WHERE clause

 

and try to do

 

OleDbDataAdapter3.Fill(DsHours1, "qry_timesheet")

 

but it pulls up like all info rather than just one.

I already make the query in the access database

 

 

any suggestions or ideas ?

[Robby]

One way is to include a Where clause such as ...

 

dim someValue as integer = 200403 
"SELECT employeeCode, friHours ......... Where weeknumber = " & someValue

 

Or you can retrieve all the datafrom the db and the use RowFilter method of the Dataview.

dv.RowFilter = "weeknumber = " & someValue