Posted on: 6/18/2014 12:39:08 AM | Views : 257

hey guys anyone of u all know what's wrong with this code ???
Protected Sub btnSearch_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSearch.Click Dim conString As String = ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString Dim query As String = "SELECT * From AutoVanTruckSUVSubmitDetails Where Title LIKE '%'+@Title+'%' And Where Price Between '%'+@FromPrice+'%' And '%'+@ToPrice+'%' And Approve=1" Dim cmd As SqlCommand = New SqlCommand(query) cmd.Parameters.AddWithValue("@Title", "%" + txtSearch.Text + "%") cmd.Parameters.AddWithValue("@FromPrice", "%" + TextBox1.Text + "%") cmd.Parameters.AddWithValue("@ToPrice", "%" + TextBox2.Text + "%") Dim con As SqlConnection = New SqlC ...

Go to the complete details ...