c# - Unable to update the GridView in .Net (Date fields are not updating) -
below code gridview , query update , insert....but when update grid values update in database except date(all 3 fields). after updating date fields value null in database... using datepicker calendar.
<asp:gridview id="gridview1" runat="server" cellpadding="5" forecolor="#333333" width="1000px" gridlines="none" onpageindexchanging="gridview_pageindexchanging" allowsorting="true" onsorting="gridview_sorting" autogeneratecolumns="false" borderstyle="outset" cellspacing="1" font-names="cambria" font-size="small" allowpaging="true" showfooter="true" showheaderwhenempty="true" datasourceid="sqldatasource1" onselectedindexchanged="gridview1_selectedindexchanged" > <alternatingrowstyle backcolor="white" forecolor="#284775" /> <columns> <asp:boundfield datafield="case_number" headertext="case number" sortexpression="case_number" /> <asp:boundfield datafield="case_name" headertext="case name" sortexpression="case_name" /> <asp:boundfield datafield="case_type_text" headertext="case type" sortexpression="case_type_text" /> <asp:templatefield headertext="case status" sortexpression="case_status_text"> <edititemtemplate> <asp:dropdownlist id="dropdownlist3" runat="server" datasourceid="sqldatasource3" datatextfield="case_status_text" datavaluefield="case_status_text" selectedvalue='<%# bind("case_status_text") %>'> </asp:dropdownlist> </edititemtemplate> <itemtemplate> <asp:label id="label1" runat="server" text='<%# bind("case_status_text") %>'></asp:label> </itemtemplate> </asp:templatefield> <asp:boundfield datafield="assigned_date" headertext="assigned date" sortexpression="assigned_date" dataformatstring="{0:d}" /> <asp:boundfield datafield="assigned_to" headertext="assigned to" sortexpression="assigned_to" /> <asp:templatefield headertext="date withdrawn" sortexpression="date_withdrawn"> <edititemtemplate> <cc1:datepicker id="datepicker5" runat="server" /> </edititemtemplate> <itemtemplate> <asp:label id="label4" runat="server" text='<%# bind("date_withdrawn", "{0:d}") %>'></asp:label> </itemtemplate> </asp:templatefield> <asp:templatefield headertext="date delivered" sortexpression="date_delivered"> <edititemtemplate> <cc1:datepicker id="datepicker7" runat="server" /> </edititemtemplate> <itemtemplate> <asp:label id="label6" runat="server" text='<%# bind("date_delivered", "{0:d}") %>'></asp:label> </itemtemplate> </asp:templatefield> <asp:templatefield headertext="qc by" sortexpression="qc_by"> <edititemtemplate> <asp:dropdownlist id="dropdownlist5" runat="server" datasourceid="sqldatasource4" datatextfield="user_name" datavaluefield="user_name" selectedvalue='<%# bind("qc_by") %>'> </asp:dropdownlist> </edititemtemplate> <itemtemplate> <asp:label id="label2" runat="server" text='<%# bind("qc_by") %>'></asp:label> </itemtemplate> </asp:templatefield> <asp:templatefield headertext="qc date" sortexpression="qc_date"> <edititemtemplate> <cc1:datepicker id="datepicker6" runat="server" /> </edititemtemplate> <itemtemplate> <asp:label id="label5" runat="server" text='<%# bind("qc_date", "{0:d}") %>'></asp:label> </itemtemplate> </asp:templatefield> <asp:templatefield headertext="additional notes"> <edititemtemplate> <asp:textbox id="textbox1" runat="server" text='<%# bind("additional_notes") %>' textmode="multiline"></asp:textbox> </edititemtemplate> <itemtemplate> <asp:label id="label3" runat="server" text='<%# bind("additional_notes") %>'></asp:label> </itemtemplate> </asp:templatefield> <asp:commandfield showeditbutton="true" buttontype="button" causesvalidation="false" /> </columns> <editrowstyle backcolor="#999999" /> <footerstyle backcolor="#5d7b9d" font-bold="true" forecolor="white" /> <headerstyle backcolor="#5d7b9d" font-bold="true" forecolor="white" /> <pagerstyle backcolor="#284775" forecolor="white" horizontalalign="center" /> <rowstyle backcolor="#f7f6f3" forecolor="#333333" /> <selectedrowstyle backcolor="#e2ded6" font-bold="true" forecolor="#333333" /> <sortedascendingcellstyle backcolor="#e9e7e2" /> <sortedascendingheaderstyle backcolor="#506c8c" /> <sorteddescendingcellstyle backcolor="#fffdf8" /> <sorteddescendingheaderstyle backcolor="#6f8dae" /> </asp:gridview> <asp:sqldatasource id="sqldatasource1" runat="server" connectionstring="<%$ connectionstrings:con %>" providername="<%$ connectionstrings:con.providername %>" selectcommand="select * [view_intakesheet]" insertcommand="insert [view_intakesheet] ([case_number], [case_name], [assigned_date], [assigned_to], [date_withdrawn], [date_delivered], [qc_by], [qc_date], [additional_notes], [case_status_text], [case_type_text]) values (@case_number, @case_name, @assigned_date, @assigned_to, @date_withdrawn, @date_delivered, @qc_by, @qc_date, @additional_notes, @case_status_text, @case_type_text)" updatecommand="update intakesheet set case_number = @case_number, case_name=@case_name, case_type=@case_type, case_status = @case_status, assigned_date = @assigned_date, assigned_to = @assigned_to, date_withdrawn= @date_withdrawn, date_delivered= @date_delivered, qc_by = @qc_by, qc_date=@qc_date, additional_notes = @additional_notes (case_number = @case_number)"> <insertparameters> <asp:parameter name="case_number" /> <asp:parameter name="case_name" /> <asp:parameter name="assigned_date" /> <asp:parameter name="assigned_to" /> <asp:parameter name="date_withdrawn" /> <asp:parameter name="date_delivered" /> <asp:parameter name="qc_by" /> <asp:parameter name="qc_date" /> <asp:parameter name="additional_notes" /> <asp:parameter name="case_status_text" /> <asp:parameter name="case_type_text" /> </insertparameters> <updateparameters> <asp:parameter name="case_number" /> <asp:parameter name="case_name" /> <asp:parameter name="case_type" /> <asp:parameter name="case_status" /> <asp:parameter name="assigned_date" /> <asp:parameter name="assigned_to" /> <asp:parameter name="date_withdrawn" /> <asp:parameter name="date_delivered" /> <asp:parameter name="qc_by" /> <asp:parameter name="qc_date" /> <asp:parameter name="additional_notes" /> </updateparameters> </asp:sqldatasource> </td> </tr>
Comments
Post a Comment