Friday 18 November 2011

Row command event of the gridview


Introduction: Hello guys, in this article i will explain that how we can  work with the rowcommand event of the gridview. This article will very helpful for the .net developers.

Implementation: Create a page named rw_commamnd.Place  four textboxes and a button and a gridview. And set their id as txt_name,txt _age,txt_paswrd and txt_repswrd respectively.  


Code for .aspx page:
head runat="server">
    <title>Row command event</title>
 
</head>
<body>
    <form id="form1" runat="server">
    <div>
   
        <table >
            <tr>
                <td>
                    Name</td>
                <td>
                    <asp:TextBox ID="txt_name" runat="server"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td >
                    Age</td>
                <td>
                    <asp:TextBox ID="txt_age" runat="server"></asp:TextBox>
                </td>
            </tr>
     
            <tr>
                <td >
                    Password</td>
                <td>
                    <asp:TextBox ID="txt_pswrd" runat="server" TextMode="Password"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    Retype_password</td>
                <td>
                    <asp:TextBox ID="txt_repswrd" runat="server" TextMode="Password"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    &</td>
                <td>
                    <asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Button" />
                </td>
            </tr>
        </table>
   
    </div>
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
        onrowcommand="GridView1_RowCommand" CellPadding="4" ForeColor="#333333"
        GridLines="None">
        <RowStyle BackColor="#E3EAEB" />
        <Columns>
            <asp:TemplateField HeaderText="Name">
                <ItemTemplate>
                    <asp:Label ID="Label1" runat="server" Text='<%# Eval("Name") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Age">
                <ItemTemplate>
                    <asp:Label ID="Label2" runat="server" Text='<%# Eval("Age") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Login_status">
            <%--here am placing the link button and set its commandargument a id and
            set its commandname as abc and set text with the value that will come inside the
            Login_status columnit can be
             --%>
                <ItemTemplate>
                    <asp:LinkButton ID="LinkButton2" runat="server"
                        CommandArgument='<%#Eval("id") %>' CommandName="abc"
                        Text='<%# Eval("Login_status") %>'></asp:LinkButton>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Password">
                <ItemTemplate>
                    <asp:Label ID="Label4" runat="server" Text='<%# Eval("Password") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Retype_password" >
                <ItemTemplate>
                    <asp:Label ID="Label5" runat="server" Text='<%# Eval("Retype_password") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="delete">
              <%--here am placing the link button and set its commandargument a id and
            set its commandname as del
             --%>
                <ItemTemplate>
               
                    <asp:LinkButton ID="LinkButton3" runat="server"
                        CommandArgument='<%# Eval("id") %>' CommandName="del"
                       
                        onclientclick="confirm return('Are you sure want to delete the current record')">delete</asp:LinkButton>
                </ItemTemplate>
            </asp:TemplateField>
        </Columns>
        <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
        <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
        <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
        <EditRowStyle BackColor="#7C6F57" />
        <AlternatingRowStyle BackColor="White" />
    </asp:GridView>
    <br />
    </form>
</body>
</html>
Code for 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
{
    // here i am declaring some object for datatable,SqlConnection,SqlDataAdapter
    SqlConnection con = new SqlConnection();
    SqlDataAdapter adp;
    DataTable dt;
    SqlCommand cmd = new SqlCommand();


    protected void Page_Load(object sender, EventArgs e)
    {
        //  here i am declaring  connectionstring
            con.ConnectionString = ConfigurationManager.ConnectionStrings["con"].ConnectionString;
            con.Open();
            //  here i am open the connection if the connection is closed
           if (con.State == ConnectionState.Closed)
          {
            con.Open();
          }
            con.Close();
         if (IsPostBack == false)
          {
              // here i am calling the function that will bind the gridview
            grd_data();
          }
    }

    private void grd_data()
    {
        // this function will bind the gridview dynamically
         if (con.State == ConnectionState.Closed)
          {
            con.Open();
          }
            adp = new SqlDataAdapter("select * from tb_user order by id asc",con);
            dt = new DataTable();
            // here i m filling the dt with the values those will come inside the SqlDataAdapter adp
            adp.Fill(dt);
            adp.Dispose();
            // here i am checking the rows those will come inside the dt
            GridView1.DataSource = dt;
            GridView1.DataBind();
            con.Close();
    }


    protected void Button1_Click(object sender, EventArgs e)
    {
          // this code is used to insert the value inside the table
          //  here i am open the connection if the connection is closed
          if (con.State == ConnectionState.Closed)
          {
            con.Open();
          }
         // here m declaring the sql query to inser the values
            cmd.CommandText = "insert into tb_user values(@name,@age,default,@password,@retype_password)";
            cmd.Connection = con;
            // below m declaring the parameters for this insert query
           
            cmd.Parameters.Add("@name", SqlDbType.VarChar, 50).Value = txt_name.Text;
            cmd.Parameters.Add("@age", txt_age.Text);
            cmd.Parameters.Add("@password", SqlDbType.VarChar, 50).Value = txt_pswrd.Text;
            cmd.Parameters.Add("@retype_password", SqlDbType.VarChar, 50).Value = txt_repswrd.Text;
            cmd.ExecuteNonQuery();
            cmd.Dispose();
            txt_name.Text = "";
            txt_age.Text = "";
           
            txt_pswrd.Text = "";
            txt_repswrd.Text = "";
            con.Close();
        // here m calling the function named grd_bind after insertion  this function will call
        // and  display the data with the new row that will insert presently
            grd_data();
    }
   
   
    //GridView-properties-(Events)-Rowcommand-doubleor  click
    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        // this code for  Rowcommand event
            Int32 i;
            // inside the i variable m putting the id that will come inside the CommandArgument
            //inside the source code m binding the CommandArgument with the id
            i = Convert.ToInt32(e.CommandArgument);
        if (con.State == ConnectionState.Closed)
          {
            con.Open();
          }
        // here m checking the commandname of the linkbutton.

        if (e.CommandName == "abc")
       {
            // if the commandname will abc then this condition will work
           // here m selecting the login_status correspondence of this id
            adp = new SqlDataAdapter("select login_status from tb_user where id=@id", con);
            adp.SelectCommand.Parameters.AddWithValue("@id", i);
            dt = new DataTable();
            adp.Fill(dt);
            adp.Dispose();

            if (dt.Rows[0]["login_status"].ToString() == "No")
          {
              // if the login_status will no then this condition will works
              // and here m updating the the login_status with the value yes
              //
            cmd = new SqlCommand("update tb_user set login_status=@login_status where id=@id", con);
            cmd.Parameters.AddWithValue("@login_status", "Yes");
            cmd.Parameters.AddWithValue("@id", i);
            cmd.ExecuteNonQuery();
            cmd.Dispose();
          }
            else
          {
              // if the login_status will yes then this condition will works
              // and here m updating the the login_status with the value No
            cmd = new SqlCommand("update tb_user set login_status=@login_status where id=@id", con);
            cmd.Parameters.AddWithValue("@login_status", "No");
            cmd.Parameters.AddWithValue("@id", i);
            cmd.ExecuteNonQuery();
            cmd.Dispose();
          }
          
       }
        // here m checking the commandname of the linkbutton.
            if (e.CommandName == "del")
            {
                // if the commandname will abc then this condition will work
                // here m deleting the data from the column correspondence of this id
                cmd = new SqlCommand("delete from tb_user where id=@id", con);
                cmd.Parameters.AddWithValue("@id", i);
                cmd.ExecuteNonQuery();
                cmd.Dispose();
            }


            grd_data();
            con.Close();

    }
}
See output in this image:
See inside the gridview, login_status column.  You can change the status after pressing the no. it changes no to yes ans yes to no






Sql Script for database:
/****** Object:  Default [DF_tb_user_Login_status]    Script Date: 12/04/2011 10:49:24 ******/
IF  EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_tb_user_Login_status]') AND parent_object_id = OBJECT_ID(N'[dbo].[tb_user]'))
Begin
ALTER TABLE [dbo].[tb_user] DROP CONSTRAINT [DF_tb_user_Login_status]

End
GO
/****** Object:  Table [dbo].[tb_user]    Script Date: 12/04/2011 10:49:24 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_user]') AND type in (N'U'))
DROP TABLE [dbo].[tb_user]
GO
/****** Object:  Table [dbo].[tb_user]    Script Date: 12/04/2011 10:49:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_user]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[tb_user](
      [id] [int] IDENTITY(1,1) NOT NULL,
      [Name] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
      [Age] [int] NULL,
      [Login_status] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
      [Password] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
      [Retype_password] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 CONSTRAINT [PK_tb_user] PRIMARY KEY CLUSTERED
(
      [id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)
)
END
GO
SET IDENTITY_INSERT [dbo].[tb_user] ON
INSERT [dbo].[tb_user] ([id], [Name], [Age], [Login_status], [Password], [Retype_password]) VALUES (2, N'vikram', 30, N'Yes', N'vikram', N'vikram')
INSERT [dbo].[tb_user] ([id], [Name], [Age], [Login_status], [Password], [Retype_password]) VALUES (3, N'Bharat', 23, N'No', N'bharat', N'bharat')
SET IDENTITY_INSERT [dbo].[tb_user] OFF
/****** Object:  Default [DF_tb_user_Login_status]    Script Date: 12/04/2011 10:49:24 ******/
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_tb_user_Login_status]') AND parent_object_id = OBJECT_ID(N'[dbo].[tb_user]'))
Begin
ALTER TABLE [dbo].[tb_user] ADD  CONSTRAINT [DF_tb_user_Login_status]  DEFAULT ('No') FOR [Login_status]

End
GO
Conclusion
Through this article, you have learned how to work  rowcommand event inside the gridview.