hi, i have made a query using the dataset function that is:
SELECT Availibilty.*
FROM Availibilty

this is just pulling everything out but i want to make it extract data that a user enters via a textbox. i have a text box called txtWeek.

basicall i want somehting like this:

SELECT Availibilty.*
FROM Availibilty
WHERE Availibilty.Week = txtWeek.Text


is this possible to sue or would i have to use this as a command in my code????