making this query work

[id123]

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????

[MrNorth]

I suggest you create a command object, build your sql query, and then fill your dataset with the dataadapter fill method... manually...


1) make connection
2)make command
3)make datadapter that uses conn and command)
4)fill a dataset with dataadapter

use the dataset...

may I suggest that you build the sql query with the stringbuilder object, it conserves memory and is good practice...


kind regards
henrik

[id123]

thanks, for the reply. i did think this but i have the wrox book beginning vb.net v2. they only talk about using this method with mysql. I take it that this way is also valid as i am using ms access???

thanks again

[MrNorth]

it is valid for every provider that exist in .net ODBC, OLEDB, SQL, ORACLE....

What provider are you using?

/Henrik

[id123]

i take it u mean my database when u sy provider? i am using the Microsoft jet 4.0 to connect to an access 2003 db?

[salvelinus]

You're using OLEDB in that case.