Hi dear ,

Thanks for replaying me

Yes I connacet my Sql with VS but still not working !!

Also my ( login page ) not working !

Dim conString As String = "Data Source=BUSH;Initial Catalog=HOTEL;Integrated Security=True"
        Dim sqlcon As SqlConnection = New SqlConnection(conString)
        sqlcon.Open()
        Dim cmd As New SqlCommand("select * from Users where UserID =@UserID and Password=@Password", sqlcon)
        cmd.Parameters.AddWithValue("@UserID", txtUserID.Text)
        cmd.Parameters.AddWithValue("@Password", txtPWD.Text)
        Dim da As New SqlDataAdapter(cmd)
        Dim dt As New DataTable()
        da.Fill(dt)
        If dt.Rows.Count > 0 Then
            Response.Redirect("Room.aspx")
        Else
            ClientScript.RegisterStartupScript(Page.[GetType](), "validation", "<script language='javascript'>alert('Invalid UserName and Password')</script>")

        End If

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 booking.enddate) AND ('" + TextBox2.Text + "' NOT BETWEEN Bookingg.ArraieDate AND Booking.EndDate)[B])[/B] or Booking.BookingId = null"
        sqlCom.CommandType = CommandType.Text
        sqlCon.Open()
        sqlCom.ExecuteNonQuery()
        sqlCon.Close()
    End Sub

It showing me error in ExecuteNonQuery !! I don't Whay ! Also the insert data in my web not saving in database SQL server 2010 !

Please help me !!!

Regards ,