CS Code is as Follow:---
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Business_Layer;
using Data_Layer;
using System.Data;
using System.Data.SqlClient;
using System.IO;
namespace Editable_Grid
{
public partial class Customer_Info : System.Web.UI.Page
{
DataTable dt = new DataTable();
Business_Class BCobj = new Business_Class();
Data_Class DCobj = new Data_Class();
String filename;
String filepath;
int RowEffected;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Get_Data();
}
}
public void Get_Data()
{
BCobj.Mode = 0;
dt = BCobj.Get_Employee_Data_BL();
GridView1.DataSource = dt;
GridView1.DataBind();
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
Get_Data();
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
Get_Data();
}
public void Insert(object sender, EventArgs e)
{
BCobj.Mode = 0;
BCobj.Employee_Name = ((TextBox)(GridView1.FooterRow.FindControl("txt_Employee"))).Text;
BCobj.Gender = ((RadioButtonList)(GridView1.FooterRow.FindControl("RadioButtonList1"))).Text;
BCobj.Mobile_No = ((TextBox)(GridView1.FooterRow.FindControl("txt_Mobile"))).Text;
BCobj.City = ((TextBox)(GridView1.FooterRow.FindControl("txt_City"))).Text;
BCobj.State = ((DropDownList)(GridView1.FooterRow.FindControl("DropDownList1"))).Text;
BCobj.Marital_Status = ((CheckBoxList)(GridView1.FooterRow.FindControl("CheckBoxList1"))).Text;
FileUpload FileUpload1=((FileUpload)(GridView1.FooterRow.FindControl("FileUpload1")));
if (FileUpload1.PostedFile != null)
{
filename = Path.GetFileName(FileUpload1.PostedFile.FileName);
filepath = "Images/" + filename;
FileUpload1.PostedFile.SaveAs(Server.MapPath(filepath));
BCobj.File_Name = filename;
BCobj.File_Path = filepath;
}
RowEffected = BCobj.Insert_Employee_Data_BL();
if (RowEffected > 0)
{
Label1.Text = "Data Insert successfully";
Get_Data();
}
else
{
Label1.Text = "Data not Saved";
Get_Data();
}
}
public void Delete(object sender, EventArgs e)
{
BCobj.Mode = 1;
BCobj.ID = Convert.ToInt32((sender as LinkButton).CommandArgument);
RowEffected = BCobj.Insert_Employee_Data_BL();
if (RowEffected > 0)
{
Label1.Text = "Delete Successfully";
Get_Data();
}
else
{
Label1.Text = "Data not deleted";
Get_Data();
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
BCobj.Mode = 2;
BCobj.ID = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value);
BCobj.Employee_Name = ((TextBox)(GridView1.Rows[e.RowIndex].FindControl("txt_Employee"))).Text;
BCobj.Gender = ((RadioButtonList)(GridView1.Rows[e.RowIndex].FindControl("RadioButtonList1"))).Text;
BCobj.Mobile_No = ((TextBox)(GridView1.Rows[e.RowIndex].FindControl("txt_Mobile"))).Text;
BCobj.City = ((TextBox)(GridView1.Rows[e.RowIndex].FindControl("txt_City"))).Text;
BCobj.State = ((DropDownList)(GridView1.Rows[e.RowIndex].FindControl("DropDownList1"))).Text;
BCobj.Marital_Status = ((CheckBoxList)(GridView1.Rows[e.RowIndex].FindControl("CheckBoxList1"))).Text;
FileUpload FileUpload1=((FileUpload)(GridView1.FooterRow.FindControl("FileUpload1")));
if (FileUpload1.PostedFile != null)
{
filename = Path.GetFileName(FileUpload1.PostedFile.FileName);
filepath = "Images/" + filename;
FileUpload1.PostedFile.SaveAs(Server.MapPath(filepath));
BCobj.File_Name = filename;
BCobj.File_Path = filepath;
}
RowEffected = BCobj.Insert_Employee_Data_BL();
if (RowEffected > 0)
{
Label1.Text = "Update successfully";
GridView1.EditIndex = -1;
Get_Data();
}
else
{
Label1.Text = "Data has not Update";
GridView1.EditIndex = -1;
Get_Data();
}
}
}
}
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server" >
<div>
<div class="ClearGap">
<asp:Label ID="Label1" runat="server" Font-Bold="true" ForeColor="Red" Text="Label"></asp:Label>
</div>
<div class="ClearGap"></div>
<div class="ClearGap"></div>
<div class="ClearGap"></div>
<center> <div style="width:1200px;">
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
Width="1200px" BackColor="#FF99FF" DataKeyNames="ID"
EmptyDataText="No Data Available " AllowPaging="True" ShowFooter="True"
onrowcancelingedit="GridView1_RowCancelingEdit"
onrowediting="GridView1_RowEditing" onrowupdating="GridView1_RowUpdating">
<Columns>
<asp:TemplateField HeaderText="Sr.No">
<ItemTemplate>
<span>
<%#Container.DataItemIndex + 1%>
</span>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="ID" HeaderText="S.No." ReadOnly="true" Visible="false"/>
<asp:TemplateField HeaderText="Emp_Image">
<ItemTemplate>
<asp:Image runat="server" ImageUrl='<%#Eval("File_Path") %>' Width="90px" Height="90px">
</asp:Image>
</ItemTemplate>
<EditItemTemplate>
<asp:FileUpload ID="FileUpload1" runat="server" Width="90px" />
</EditItemTemplate>
<FooterTemplate>
<asp:FileUpload ID="FileUpload1" runat="server" Width="90px"/>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="File_Name" Visible="false">
<ItemTemplate>
<asp:Label ID="lbl_File" runat="server" Text='<%#Eval("File_Name") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txt_File" runat="server" Text='<%#Eval("File_Name") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txt_File" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Employee_Name">
<ItemTemplate>
<asp:Label ID="lbl_Employee" runat="server" Text='<%#Eval("Employee_Name") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txt_Employee" runat="server" Text='<%#Eval("Employee_Name") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txt_Employee" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Gender">
<ItemTemplate>
<asp:Label ID="lbl_Gender" runat="server" Text='<%#Eval("Gender") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:RadioButtonList ID="RadioButtonList1" runat="server">
<asp:ListItem>Male</asp:ListItem>
<asp:ListItem>Female</asp:ListItem>
</asp:RadioButtonList>
</EditItemTemplate>
<FooterTemplate>
<asp:RadioButtonList ID="RadioButtonList1" runat="server">
<asp:ListItem>Male</asp:ListItem>
<asp:ListItem>Female</asp:ListItem>
</asp:RadioButtonList>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Mobile_No">
<ItemTemplate>
<asp:Label ID="lbl_Mobile" runat="server" Text='<%#Eval("Mobile_No") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txt_Mobile" runat="server" Text='<%#Eval("Mobile_No") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txt_Mobile" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="City">
<ItemTemplate>
<asp:Label ID="lbl_City" runat="server" Text='<%#Eval("City") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txt_City" runat="server" Text='<%#Eval("City") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txt_City" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="State">
<ItemTemplate>
<asp:Label ID="lbl_State" runat="server" Text='<%#Eval("State") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:DropDownList ID="DropDownList1" runat="server">
<asp:ListItem>Delhi</asp:ListItem>
<asp:ListItem>Punjab</asp:ListItem>
<asp:ListItem>Haryana</asp:ListItem>
</asp:DropDownList>
</EditItemTemplate>
<FooterTemplate>
<asp:DropDownList ID="DropDownList1" runat="server">
<asp:ListItem>Delhi</asp:ListItem>
<asp:ListItem>Punjab</asp:ListItem>
<asp:ListItem>Haryana</asp:ListItem>
</asp:DropDownList>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Marital_Status">
<ItemTemplate>
<asp:Label ID="lbl_Status" runat="server" Text='<%#Eval("Marital_Status") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:CheckBoxList ID="CheckBoxList1" runat="server">
<asp:ListItem>Single</asp:ListItem>
<asp:ListItem>Married</asp:ListItem>
</asp:CheckBoxList>
</EditItemTemplate>
<FooterTemplate>
<asp:CheckBoxList ID="CheckBoxList1" runat="server">
<asp:ListItem>Single</asp:ListItem>
<asp:ListItem>Married</asp:ListItem>
</asp:CheckBoxList>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Delete">
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" Font-Underline="true" Text="Delete" runat="server" CommandName="Delete" CommandArgument='<%#Eval("ID")%>' ToolTip="Delete" OnClick="Delete" OnClientClick='return confirm("Are you sure you want to Delete?");'>Delete</asp:LinkButton>
</ItemTemplate>
<FooterTemplate>
<asp:Button ID="Button2" runat="server" Text="Insert" OnClick="Insert" />
</FooterTemplate>
</asp:TemplateField>
<asp:CommandField ShowEditButton="true" HeaderText="Edit" />
</Columns>
<EditRowStyle BackColor="#99FF99" ForeColor="#009933" />
<FooterStyle BackColor="#009933" BorderColor="#006600" BorderStyle="Solid" />
<HeaderStyle BackColor="#009933" />
</asp:GridView>
</div>
</center>
</div>
</form>
</body>
</html>
