ASP.NET Grid View Insert,Update,select,Edit

Design:
Step 1:In edit column add 1 boundfield(E.No),5 templatefield(name,address,gender,qualification),1 templatefield(Edit),1 Command Field(delete--in property select show deleteButton).
Step 2: In Edit Template
Name - add label in item template ,textbox in edit template and footer template
similarly(address,gender,qualification,,edit)

aspx.cs page

using System;
using System.Collections;
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 parthigrid : System.Web.UI.Page
{
SqlConnection con = new SqlConnection("server=iNFO-PROJECT4\\SQLEXPRESS;database=register;integrated security=true");
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
view();
}


}
void view()
{

DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter("select * from grid1 order by serialno asc", con);
da.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
GridView1.DataSource = ds;
GridView1.DataBind();
}
}




protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("insert"))
{
TextBox tfname = (TextBox)GridView1.FooterRow.FindControl("txtfname");
TextBox tffaddress = (TextBox)GridView1.FooterRow.FindControl("txtfaddress");
RadioButtonList rbtnffgender = (RadioButtonList)GridView1.FooterRow.FindControl("rbtnlfgender");
DropDownList ddfquali = (DropDownList)GridView1.FooterRow.FindControl("ddlfquali");
con.Open();
SqlCommand cmd = new SqlCommand("insert into grid1(name,address,gender,quali) values(@na,@add,@gen,@qual) ", con);
cmd.Parameters.AddWithValue("@na", tfname.Text);

cmd.Parameters.AddWithValue("@add", tffaddress.Text);

cmd.Parameters.AddWithValue("@gen", rbtnffgender.SelectedValue);

cmd.Parameters.AddWithValue("@qual", ddfquali.SelectedValue);
cmd.ExecuteNonQuery();
con.Close();
view();

}
}

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
String id = GridView1.DataKeys[e.RowIndex].Values[0].ToString();
TextBox txname = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtname");
TextBox txaddress = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtaddress");
RadioButtonList rbtngender = (RadioButtonList)GridView1.Rows[e.RowIndex].FindControl("rbtnlgender");
DropDownList ddquali = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("ddlquali");
con.Open();
SqlCommand cmd = new SqlCommand("update grid1 set name=@na,address=@ad,gender=@gen,quali=@qual where serialno=@i", con);
cmd.Parameters.AddWithValue("@i", id);

cmd.Parameters.AddWithValue("@na", txname.Text);

cmd.Parameters.AddWithValue("@ad", txaddress.Text);

cmd.Parameters.AddWithValue("@gen", rbtngender.SelectedValue);

cmd.Parameters.AddWithValue("@qual", ddquali.SelectedValue);

// cmd.Parameters.AddWithValue("@Country", Country);

cmd.ExecuteNonQuery();
GridView1.EditIndex = -1;

view();
}




protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
String id = GridView1.DataKeys[e.RowIndex].Values[0].ToString();
con.Open();
SqlCommand cmd = new SqlCommand("DELETE FROM grid1 where serialno=@i", con);
cmd.Parameters.AddWithValue("@i", id);
cmd.ExecuteNonQuery();
view();

}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
view();
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
view();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
view();
}
}