<%@ Page Language="C#" MasterPageFile="~/AdminPanel/AdminMasterPage.master" AutoEventWireup="true" CodeFile="frmEditItems.aspx.cs" Inherits="AdminPanel_frmEditItems" Title="Untitled Page" %> <asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server"> <link rel="stylesheet" href="assets/css/plugins/selectize.bootstrap3.css" /> <link rel="stylesheet" href="assets/css/plugins/fileinput.min.css"> <link href="assets/css/plugins/humane_themes/jackedup.css" rel="stylesheet"> <link rel="stylesheet" href="assets/css/plugins/dndTable.css"> <link rel="stylesheet" href="assets/css/plugins/tsort.css"> </asp:Content> <asp:Content ID="Content2" ContentPlaceHolderID="AdminContentPlaceHolder1" runat="Server"> <asp:ScriptManager ID="ScriptManager1" runat="server"> </asp:ScriptManager> <div class="container-fluid"> <div class="row"> <div class="col-md-12"> <!--Top header start--> <h3 class="ls-top-header"> Products</h3> <!--Top header end --> <!--Top breadcrumb start --> <ol class="breadcrumb"> <li><a href="frmMain.aspx"></a></li> </ol> <!--Top breadcrumb start --> </div> </div> <div class="row"> <div class="col-md-12" style="overflow-x: auto; width: 1000px"> <div class="panel panel-default"> <div class="panel-heading"> <h3 class="panel-title"> Category Details</h3> </div> <div class="panel-body"> <div class="table-responsive ls-table"> <asp:UpdatePanel ID="UpdatePanel1" runat="server"> <ContentTemplate> <asp:GridView ID="GvCategory" runat="server" AutoGenerateColumns="False" Font-Names="Arial" AllowPaging="True" EnableSortingAndPagingCallbacks="True" AutoGenerateDeleteButton="True" AutoGenerateEditButton="True" PageSize="10" class="table table-bordered table-striped" OnRowEditing="OnEdit" OnPageIndexChanging="OnPageChange" OnRowCancelingEdit="OnCancel" OnRowDeleting="OnDeleting" OnRowUpdating="OnUpdate"> <Columns> <asp:TemplateField ItemStyle-Width="100px" HeaderText="Category_Id"> <ItemTemplate> <asp:Label ID="lblCategory_Id" runat="server" Text='<%# Eval("Category_ID")%>'></asp:Label> </ItemTemplate> <ItemStyle Width="100px" /> </asp:TemplateField> <asp:TemplateField ItemStyle-Width="100px" HeaderText="Category_Name"> <ItemTemplate> <asp:Label ID="lblCategory_Name" runat="server" Text='<%# Eval("Category_Name")%>'></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:TextBox ID="txtCategory_Name" runat="server" Text='<%# Eval("Category_Name")%>'></asp:TextBox> </EditItemTemplate> <ItemStyle Width="100px" /> </asp:TemplateField> <asp:TemplateField ItemStyle-Width="100px" HeaderText="Date"> <ItemTemplate> <asp:Label ID="lblCategory_Date" runat="server" Text='<%# Eval("Category_Date")%>'></asp:Label> </ItemTemplate> <ItemStyle Width="100px" /> </asp:TemplateField> </Columns> </asp:GridView> </ContentTemplate> <Triggers> <asp:PostBackTrigger ControlID="GvCategory" /> </Triggers> </asp:UpdatePanel> </div> </div> </div> </div> </div> </div> </div> <script src="assets/js/pages/table.js"></script> <script src="assets/js/editable-table/jquery.dataTables.js"></script> <script src="assets/js/editable-table/jquery.validate.js"></script> <script src="assets/js/editable-table/jquery.jeditable.js"></script> <script src="assets/js/editable-table/jquery.dataTables.editable.js"></script> </asp:Content>
using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; public partial class AdminPanel_frmEditItems : System.Web.UI.Page { MainClass ObjMainClass = new MainClass(); DataTable dtGridView = new DataTable(); protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BindData(); } } private void BindData() { //GridView dtGridView = ObjMainClass.GetData("select * from category order by category_id"); GvCategory.DataSource = dtGridView; GvCategory.DataBind(); } protected void OnEdit(object sender, GridViewEditEventArgs e) { GvCategory.EditIndex = e.NewEditIndex; BindData(); GvCategory.Rows[e.NewEditIndex].FindControl("txtCategory_Name").Focus(); } protected void OnUpdate(object sender, GridViewUpdateEventArgs e) { string getCatName, getCatId; getCatName = ""; getCatId = ""; getCatId = ((Label)GvCategory.Rows[e.RowIndex].FindControl("lblCategory_Id")).Text; getCatName = ((TextBox)GvCategory.Rows[e.RowIndex].FindControl("txtCategory_Name")).Text; dtGridView = ObjMainClass.GetData("update category set category_name='" + getCatName + "' where category_id=" + getCatId + " order by category_id"); GvCategory.DataSource = dtGridView; GvCategory.DataBind(); GvCategory.EditIndex = -1; BindData(); } protected void OnCancel(object sender, GridViewCancelEditEventArgs e) { GvCategory.EditIndex = -1; BindData(); } protected void OnDeleting(object sender, GridViewDeleteEventArgs e) { string Category_Id = ((Label)GvCategory.Rows[e.RowIndex].FindControl("lblCategory_Id")).Text; dtGridView = ObjMainClass.GetData("delete from categry where variant_id=" + Category_Id + ""); GvCategory.DataSource = dtGridView; GvCategory.DataBind(); GvCategory.EditIndex = -1; BindData(); } protected void OnPageChange(object sender, GridViewPageEventArgs e) { BindData(); GvCategory.PageIndex = e.NewPageIndex; GvCategory.DataBind(); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)