ajax Calender Extender无法正常工作 [英] ajax Calender Extender not working
问题描述
My Ajax Calender Extender不工作，日期没有插入db。
请帮帮我
.aspx
<％@ Page 语言 = C＃ AutoEventWireup = true CodeFile = plan_a_task_pop.aspx.cs 继承 = plan_a_taskaspx ％>
<％@ 注册 汇编 = AjaxControlToolkit 命名空间 = AjaxControlToolkit < span class =code-attribute> TagPrefix = ajaxToolkit ％>
< ！DOCTYPE html PUBLIC - // W3C // DTD XHTML 1.0 Transitional // EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd >
< html xmlns = http://www.w3.org/1999 / xhtml >
< head runat = 服务器 >
< link href = css / text.css rel = stylesheet < span class =code-attribute> type = text / css / >
< link href = css / m yclass.css rel = stylesheet type = text / css / >
< title > < / title >
< / head >
< 正文 >
< <跨度class =code-leadattribute> form id = form1 runat = 服务器 >
< div >
< asp：ScriptManager ID = ScriptManager runat = server / >
< 表 width = 100％ id = table1 runat = 服务器 > ;
< tr >
< td class = table_bold_text2 align = left >
日期执行：
< / td >
< td >
< asp：TextBox ID = txt_date runat = server ReadOnly = true CssClass = table_grey_border 宽度 = 178 / >
< ajaxToolkit：CalendarExtender 格式 = MM / dd / yyyy ID = CalendarExtender2 runat = server 已启用 = 真 TargetControlID = txt_date CssClass = MyCalendar / >
< / td >
< / tr >
< tr >
< td > < / td >
< td >
< asp：按钮 ID = btn_submit runat = server Text = 提交 < span class =code-attribute> OnClick = btn_submit_OnClick / >
< / td >
< / tr >
< span class =code-keyword>< / table >
< table id = table2 runat = server 可见 = false >
< tr >
< td class = table_bold_text2 > 亲爱的用户，您的任务已成功提交。< / td >
< / tr >
< / table >
< / div >
< / form >
< / body >
< / html >
.cs
protected void btn_submit_OnClick（object sender，EventArgs e）
{
string strqry = ;
string date = txt_date.Text;
strqry =插入到tbl_order_task_details（order_id，buyer_name，date_of_execution，subject，detail_of_task，assigned_to，Category，SubCategory）值（'+ Session [order_id]。ToString（）+'，'+ ViewState [customer_id] .ToString（）+'，'+ date.ToString（）+'，'+ tt_subject.Text.ToString（）。Replace（'，''）+'，'+ tt_details_of_the_task .Text.ToString（）。Replace（'，''）+'，'+ ddl_user.SelectedValue.ToString（）+'，'+ ddl_category.SelectedItem.ToString（）+'， '+ ddl_subCategory.SelectedItem.ToString（）+'）;
obj.openDatabase（）;
obj.executeMySqlqry（ strqry）;
obj.closeDatabase（）;
tt_details_of_the_task.Text =;
tt_subject.Text =;
ddl_subCategory.Items.Clear（）;
ddl_category.Items。清除（）;
ddl_user.Items.Clear（）;
}
删除文本框上的ReadOnly =true...
考虑通过客户端代码在文本框上设置readonly属性....通过此链接了解更多信息
阅读本文
我希望您使用存储过程将日期保存到数据库，并在文本框中访问选定日期。
这是一个我能想到的解决方案
sqlCmd.Parameters.Add（ @ date，SqlDbType.DateTime）.Value = Convert.ToDateTime（txtDate.Text）;
试试这个
DateTime.Parse（txt_date.Text）.ToString （ MM / dd / yyyy）
你也可以使用DateTime.TryParse ...
DateTime date = DateTime.Now ;
DateTime.TryParse（txt_date.Text， out date）;
date.ToString（ MM / dd / yyyy）;
My Ajax Calender Extender Not working, date not inserted in db.
Please help me
.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="plan_a_task_pop.aspx.cs" Inherits="plan_a_taskaspx" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="ajaxToolkit" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<link href="css/text.css" rel="stylesheet" type="text/css" />
<link href="css/myclass.css" rel="stylesheet" type="text/css" />
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:ScriptManager ID="ScriptManager" runat="server" />
<table width="100%" id="table1" runat="server">
<tr>
<td class="table_bold_text2" align="left">
Date of Execution:
</td>
<td>
<asp:TextBox ID="txt_date" runat="server" ReadOnly="true" CssClass="table_grey_border" Width="178" />
<ajaxToolkit:CalendarExtender Format="MM/dd/yyyy" ID="CalendarExtender2" runat="server" Enabled="True" TargetControlID="txt_date" CssClass="MyCalendar" />
</td>
</tr>
<tr>
<td></td>
<td>
<asp:Button ID="btn_submit" runat="server" Text="Submit" OnClick="btn_submit_OnClick" />
</td>
</tr>
</table>
<table id="table2" runat="server" visible="false">
<tr>
<td class="table_bold_text2">Dear user, your task has been submitted successfully.</td>
</tr>
</table>
</div>
</form>
</body>
</html>
.cs
protected void btn_submit_OnClick(object sender, EventArgs e)
{
string strqry = "";
string date = txt_date.Text;
strqry = "insert into tbl_order_task_details(order_id,buyer_name,date_of_execution,subject,detail_of_task, assigned_to,Category,SubCategory) values('" + Session["order_id"].ToString() + "','" + ViewState["customer_id"].ToString() + "','" + date.ToString() + "','" + tt_subject.Text.ToString().Replace("'", "''") + "','" + tt_details_of_the_task.Text.ToString().Replace("'", "''") + "', '" + ddl_user.SelectedValue.ToString() + "','" + ddl_category.SelectedItem.ToString() + "','" + ddl_subCategory.SelectedItem.ToString() + "')";
obj.openDatabase();
obj.executeMySqlqry(strqry);
obj.closeDatabase();
tt_details_of_the_task.Text = "";
tt_subject.Text = "";
ddl_subCategory.Items.Clear();
ddl_category.Items.Clear();
ddl_user.Items.Clear();
}
Remove ReadOnly="true" on the textbox...
Consider to set readonly attribute on textbox by client code....go through this link for more info
Read This
I hope you are using a stored procedure to save the date to the database and also access the picked date in a textbox.
Here's a solution which i can think of
sqlCmd.Parameters.Add("@date",SqlDbType.DateTime).Value=Convert.ToDateTime(txtDate.Text);
Try this
DateTime.Parse(txt_date.Text).ToString("MM/dd/yyyy")
You can also use DateTime.TryParse...
DateTime date=DateTime.Now; DateTime.TryParse(txt_date.Text,out date); date.ToString("MM/dd/yyyy");
这篇关于ajax Calender Extender无法正常工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
