Please can anyone cheack my work its not working with me ! Also if you have any simple Solution can I use, it will be better ! Protected Sub Button1_Click(sender As Object, e As System.EventArgs) Handles Button1.Click Dim conString As String = "Data Source=BUSH;Initial Catalog=HOTEL;Integrated Security=True" Dim sqlCom As SqlCommand = New SqlCommand() Dim sqlCon As SqlConnection = New SqlConnection(conString) sqlCom.Connection = sqlCon sqlCom.CommandText = " SELECT distinct Type_of_Room, No_of_Days, Charge ,Date , Crand_Total FROM Room INNER JOIN BookingRoom ON Room.Room_ID <> BookingRoom.Room_ID INNER JOIN Booking ON BookingRoom.BookingID = Booking.BookingID WHERE [B]([/B]('" + TextBox4.Text + "' NOT BETWEEN booking.arrivedate AND …

Member Avatar
Member Avatar
+0 forum 3

The End.