我必须将ajax日历日期存储到具有数据类型日期的sql列中。 [英] I have to store a ajax calender date into sql column having datatype date.

问题描述

  protected   void  gvImages_RowUpdating（对象发​​件人，GridViewUpdateEventArgs e）
 {
 
 SqlConnection con =  new  SqlConnection（ @ 数据源=。\SQLEXPRESS; AttachDbFilename = D：\ site \SamsungClassifieds\App_Data \Dorknozzle.mdf; Integrated安全性=真;用户实例=真）; 
 con.Open（）; 
 AjaxControlToolkit.CalendarExtender date =（AjaxControlToolkit.CalendarExtender）gvImages.Rows [e.RowIndex] .FindControl（  DATE3\" ）; 
  //   int userid = Convert.ToInt32（gvImages.DataKeys [e.RowIndex] .Values [lbladid ] .ToString（））;  
标签lbladid =（标签）gvImages.Rows [e.RowIndex] .FindControl（  lbladid）; 
 TextBox txttitl =（TextBox）gvImages.Rows [e.RowIndex] .FindControl（  txttitle）; 
 TextBox txtdesc =（TextBox）gvImages.Rows [e.RowIndex] .FindControl（  txtdesc）; 
 Label lblprice =（Label）gvImages.Rows [e.RowIndex] .FindControl（  lblprice）; 
 TextBox txtprice =（TextBox）gvImages.Rows [e.RowIndex] .FindControl（  txtprice）; 
 TextBox txtdate =（TextBox）gvImages.Rows [e.RowIndex] .FindControl（  txtdate）; 
 
 
 
 SqlCommand cmd =  new  SqlCommand（  UPDATE AD_DETAIL SET AD_TITLE =' + txttitl.Text +  '，AD_DESC =' + txtdesc.Text +  '，AD_PRICE =' + txtprice.Text +  '，DATE =' + date.SelectedDate.ToString（） +  'WHERE AD_ID =' + lbladid.Text +  '，con）; 
 
  //   SqlCommand cmd = new SqlCommand（Update AD_DETAIL set AD_TITLE =+ txttitle。文字+其中AD_ID =+ lbladid，con）;  
 cmd.ExecuteNonQuery（）; 
 gvImages.EditIndex = -1; 
 Binddata（）; 
 con.Close（）; 
 
} 

解决方案

如果您正在使用ASP.Net AJAX Control Toolkit CalendarExtender，那么您将访问得到客户端价值...

C＃

<前lang =c＃> 字符串 date = Request.Form [txtDate.UniqueID];

VB.net

  Dim  strDate  As   String  = Request.Form（txtDate.UniqueID）

protected void gvImages_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        
        SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=D:\site\SamsungClassifieds\App_Data\Dorknozzle.mdf;Integrated Security=True;User Instance=True");
        con.Open();
        AjaxControlToolkit.CalendarExtender date = (AjaxControlToolkit.CalendarExtender)gvImages.Rows[e.RowIndex].FindControl("date3");
        //int userid = Convert.ToInt32(gvImages.DataKeys[e.RowIndex].Values["lbladid"].ToString());
        Label lbladid = (Label)gvImages.Rows[e.RowIndex].FindControl("lbladid");
        TextBox txttitl = (TextBox)gvImages.Rows[e.RowIndex].FindControl("txttitle");
        TextBox txtdesc = (TextBox)gvImages.Rows[e.RowIndex].FindControl("txtdesc");
        Label lblprice = (Label)gvImages.Rows[e.RowIndex].FindControl("lblprice");
        TextBox txtprice = (TextBox)gvImages.Rows[e.RowIndex].FindControl("txtprice");
        TextBox txtdate = (TextBox)gvImages.Rows[e.RowIndex].FindControl("txtdate");
        
   
        
        SqlCommand cmd = new SqlCommand("UPDATE AD_DETAIL SET AD_TITLE ='" + txttitl.Text + "',AD_DESC ='" + txtdesc.Text + "',AD_PRICE ='" + txtprice.Text + "',DATE =' "+ date.SelectedDate.ToString() +" 'WHERE AD_ID = '" + lbladid.Text + "'", con);
        
        //SqlCommand cmd = new SqlCommand("Update AD_DETAIL set AD_TITLE=" + txttitle.Text + "where AD_ID =" + lbladid, con);
        cmd.ExecuteNonQuery();
        gvImages.EditIndex = -1;
        Binddata();
        con.Close();

    }

解决方案

If you're using the ASP.Net AJAX Control Toolkit CalendarExtender, you get to get the client side value...
C#

string date= Request.Form[txtDate.UniqueID];

VB.net

Dim strDate As String = Request.Form(txtDate.UniqueID)

这篇关于我必须将ajax日历日期存储到具有数据类型日期的sql列中。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！