Help with SQL query

[computerman]

I am having a problem getting my head around a query. What I want it to do is this. I want to be able to list all available rooms of a certain type between 2 dates and display the result is a dgv so that the user can select the available room(s). The information is held in 2 files:

Calendar
---------
Date
AccountNumber
RoomNo
Status

Rooms
------
RoomNo
RoomType

The 3 fields on the form would be txtArriveDate, txtDepartDate & txtRoomType. I know I can setup a new tableadapter and bind it to the dgv, but it is the query that I am having a problem with.

Any help on this would be appreciated.

Computerman

[GaryMazzone]

strSQL = "Select RoomNo,RoomType "
strSQL &= "From Rooms "
strSQL &= "Where "
strSQL &= " RoomType = txtRoomType AND "
strSQL &= " Status = 'Avail' AND "
strSQL &= " Date Beteen '" & Me.txtArriveDate.Text &"' AND '" & Me.txtDepartDate & "'"

[BackWoodsCoder]

bad practice with that query, much better off using parameters to protect against any possible sql injection.

[computerman]

bad practice with that query, much better off using parameters to protect against any possible sql injection.

What do you mean by that?

Computerman

[dee-u]

What do you mean by that?

Computerman

Have a look at this FAQ article.