Simple & Complete Gridview Functionality(dotnet 2.0) by Syed Shees Abidi

My this article covers GridView functionality in a Complte,Simple & Precise way in ASP.NET(2.0), C#,(SQLServer 2005 backend). This article provides a single GridView which is capable of
~Displaying Data from database,
~Updateing it if required,
~Deleting the existing records from database based on a Confirmation Message and
~Inserting a new record(which is beyond the implicit usage of GridView).

NOTE: The application requires three simple stored procedures named empins,empupd,empdel for updation insertion and deletion respectively.

           Gridview Update Source

 
               
    

           
                 
   

Delete??

               
                   
                                                    Width="61px">
                   
                   
                        Employee ID
                   
                   
                       
                   
               
               
                   
                       
                   
                   
                        Employee Name
                   
                   
                       
                   
               
               
                   
                       
                   
                   
                        Contact No
                   
                   
                       
                   
               
           
                  

Gridview Update C# Source Code:>/u>

using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) BindData(); }

private void BindData() { try { string connectionString = "Data Source=MDYNYCCMTDEV;Initial Catalog=pubs;User ID=rast;Password=rast05"; string commandString = "select * from Employee1 order by EmployeeID asc"; SqlConnection con = new SqlConnection(connectionString); SqlDataAdapter da = new SqlDataAdapter(commandString, con); con.Open(); DataSet ds = new DataSet(); da.Fill(ds);

GridView1.DataSource = ds; GridView1.DataBind(); con.Close(); } catch (Exception ex) { Response.Write(ex.Message); } }

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) { GridView1.EditIndex = e.NewEditIndex; BindData(); } protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { if (((LinkButton)GridView1.Rows[0].Cells[0].Controls[0]).Text == "Insert") { TextBox TextBox1; string EmployeeName, ContactNo; TextBox1 = (TextBox)GridView1.Rows[0].FindControl("txtEmployeeName"); EmployeeName = TextBox1.Text; TextBox1 = (TextBox)GridView1.Rows[0].FindControl("txtContactNo"); ContactNo = TextBox1.Text;

SqlConnection con = new SqlConnection("Data Source=MDYNYCCMTDEV;Initial Catalog=pubs;User ID=rast;Password=rast05");

SqlCommand cmd = new SqlCommand("empins", con); cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.Add("@EmployeeName", SqlDbType.VarChar, 50); cmd.Parameters.Add("@ContactNo", SqlDbType.VarChar, 50);

cmd.Parameters["@EmployeeName"].Value = EmployeeName; cmd.Parameters["@ContactNo"].Value = ContactNo;

con.Open();

cmd.ExecuteNonQuery();

con.Close(); GridView1.EditIndex = -1;

BindData();

}

else {

Label Label1; TextBox TextBox1;

string EmployeeID, EmployeeName, ContactNo; Label1 = (Label)GridView1.Rows[e.RowIndex].FindControl("lblEmployeeIDEdit"); EmployeeID = Label1.Text; TextBox1 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtEmployeeName"); EmployeeName = TextBox1.Text; TextBox1 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtContactNo"); ContactNo = TextBox1.Text;

SqlConnection con = new SqlConnection("Data Source=MDYNYCCMTDEV;Initial Catalog=pubs;User ID=rast;Password=rast05"); SqlCommand cmd = new SqlCommand("empupd", con); cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.Add("@EmployeeID", SqlDbType.Int); cmd.Parameters.Add("@EmployeeName", SqlDbType.VarChar, 50); cmd.Parameters.Add("@ContactNo", SqlDbType.VarChar, 50);

cmd.Parameters["@EmployeeID"].Value = EmployeeID; cmd.Parameters["@EmployeeName"].Value = EmployeeName; cmd.Parameters["@ContactNo"].Value = ContactNo;

con.Open(); cmd.ExecuteNonQueryon.Close();

GridView1.EditIndex = -1;

BindData(); }

}

protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) { GridView1.EditIndex = -1; BindData(); }

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { Label Label1; string EmployeeID;

Label1 = (Label)GridView1.Rows[e.RowIndex].FindControl("lblEmployeeID");

EmployeeID = Label1.Text;

SqlConnection con = new SqlConnection("Data Source=MDYNYCCMTDEV;Initial Catalog=pubs;User ID=rast;Password=rast05"); SqlCommand cmd = new SqlCommand("empdel", con); cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.Add("@EmployeeID", SqlDbType.Int); cmd.Parameters["@EmployeeID"].Value = EmployeeID;

con.Open(); cmd.ExecuteNonQuery(); con.Close();

GridView1.EditIndex = -1;

BindData(); }

protected void btnaddrec_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection("Data Source=MDYNYCCMTDEV;Initial Catalog=pubs;User ID=rast;Password=rast05"); SqlDataAdapter da = new SqlDataAdapter("SELECT * from Employee1", con); DataTable dt = new DataTable(); da.Fill(dt);

DataRow dr = dt.NewRow(); dt.Rows.InsertAt(dr, 0);

GridView1.EditIndex = 0; GridView1.DataSource = dt; GridView1.DataBind();

((LinkButton)GridView1.Rows[0].Cells[0].Controls[0]).Text = "Insert"; } }

My this article covers GridView functionality in a Complte,Simple & Precise way in ASP.NET(2.0), C#,(SQLServer 2005 backend). This article provides a single GridView which is capable of
~Displaying Data from database,
~Updateing it if required,
~Deleting the existing records from database based on a Confirmation Message and
~Inserting a new record(which is beyond the implicit usage of GridView).

NOTE: The application requires three simple stored procedures named empins,empupd,empdel for updation insertion and deletion respectively.

About the Author

Syed Shees Abidi, Syntel Ltd., Mumbai(India) Home Place:Lucknow