日期时间选择器，并根据数据库日期表中的最大和最小日期过滤数据 [英] date time picker and filtering data on the basis of maximum and minimum date in date table of db

问题描述

我正在寻找日期时间选择器，该日期时间选择器可用于Visual Studio 2008的桌面应用程序，但不适用于asp.net Web应用程序..


此外，我还需要日期时间选择器，以便可以自己格式化..

日/月/年..

而且我也想在gridview中过滤数据.

我还想过滤数据库表中产品名称，以获取数据库日期表列中某个日期的最大值和最小值...

i am looking for the date time picker its availble for visual studio 2008 for desktop applications but its not avaliable for asp.net web applications..


more over i want a date time picker in such a way that i can format it myself..

day/month /year..

and also i want to filter a data in a gridview.

more over i want to filter productnames form the database table for maximum and minimum values of of a date in which in database date table column...

推荐答案

使用Ajax CalanderExtender
并在条件下传递文本框文本

并像这样绑定gridview

Use Ajax CalanderExtender
and pass textboxes text in where condition

and bind gridview like

<asp:gridview id="GridView1" runat="server" cellpadding="4" xmlns:asp="#unknown">
                       ForeColor="#333333" AutoGenerateColumns="False" DataKeyNames="Id"
                        Width="972px" DataSourceID="SqlDataSource1">
                       <rowstyle backcolor="#EFF3FB" />
                       <columns>
                           <asp:boundfield datafield="taskid" headertext="AssignmentId" />
                           <asp:boundfield datafield="Id" headertext="Id" insertvisible="False">
                               ReadOnly="True" SortExpression="Id" />
                           <asp:boundfield datafield="taskname" headertext="Task Description">
                               SortExpression="taskname" />
                           <asp:boundfield datafield="completiondate" headertext="CompletionDate">
                               SortExpression="completiondate" DataFormatString="{0:dd/MM/yyyy}" />
                           <asp:boundfield datafield="Status" headertext="Status(By Assignee)">
                               SortExpression="Status"  HtmlEncode="false" />
                           <asp:boundfield datafield="Remarks" headertext="Remarks(By Assignee)">
                               SortExpression="Remarks"  HtmlEncode="false" />
                           <asp:boundfield datafield="RemarksAssigner" headertext="Remarks(By Assigner)">
                               SortExpression="RemarksAssigner"  HtmlEncode="false" />
                           <asp:boundfield datafield="assignedon" headertext="AssignedOn">
                               SortExpression="assignedon" DataFormatString="{0:dd/MM/yyyy}" />
                           <asp:boundfield datafield="empcode" headertext="Assign To">
                               SortExpression="empcode" />
                           <asp:boundfield datafield="name" headertext="Assignee Name">
                               SortExpression="name" />
                           <asp:boundfield datafield="Designation" headertext="Designation">
                               SortExpression="Designation" />
                           <asp:boundfield datafield="Deptt" headertext="Deptt" sortexpression="Deptt" />
                       </asp:boundfield></asp:boundfield></asp:boundfield></asp:boundfield></asp:boundfield></asp:boundfield></asp:boundfield></asp:boundfield></asp:boundfield></asp:boundfield></columns>
                       <footerstyle backcolor="#507CD1" font-bold="True" forecolor="White" />
                       <pagerstyle backcolor="#2461BF" forecolor="White" horizontalalign="Center" />
                       <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
                       <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                       <editrowstyle backcolor="#2461BF" />
                       <alternatingrowstyle backcolor="White" />
                   </asp:gridview>
                   <asp:sqldatasource id="SqlDataSource1" runat="server" xmlns:asp="#unknown">
                       ConnectionString="<%

ConnectionStrings:cnn％>" SelectCommand = " " sessionfield = " /> < asp:controlparameter controlid = " name = " > PropertyName = " /> < asp:controlparameter controlid = " name = " propertyname = " /> </ SelectParameters > </ asp:controlparameter > </ asp:sqldatasource >

ConnectionStrings:cnn %>" SelectCommand="SELECT tblJobs.taskid,tblJobs.Id, tblJobs.taskname, tblJobs.completiondate, tblJobs.Status, tblJobs.Remarks, tblJobs.RemarksAssigner, tblTaskAssign.assignedbyname, tblTaskAssign.assignedon, tblTaskAssign.empcode, empbirth.name, empbirth.Designation, empbirth.Deptt FROM tblTaskAssign INNER JOIN tblJobs ON tblTaskAssign.taskid = tblJobs.taskid INNER JOIN empbirth ON tblTaskAssign.empcode = empbirth.userid WHERE (tblTaskAssign.assignedby = @assignedby) AND (tblTaskAssign.assignedon BETWEEN @date1 AND @date2)"> <SelectParameters> <asp:sessionparameter name="assignedby" sessionfield="userid" /> <asp:controlparameter controlid="txtReqDatefrom" name="date1"> PropertyName="Text" /> <asp:controlparameter controlid="txtReqTo" name="date2" propertyname="Text" /> </SelectParameters> </asp:controlparameter></asp:sqldatasource>

这篇关于日期时间选择器，并根据数据库日期表中的最大和最小日期过滤数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！