asp.net - Edit GridView not working Properly -
i using gridview bounded sqldatasource.
when click edit button in gridview, able edit fields. fields contains 3 text boxes, 2 dropdown list, 3 datepicker calenders. dropdownlist data bind database. if click on edit , after update text field values updated in database, dropdown , calender field entries in database null..
update query:
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)">
update parameters:
<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" type="datetime" /> <asp:parameter name="assigned_to" /> <asp:parameter name="date_withdrawn" type="datetime" /> <asp:parameter name="date_delivered" type="datetime" /> <asp:parameter name="qc_by" /> <asp:parameter name="qc_date" type="datetime" /> <asp:parameter name="additional_notes" /> </updateparameters>
Comments
Post a Comment