Farooque Ali

Farooque Ali

  • 1.5k
  • 255
  • 242.7k

Date Picker Value

Aug 21 2008 8:27 AM

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.