日历控件代码如下:
时间:从<input id="d5221" class="Wdate" type="text" value = "2011-09-01"
onFocus="var d5222=$dp.$('d5222');WdatePicker({onpicked:function(){d5222.focus();},maxDate:'#F{$dp.$D(\'d5222\')}'})" name="startdate" />
至<input id="d5222" class="Wdate" type="text" value = "2011-09-15"
onFocus="WdatePicker({minDate:'#F{$dp.$D(\'d5221\')}'})" name="enddate" />SqlDataSource 代码如下:
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:scmsConnectionString %>"
SelectCommand="select 商场代码,商场名称, 销售数量, 销售金额 from aaa where 商场代码=@customerid and 制单日期 >=@startdate and 制单日期 <@enddate group by B.商场代码">
<SelectParameters>
<asp:controlparameter name="customerid" controlid="DropDownList1" propertyname="SelectedValue"/>
<asp:Parameter Name="startdate" DefaultValue="2011-08-01" />
<asp:Parameter Name="enddate" DefaultValue="2011-09-01" />
</SelectParameters>
</asp:SqlDataSource> 目前这种状态,日期只能写死成2011-08-01和2011-09-01,请问应该怎么取日历控件d5221和d5222的值呢?<asp:Parameter Name="startdate" DefaultValue="2011-08-01" />
<asp:Parameter Name="enddate" DefaultValue="2011-09-01" />
只要修改这两个Defaultvalue就行,我不知道该怎么写,应该是d5221.value就可以。就是不会把这个值赋给sql语句中的变量。
时间:从<input id="d5221" class="Wdate" type="text" value = "2011-09-01"
onFocus="var d5222=$dp.$('d5222');WdatePicker({onpicked:function(){d5222.focus();},maxDate:'#F{$dp.$D(\'d5222\')}'})" name="startdate" />
至<input id="d5222" class="Wdate" type="text" value = "2011-09-15"
onFocus="WdatePicker({minDate:'#F{$dp.$D(\'d5221\')}'})" name="enddate" />SqlDataSource 代码如下:
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:scmsConnectionString %>"
SelectCommand="select 商场代码,商场名称, 销售数量, 销售金额 from aaa where 商场代码=@customerid and 制单日期 >=@startdate and 制单日期 <@enddate group by B.商场代码">
<SelectParameters>
<asp:controlparameter name="customerid" controlid="DropDownList1" propertyname="SelectedValue"/>
<asp:Parameter Name="startdate" DefaultValue="2011-08-01" />
<asp:Parameter Name="enddate" DefaultValue="2011-09-01" />
</SelectParameters>
</asp:SqlDataSource> 目前这种状态,日期只能写死成2011-08-01和2011-09-01,请问应该怎么取日历控件d5221和d5222的值呢?<asp:Parameter Name="startdate" DefaultValue="2011-08-01" />
<asp:Parameter Name="enddate" DefaultValue="2011-09-01" />
只要修改这两个Defaultvalue就行,我不知道该怎么写,应该是d5221.value就可以。就是不会把这个值赋给sql语句中的变量。
Dim max_date As String = Now.AddYears(10).ToString("yyyy-MM-dd")
Dim min_date As String = Now.AddYears(-10).ToString("yyyy-MM-dd")
'加载日期格式
PublicFunction.myPublic.SetDatePicker(Me.txt_begin_date, "{isShowClear:false,dateFmt:'yyyy-MM-dd HH:mm:ss '}")
string date=d5221.value;
额,这是vb的把,我用的c#
{
if (!IsPostBack)
{
enddate.text = DateTime.Now.ToString("yyyy-MM-dd");
}
}我尝试在cs文件里加上面的代码,可是提示我“上下文不存在“enddate””
{
if (!IsPostBack)
{
enddate.text = DateTime.Now.ToString("yyyy-MM-dd");
}
}
现在的问题和asp。net已经没什么关系了,就是my97datapicker的问题
<script language="javascript" type="text/javascript" src="js/My97DatePicker/WdatePicker.js"></script>
<p>时间:从
<input id="d5221" class="Wdate" type="text" onFocus="var d5222=$dp.$('d5222');WdatePicker({onpicked:function(){d5222.focus();},maxDate:'#F{$dp.$D(\'d5222\')}'})" name="startdate" runat="server" />
至
<input id="d5222" class="Wdate" type="text" onFocus="WdatePicker({minDate:'#F{$dp.$D(\'d5221\')}'})" name="enddate" runat ="server" />
</p>
加了runat,点击控件就打不开日历了
<script language="javascript" type="text/javascript" src="js/My97DatePicker/WdatePicker.js"></script>
<p>时间:从
<input id="d5221" class="Wdate" type="text" onFocus="var d5222=$dp.$('d5222');WdatePicker({onpicked:function(){d5222.focus();},maxDate:'#F{$dp.$D(\'d5222\')}'})" name="startdate" />
至
<input id="d5222" class="Wdate" type="text" onFocus="WdatePicker({minDate:'#F{$dp.$D(\'d5221\')}'})" name="enddate" />
</p>
这样能打开日历,可是.cs里又没法调用enddate。