gridview + vb

[Oga M]

please help me with the sql statement to display the information on the gridview according to the selected dates(stating date and ending date)when you click generate info butto oga

[Arun Immanuel]

select * from tblName where Date>=startDate and Date<endDate.

[Oga M]

from txtSdate and txtEdate oga

[Arun Immanuel]

select * from tblName where cast(Date as datetime)>=cast(txtStartdate as datetime) and cast(date as datetime)<=cast(txtEnddate as datetime) I assume Date column is also in text format.