ALL GridView Events For Beginners

Saineshwar Bageri
Dec 16, 2013
11.3k
0
0
Blog

What is Gridview ?

Displays the values of a data source in a table where each column represents a field and each row represents a record. The GridView control enables you to select, sort, and edit these items.

Events of Gridview

RowCommand
RowEditing
RowDeleting
RowUpdating
PageIndexChanging

Maingrid.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Maingrid.aspx.cs" Inherits="Maingrid" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

</FooterTemplate>

</asp:TemplateField>
<asp:TemplateField HeaderText="Save" SortExpression="Save">

Create Table Here I Provide Script

CREATE TABLE [dbo].[Food](

[Fid] [bigint] primary key IDENTITY(1,1) NOT NULL,

[Fname] [nvarchar](100) NULL,
[Fprice] [bigint] NULL,

[Recstatus] [char](1) NULL,
)

INSERT INTO Food(Fname,Fprice,Recstatus)VALUES('Dal',2000,'A')

INSERT INTO Food(Fname,Fprice, Recstatus)VALUES('Rice',52000,'A')
// StoredProcedure [dbo].[InsertFood]
// For Inserting and Updating Records
USE [AllSampleCode]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[InsertFood]

@Fid bigint=null,

@Fprice   bigint    =null,
@Fname    nvarchar(100) =null,
@Recstatus    char(1)   =null
as
DECLARE @ReturnValue int
if(@Fid =0)
begin
insert INTO Food
(
Fprice ,
Fname ,
Recstatus
)
VALUES
(
@Fprice   ,
@Fname    ,
@Recstatus

)

SELECT @ReturnValue = SCOPE_IDENTITY()
END

ELSE

begin
update Food

SET

Fprice =@Fprice,
Fname=@Fname ,
Recstatus =@Recstatus
where Fid =@Fid
end

IF (@@ERROR != 0)

BEGIN
RETURN -1
END
ELSE
BEGIN
RETURN @ReturnValue
END

To Bind GridView Using This Method

public void bindgrid()

{
    SqlCommand cmd = new SqlCommand("select * from food ", con);
    cmd.CommandType = CommandType.Text;
    SqlDataAdapter da = new SqlDataAdapter();
    da.SelectCommand = cmd;
    DataTable dt = new DataTable();
    da.Fill(dt);
    if (dt.Rows.Count > 0)
    {
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }
    else
    {
         DataRow dr = dt.NewRow();
         dt.Rows.Add(dr);
         GridView1.DataSource = dt;
         GridView1.DataBind();
    }
}

To Find Control In Gridview Footer

TextBox txtFooterProductname = (TextBox)GridView1.FooterRow.FindControl("txtFooterProductname");

TextBox TxtFooterprice = (TextBox)GridView1.FooterRow.FindControl("TxtFooterprice");DropDownList DrpStatus = (DropDownList)GridView1.FooterRow.FindControl("DrpStatus");

On RowCommand

protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)

{
        // finding controls of footer row
        if (e.CommandName == "ADD") // checking command Name is same as given
        {

            TextBox txtFooterProductname = (TextBox)GridView1.FooterRow.FindControl("txtFooterProductname");
            TextBox TxtFooterprice = (TextBox)GridView1.FooterRow.FindControl("TxtFooterprice");
            DropDownList DrpStatus = (DropDownList)GridView1.FooterRow.FindControl("DrpStatus");

            if (DrpStatus.SelectedIndex == 0)
            {
                ScriptManager.RegisterStartupScript(this, this.GetType(), "Alert", "alert('Select Status ')", true);
            }
            else
            {
                    con.Open();
                    SqlCommand cmd = new SqlCommand("InsertFood", con);
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.AddWithValue("@Fid", 0);
                    cmd.Parameters.AddWithValue("@Fprice", TxtFooterprice.Text);
                    cmd.Parameters.AddWithValue("@Fname", txtFooterProductname.Text);
                    cmd.Parameters.AddWithValue("@Recstatus", DrpStatus.SelectedItem.Text);
                    cmd.ExecuteNonQuery();
                    con.Close();
                    bindgrid();

}

}
}

On RowEditing

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

{
GridView1.EditIndex = e.NewEditIndex;
bindgrid();
}

On RowDeleting

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

{
      Label txt = (Label)GridView1.Rows[e.RowIndex].FindControl("Label4");
      if (txt.Text == "A")
      {
            int userid = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values["Fid"].ToString());
            SqlCommand cmd = new SqlCommand("Delete From Food where Fid= " + userid, con);
            cmd.CommandType = CommandType.Text;
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
            bindgrid();
      }
}

On RowUpdating

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

{
        Button btn = (Button)GridView1.Rows[e.RowIndex].FindControl("btnupdate");
        if (btn.CommandName == "Update")
        {
            int userid = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString());
            TextBox TextBox2 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox2");
            TextBox TextBox3 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox3");
            TextBox TextBox4 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox4");
            DropDownList DrpStatusEdit = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("DrpStatusEdit");
            if (DrpStatusEdit.SelectedValue == "1")
            {
                con.Open();
                SqlCommand cmd = new SqlCommand("InsertFood", con);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@Fid", userid);
                cmd.Parameters.AddWithValue("@Fprice", TextBox3.Text);
                cmd.Parameters.AddWithValue("@Fname", TextBox2.Text);
                cmd.Parameters.AddWithValue("@Recstatus", DrpStatusEdit.SelectedItem.Text);
                cmd.ExecuteNonQuery();
                con.Close();
            }

GridView1.EditIndex = -1;

bindgrid();
}
}

On PageIndexChanging

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)

{
GridView1.PageIndex = e.NewPageIndex;
bindgrid();
}