Hello Friends,
Today i am share with you a GridView Control Program.
My Server Name is :- MONTY\\SQLEXPRESS
With the help of this program you can make our own command name in the GridView Control.
And for handling our own command name we have to fire "RowCommand" event of the GridView Control
My DataBase Name is :- dbemp
My Table Name is :- tbemp
In My Table I have Four Columns
First Column Name is :- empno(int)
Second Column Name is :- ename(varchar(50))
Third Column Name is :- eaddr(varchar(50))
Fourth Column Name is :- esal(int)
This is the code for the Default.aspx of the Source Mode.
<form id="form1" runat="server">
You just write the following code within the start and end tag of the BODY.
<div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
ShowFooter="True" Width="667px"
onrowcancelingedit="GridView1_RowCancelingEdit"
onrowediting="GridView1_RowEditing" onrowupdating="GridView1_RowUpdating"
onrowdeleting="GridView1_RowDeleting" onrowcommand="GridView1_RowCommand">
<Columns>
<asp:TemplateField HeaderText="EmpNo">
<ItemTemplate>
<asp:Label ID="itmlblempno" runat="server" Text='<%#Eval("empno")%>'>
</asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:Label ID="edtlblempno" runat="server" Text='<%#Eval("empno")%>'>
</asp:Label>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="ftrtxtempno" runat="server" Text=""></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Name">
<ItemTemplate>
<asp:Label ID="itmlblename" runat="server" Text='<%#Eval("ename")%>'>
</asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="edttxtename" runat="server" Text='<%#Eval("ename")%>'>
</asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="ftrtxtename" runat="server" Text=""></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Address">
<ItemTemplate>
<asp:Label ID="itmlbleaddr" runat="server" Text='<%#Eval("eaddr")%>'>
</asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="edttxtaddr" runat="server" Text='<%#Eval("eaddr")%>'>
</asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="ftrtxtaddr" runat="server" Text=""></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Salary">
<ItemTemplate>
<asp:Label ID="itmlblesal" runat="server" Text='<%#Eval("esal")%>'>
</asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="edttxtsal" runat="server" Text='<%#Eval("esal")%>'>
</asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="ftrtxtsal" runat="server" Text=""></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:Button ID="itmbtnedt" runat="server" Text="EDIT"
CommandName="edit" Width="65px" />
<asp:Button ID="itmbtndel" runat="server" Text="DELETE"
CommandName="delete" Width="65px" />
</ItemTemplate>
<EditItemTemplate>
<asp:Button ID="itmbtnupd" runat="server" Text="UPDATE"
CommandName="update" Width="65px" />
<asp:Button ID="itmbtncal" runat="server" Text="CANCEL"
CommandName="cancel" Width="65px" />
</EditItemTemplate>
<FooterTemplate>
<asp:Button ID="itmbtnsav" runat="server" Text="SAVE"
CommandName="save" Width="65px"/>
</FooterTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</div>
</form>
This is the code for the Default.aspx.cs page.
using System;
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;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack == false)
{
grid_bind();
}
}
private void grid_bind()
{
SqlDataAdapter adp = new SqlDataAdapter("select * from tbemp",
"server=MONTY\\SQLEXPRESS;database=dbemp;Integrated Security=True");
DataSet ds = new DataSet();
adp.Fill(ds);
GridView1.DataSource = ds;
}
protected void GridView1_RowEditing(object sender,
GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
grid_bind();
}
protected void GridView1_RowCancelingEdit(object sender,
GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
grid_bind();
}
protected void GridView1_RowUpdating(object sender,
GridViewUpdateEventArgs e)
{
Int32 empno, esal;
String ename, eaddr;
SqlConnection con = new
SqlConnection("server=MONTY\\SQLEXPRESS;database=dbemp;
Integrated Security=True");
con.Open();
SqlCommand cmd = new
SqlCommand("update tbemp set ename=@ename,eaddr=@eaddr,
esal=@esal where empno=@empno",con);
cmd.Parameters.Add("@ename",SqlDbType.VarChar,50)
.Value = ((TextBox)(GridView1.Rows[e.RowIndex]
.FindControl("edttxtename"))).Text;
cmd.Parameters.Add("@eaddr",SqlDbType.VarChar,50)
.Value = ((TextBox)(GridView1.Rows[e.RowIndex]
.FindControl("edttxtaddr"))).Text;
cmd.Parameters.Add("@esal",SqlDbType.VarChar,50)
.Value = Convert.ToInt32(((TextBox)(GridView1.Rows[e.RowIndex]
.FindControl("edttxtsal"))).Text);
cmd.Parameters.Add("@empno",SqlDbType.VarChar,50)
.Value = Convert.ToInt32(((Label)(GridView1.Rows[e.RowIndex]
.FindControl("edtlblempno"))).Text);
cmd.ExecuteNonQuery();
GridView1.EditIndex = -1;
grid_bind();
cmd.Dispose();
con.Close();
}
protected void GridView1_RowDeleting(object sender,
GridViewDeleteEventArgs e)
{
Int32 empno;
SqlConnection con =
new SqlConnection("server=MONTY\\SQLEXPRESS;database=dbemp;
Integrated Security=True");
con.Open();
SqlCommand cmd =
new SqlCommand("delete from tbemp where empno=@empno", con);
cmd.Parameters.Add("@empno", SqlDbType.VarChar, 50)
.Value = Convert.ToInt32(((Label)(GridView1.Rows[e.RowIndex]
.FindControl("itmlblempno"))).Text);
cmd.ExecuteNonQuery();
GridView1.EditIndex = -1;
grid_bind();
cmd.Dispose();
con.Close();
}
protected void GridView1_RowCommand(object sender,
GridViewCommandEventArgs e)
{
if (e.CommandName == "save")
{
Int32 empno, esal;
String ename, eaddr;
SqlConnection con =
new SqlConnection("server=MONTY\\SQLEXPRESS;database=dbemp;
Integrated Security=True");
con.Open();
SqlCommand cmd =new
SqlCommand("insert into tbemp values(@empno,@ename,@eaddr,@esal)",con);
cmd.Parameters.Add("@empno", SqlDbType.VarChar, 50)
.Value = Convert.ToInt32(((TextBox)(GridView1.FooterRow
.FindControl("ftrtxtempno"))).Text);
cmd.Parameters.Add("@ename", SqlDbType.VarChar, 50)
.Value = ((TextBox)(GridView1.FooterRow
.FindControl("ftrtxtename"))).Text;
cmd.Parameters.Add("@eaddr", SqlDbType.VarChar, 50)
.Value = ((TextBox)(GridView1.FooterRow
.FindControl("ftrtxtaddr"))).Text;
cmd.Parameters.Add("@esal", SqlDbType.VarChar, 50)
.Value = Convert.ToInt32(((TextBox)(GridView1.FooterRow
.FindControl("ftrtxtsal"))).Text);
cmd.ExecuteNonQuery();
GridView1.EditIndex = -1;
grid_bind();
cmd.Dispose();
con.Close();
}
}
}
Labels: GridView
