how to search data using start and end date from to db in as

I created form where i kept 2 calender and search button .

i want to search data using these date like received date and sent date from to data base.how to do this please tell ,

and dispaly in gridview which gv code i attaeched it is on same page

Letter Sent Date(From):

CausesValidation="false" />

runat="server" ControlToValidate="txtstartdate" Display="Dynamic" ErrorMessage="Please enter start date.">

Display="Dynamic" ErrorMessage="Date format should be in dd/mm/yyyy." SetFocusOnError="True"

ValidationExpression="(0[1-9]|[12][0-9]|3[01])[//.](0[1-9]|1[012])[//.](19|20)\d\d"

ValidationGroup="Add">

Tip:-dd/mm/yyyy

Letter Sent Date(To):

runat="server" MaxLength="10">

CausesValidation="false" />

Display="Dynamic" ErrorMessage="Date format should be in dd/mm/yyyy." SetFocusOnError="True"

ValidationExpression="(0[1-9]|[12][0-9]|3[01])[//.](0[1-9]|1[012])[//.](19|20)\d\d"

ValidationGroup="Add">

ControlToValidate="txtendate" Display="Dynamic" ErrorMessage="End date must be greater than start date."

ValidationGroup="Add">

Tip:-dd/mm/yyyy<%--If u will not enter the end date it will enter the end date after

3 months from start date--%>

PopupButtonID="ImageButton1">

PopupButtonID="ImageButton2">

Department Name* :

CausesValidation="false">

GridLines="Vertical" Width="100%" CssClass="table-responsive" PageSize="10" AllowPaging="true">

<%#Container .DataItemIndex + 1 %>

<%# DataBinder.Eval(Container.DataItem, "NO")%>

ItemStyle-CssClass="Text-Center">

<%# DataBinder.Eval(Container.DataItem, "ReceivedDate")%>

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Anjali Khan8y ago
yes amit it is binding data but all which is in db

but if i select date from and to then should be filter.
Amit Gupta8y ago
Hey

You haven't shared your code behind file.

Anyway, you can use your query like
Select * from tablename
Where
Datecolumn between startdate and enddate

Then bind your DataTable with gridview