I am using Grid view For Display Data items I want to show, edit, update, delete and cancel items in grid view using single stored procedure. Right now I am performing all these tasks with separate stored procedure. I am making Display, update and Delete stored procedure separate but now i want to perform using single stored procedure. I have a db manager class. **Below is my code please modify this code how can I do that.** **.aspx code** <asp:GridView ID="grd_category" Width="100%" runat="server" AutoGenerateColumns="false" EmptyDataRowStyle-CssClass="grid_error" EmptyDataText="No data available" GridLines="None" OnRowDeleting="grddata_RowDeleting" OnRowEditing="grddata_RowEditing" OnRowCommand="grddata_RowCommand" OnRowDataBound="grddata_RowDataBound" DataKeyNames="category_id" onrowcancelingedit="grd_category_RowCancelingEdit" onrowupdating="grd_category_RowUpdating" ShowHeaderWhenEmpty="True" AllowPaging="True" onpageindexchanging="grd_category_PageIndexChanging" PageSize="25"> <Columns> <asp:TemplateField HeaderText="Category Name" HeaderStyle-CssClass="field_title_wraper" ItemStyle-CssClass="value_wraper" ItemStyle-Width="20%"> <ItemTemplate> <%#Eval("txt_category_name")%> </ItemTemplate> <EditItemTemplate> <div style="float: left;"> <asp:TextBox ID="txt_category_name" runat="server" Text='<%#Eval("txt_category_name") %>'></asp:TextBox> </div> </EditItemTemplate> </asp:TemplateField> <%-- <asp:TemplateField HeaderText="Title" HeaderStyle-CssClass="field_title_wraper" ItemStyle-CssClass="value_wraper" ItemStyle-Width="40%"> <ItemTemplate> <%#Eval("txt_title")%> </ItemTemplate> <EditItemTemplate> <div style="float: left;"> <asp:TextBox ID="txt_title" runat="server" Text='<%#Eval("txt_title") %>'></asp:TextBox> </div> </EditItemTemplate> </asp:TemplateField>--%> <%-- <asp:TemplateField HeaderText="Description" HeaderStyle-CssClass="field_title_wraper" ItemStyle-CssClass="value_wraper" ItemStyle-Width="25%"> <ItemTemplate> <%#Eval("txt_description")%> </ItemTemplate> <EditItemTemplate> <div style="float: left"> <asp:TextBox ID="txt_description" runat="server" Text='<%#Eval("txt_description") %>'></asp:TextBox> </div> </EditItemTemplate> </asp:TemplateField>--%> <asp:TemplateField HeaderText="Action" HeaderStyle-CssClass="field_title_rightbdr_none_wraper" > ItemStyle-CssClass="value_wraper" ItemStyle-Width="5%"> <ItemTemplate> <div class="city_icon_wraper"> <div class="action_img_view_icon"> <asp:ImageButton ID="imgbtnedit" runat="server" ImageUrl="images/edit_icon.png" CommandName="edit"/> </div> <div class="action_bdr"> <img width="2" height="34" src="images/action_bdr.jpg" alt=""></div> <div class="action_icon"> <asp:LinkButton ID="lnkBtnDelete" runat="server" ToolTip="Click To Delete" CommandName="Delete" class="ask" CommandArgument='<%#DataBinder.Eval(Container.DataItem, "category_id")%>'> <img src="images/delete_icon.png" alt="" > </asp:LinkButton> </div> </div> </ItemTemplate> <ItemStyle HorizontalAlign="Center" /> <EditItemTemplate> <asp:ImageButton ID="imgbtnupdate" runat="server" ImageUrl="~/Admin/images/approved_icon - Copy.png" CommandName="update" /> <asp:ImageButton ID="imgbtncancel" runat="server" ImageUrl="~/Admin/images/close_btn.png" CommandName="cancel" /> </EditItemTemplate> <%-- <ItemStyle HorizontalAlign="Center" /> <EditItemTemplate> <asp:ImageButton ID="imgbtnupdate" runat="server" ImageUrl="~/img/update.ico" CommandName="update" Height="30" Width="30" /> <asp:ImageButton ID="imgbtncancel" runat="server" ImageUrl="~/img/cancel.ico" CommandName="cancel" Height="30" Width="30" /> </EditItemTemplate>--%> </asp:TemplateField> </Columns> </asp:GridView> **Property Layer** public class PropertyCategory { private Int64 _category_id; private string _txt_category_name; public Int64 id { get { return _category_id; } set { _category_id = value; } } public string txt_category_name { get { return _txt_category_name; } set { _txt_category_name = value; } } } **Data layer** public static int DataAddCategory(PropertyCategory objcat) { return DBManager.ExecuteNonQuery("spAddCategory", objcat.txt_category_name); } public static DataSet datafillcategory() { return DBManager.ExecuteDataset("spFillCategory"); } public static int DataDeleteCategory(PropertyCategory objcat) { return DBManager.ExecuteNonQuery("spDeleteCategory", objcat.id); } public static int DataUpdateCategory(PropertyCategory objcat) { //return DBManager.ExecuteNonQuery("spUpdateCategory", objcat.id, objcat.txt_category_name, objcat.txt_title, objcat.txt_description); return DBManager.ExecuteNonQuery("spUpdateCategory", objcat.id, objcat.txt_category_name); } **Business Layer** public class BusinessCategory { public static int BusinessAddCategory(PropertyCategory objcat) { return DataCategoryTable.DataAddCategory(objcat); } public static DataSet BusinessFillCategory() { return DataCategoryTable.datafillcategory(); } public static int BusinessDeleteCategory(PropertyCategory objcat) { return DataCategoryTable.DataDeleteCategory(objcat); } public static int BusinessUpdateCategory(PropertyCategory objcat) { return DataCategoryTable.DataUpdateCategory(objcat); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)