I am using two datepicker value fromdate and todate, using that datepicker value i am storing the datas in to the database. After the inserting the data , i wrote the coding for searching the data. There is three types of searching one providerwise and another is dropdownlist finally datewise.
At first i passed these values,
Dim StrSQL As New System.Text.StringBuilder
StrSQL.Append("SELECT DISTINCT ImageNo,Account_Names,Batch_Type,fldvImageIndex,BatchDate_from,BatchDate_To FROM Importimage")
StrSQL.Append(" WHERE 1=1")
If txtImageNo.Text.Trim <> "" Then StrSQL.Append("AND ImageNo = '" & txtImageNo.Text.Trim & "'")
the provider name wise search is working but other two are not working and also i dont know how to write code to search those values.
Please tell me how to solve this problem.