c# - ASP.NET GridView Updating -

c# - ASP.NET GridView Updating -

i next error when editing gridview:

conversion failed when converting date and/or time character string.

i think error on purchase date column seek convert info type date still not work idea

protected void gridview1_rowupdating(object sender, gridviewupdateeventargs e) { string id = ((label)gridview1.rows[e.rowindex].findcontrol("lblid")).text; string supplier = ((textbox)gridview1.rows[e.rowindex].findcontrol("txtsupplier")).text; string unitprice = ((textbox)gridview1.rows[e.rowindex].findcontrol("txtunitprice")).text; string pstatus = ((dropdownlist)gridview1.rows[e.rowindex].findcontrol("ddlpstatus")).text; datetime pdate = convert.todatetime((textbox)gridview1.rows[e.rowindex].findcontrol("txtpdate")).tostring(); string strcon = system.configuration.configurationmanager.connectionstrings["constring"].connectionstring; sqlconnection conn = new sqlconnection(strcon); conn.open(); string strsession = "update tblprs_sparepart set supplier='" + supplier.tostring() + "',up_vati ='" + unitprice + "',purchasing_status ='" + pstatus + "',purchase_date ='" + pdate + "' id='" + id + "'"; sqlcommand cmd = new sqlcommand(strsession, conn); cmd.executenonquery(); gridview1.editindex = -1; conn.close(); binddata(); } <asp:templatefield headertext="purchase status"> <itemtemplate> <asp:label id="lblpstatus" runat="server" text='<%#eval("purchasing_status") %>'>'> </asp:label> </itemtemplate> <edititemtemplate> <asp:label id="lblpstatus" runat="server" text='<%# eval("purchasing_status")%>' visible = "false"></asp:label> <asp:dropdownlist id = "ddlpstatus" runat = "server"></asp:dropdownlist> </edititemtemplate> </asp:templatefield> <asp:templatefield headertext="purchase status"> <itemtemplate> <asp:label id="lblpdate" runat="server" dataformatstring="{0:dd/mm/yyyy}" itemstyle-width="70px" itemstyle-wrap="false" text='<%#eval("purchase_date","{0:dd/mm/yyyy}") %>'>'> </asp:label> </itemtemplate> <edititemtemplate> <asp:label id="lblpdate" runat="server" text='<%# eval("purchase_date","{0:dd-mm-yyyy}")%>' visible = "false"></asp:label> <asp:textbox id="txtpdate" runat="server" text='<%# eval("purchase_date","{0:dd-mm-yyyy}")%>' ></asp:textbox> <asp:calendarextender id="calendarextender1" runat="server" targetcontrolid="txtpdate"> </asp:calendarextender> </edititemtemplate> </asp:templatefield>

it looks aren't passing text contents of command datetime conversion parameter.

try changing:

datetime pdate = convert.todatetime((textbox)gridview1.rows[e.rowindex].findcontrol("txtpdate")).tostring();

to

datetime pdate = convert.todatetime(((textbox)gridview1.rows[e.rowindex].findcontrol("txtpdate")).text);

c# asp.net sql-server