I created dynamic WHERE clauses so that only records on the WHERE clause is displayed and nothing more.
However, when attempting to use the WHERE, I am getting an error that
where is not recognized.
Here is some code snips:
' SearchString = txtSpecificDate.Text
ViewSelect = Request("ViewBy")
If ViewSelect = "" Or ViewSelect = "Range" Then
ViewSelect = "Range"
Else
ViewSelect = "Specific"
End If
Dim conn As New SqlConnection(ConfigurationManager.ConnectionStrings("conString").ConnectionString)
Dim cmd As New SqlCommand("-placeholder-", conn)
Dim sb As New StringBuilder("Select siteID,siteName,AssetName,Capacity,AvailableFacilities,facilityAvailabilityDate,GroupStatus " & _
",amenities,[Rental Fees] RentalFees,[Extr ...
Go to the complete details ...