How to Use Own Command Name in GridView Control
We know we have "edit" command name for editing in gridview
We know we have "delete" command name for deleting in gridview
We know we have "cancel" command name for canceling in gridview
Now We Make Own Command Name For Save the record.
The following Code for the Default.aspx page (Source Page):-
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
ShowFooter="True" onrowcancelingedit="GridView1_RowCancelingEdit"
onrowcommand="GridView1_RowCommand" onrowediting="GridView1_RowEditing"
onrowupdating="GridView1_RowUpdating" BackColor="#DEBA84"
BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px" CellPadding="3"
CellSpacing="2" onrowdeleting="GridView1_RowDeleting" Width="775px">
<FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />
<RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" />
<Columns>
<asp:TemplateField HeaderText="EmpNo">
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%#Eval("empno")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%#Eval("empno")%>'></asp:Label>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text=""></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Name">
<ItemTemplate>
<asp:Label ID="Label3" runat="server" Text='<%#Eval("ename")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%#Eval("ename")%>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="TextBox3" runat="server" Text=""></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Address">
<ItemTemplate>
<asp:Label ID="Label4" runat="server" Text='<%#Eval("eaddr")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="TextBox4" runat="server" Text='<%#Eval("eaddr")%>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="TextBox5" runat="server" Text=""></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Salary">
<ItemTemplate>
<asp:Label ID="Label5" runat="server" Text='<%#Eval("esal")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="TextBox6" runat="server" Text='<%#Eval("esal")%>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="TextBox7" runat="server" Text=""></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server" Text="EDIT" CommandName="edit"></asp:LinkButton>
<asp:LinkButton ID="LinkButton2" runat="server" Text="DELETE" CommandName="delete"></asp:LinkButton>
</ItemTemplate>
<EditItemTemplate>
<asp:LinkButton ID="LinkButton3" runat="server" Text="UPDATE" CommandName="update"></asp:LinkButton>
<asp:LinkButton ID="LinkButton4" runat="server" Text="CANCEL" CommandName="cancel"></asp:LinkButton>
</EditItemTemplate>
<FooterTemplate>
<asp:LinkButton ID="LinkButton5" runat="server" Text="SAVE" CommandName="save"></asp:LinkButton>
</FooterTemplate>
</asp:TemplateField>
</Columns>
<PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />
</asp:GridView>
</div>
</form>
The following 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();
}
}
public void grid_bind()
{
SqlDataAdapter adp = new SqlDataAdapter("select * from tbemp",
"server=monty\\baljeet;database=dbemp;uid=sa;pwd=123456789");
DataSet ds = new DataSet();
adp.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}
protected void GridView1_RowUpdating(object sender,
GridViewUpdateEventArgs e)
{
Int32 empno,esal;
String ename, eaddr;
empno = Convert.ToInt32(((Label)
(GridView1.Rows[e.RowIndex].FindControl("Label2"))).Text);
ename = ((TextBox)
(GridView1.Rows[e.RowIndex].FindControl("TextBox2"))).Text;
eaddr = ((TextBox)
(GridView1.Rows[e.RowIndex].FindControl("TextBox4"))).Text;
esal = Convert.ToInt32(((TextBox)
(GridView1.Rows[e.RowIndex].FindControl("TextBox6"))).Text);
SqlConnection con = new
SqlConnection("server=monty\\baljeet;database=dbemp;uid=sa;
pwd=123456789");
SqlCommand cmd = new
SqlCommand("update tbemp set ename=@ename,eaddr=@eaddr,esal=@esal
where empno=@empno",con);
con.Open();
cmd.Parameters.Add("@empno", SqlDbType.Int).Value = empno;
cmd.Parameters.Add("@ename", SqlDbType.VarChar,50).
Value = ename;
cmd.Parameters.Add("@eaddr", SqlDbType.VarChar,50).
Value = eaddr;
cmd.Parameters.Add("@esal", SqlDbType.Int).Value = esal;
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
GridView1.EditIndex = -1;
grid_bind();
}
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_RowCommand(object sender,
GridViewCommandEventArgs e)
{
if (e.CommandName == "save")
{
Int32 empno, esal;
String ename, eaddr;
empno = Convert.ToInt32(((TextBox)
(GridView1.FooterRow.FindControl("TextBox1"))).Text);
ename = ((TextBox)
(GridView1.FooterRow.FindControl("TextBox3"))).Text;
eaddr = ((TextBox)
(GridView1.FooterRow.FindControl("TextBox5"))).Text;
esal = Convert.ToInt32(((TextBox)
(GridView1.FooterRow.FindControl("TextBox7"))).Text);
SqlConnection con = new
SqlConnection("server=monty\\baljeet;database=dbemp;uid=sa;
pwd=123456789");
SqlCommand cmd = new
SqlCommand("insert into tbemp values(@empno,@ename,@eaddr,@esal)",
con);
con.Open();
cmd.Parameters.Add("@empno", SqlDbType.Int).Value = empno;
cmd.Parameters.Add("@ename", SqlDbType.VarChar,50)
.Value = ename;
cmd.Parameters.Add("@eaddr", SqlDbType.VarChar,50)
.Value = eaddr;
cmd.Parameters.Add("@esal", SqlDbType.Int).Value = esal;
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
GridView1.EditIndex = -1;
grid_bind();
}
}
protected void GridView1_RowDeleting(object sender,
GridViewDeleteEventArgs e)
{
Int32 empno;
empno = Convert.ToInt32(((Label)
(GridView1.Rows[e.RowIndex].FindControl("Label1"))).Text);
SqlConnection con = new
SqlConnection("server=monty\\baljeet;database=dbemp;uid=sa;
pwd=123456789");
SqlCommand cmd = new
SqlCommand("delete from tbemp where empno=@empno", con);
con.Open();
cmd.Parameters.Add("@empno", SqlDbType.Int).Value = empno;
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
GridView1.EditIndex = -1;
grid_bind();
}
}
Labels: GridView
