.: GridView

Showing posts with label GridView. Show all posts

How To Use Own Command Name In GridView

Posted by Baljeet Singh

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):-

<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">

<asp:TemplateField HeaderText="EmpNo">

<asp:Label ID="Label1" runat="server" Text='<%#Eval("empno")%>'></asp:Label>

</ItemTemplate>

<asp:Label ID="Label2" runat="server" Text='<%#Eval("empno")%>'></asp:Label>

</EditItemTemplate>

<asp:TextBox ID="TextBox1" runat="server" Text=""></asp:TextBox>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Name">

<asp:Label ID="Label3" runat="server" Text='<%#Eval("ename")%>'></asp:Label>

</ItemTemplate>

<asp:TextBox ID="TextBox2" runat="server" Text='<%#Eval("ename")%>'></asp:TextBox>

</EditItemTemplate>

<asp:TextBox ID="TextBox3" runat="server" Text=""></asp:TextBox>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Address">

<asp:Label ID="Label4" runat="server" Text='<%#Eval("eaddr")%>'></asp:Label>

</ItemTemplate>

<asp:TextBox ID="TextBox4" runat="server" Text='<%#Eval("eaddr")%>'></asp:TextBox>

</EditItemTemplate>

<asp:TextBox ID="TextBox5" runat="server" Text=""></asp:TextBox>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Salary">

<asp:Label ID="Label5" runat="server" Text='<%#Eval("esal")%>'></asp:Label>

</ItemTemplate>

<asp:TextBox ID="TextBox6" runat="server" Text='<%#Eval("esal")%>'></asp:TextBox>

</EditItemTemplate>

<asp:TextBox ID="TextBox7" runat="server" Text=""></asp:TextBox>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField>

<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>

<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>

<asp:LinkButton ID="LinkButton5" runat="server" Text="SAVE" CommandName="save"></asp:LinkButton>

</FooterTemplate>

</asp:TemplateField>

</Columns>

</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();



}

}

GridView Control in ASP.NET 4.0

Posted by Baljeet Singh

Hello Friends,

Today i am share with you a GridView Control Program.
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 Server Name is :- MONTY\\SQLEXPRESS
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.
You just write the following code within the start and end tag of the BODY.

<form id="form1" runat="server">
<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();



 }

}

}

;;

.

ASP.NET Related Search

HERE

Baljeet Singh

About Me

Follow Me

How To Use Own Command Name In GridView

How to Use Own Command Name in GridView Control

The following Code for the Default.aspx page (Source Page):-

The following Code for the Default.aspx.cs page :-

GridView Control in ASP.NET 4.0

Today i am share with you a GridView Control Program.
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

This is the code for the Default.aspx of the Source Mode.
You just write the following code within the start and end tag of the BODY.

ONLINE JOBS

Labels

I NEED HITS

Followers

VISITOR'S NUMBER

.

ASP.NET Related Search

HERE

Baljeet Singh

About Me

Follow Me

How To Use Own Command Name In GridView

How to Use Own Command Name in GridView Control

The following Code for the Default.aspx page (Source Page):-

The following Code for the Default.aspx.cs page :-

GridView Control in ASP.NET 4.0

Today i am share with you a GridView Control Program. 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

This is the code for the Default.aspx of the Source Mode. You just write the following code within the start and end tag of the BODY.

ONLINE JOBS

Labels

I NEED HITS

Followers

VISITOR'S NUMBER

Today i am share with you a GridView Control Program.
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

This is the code for the Default.aspx of the Source Mode.
You just write the following code within the start and end tag of the BODY.