► Add add commandField in your gridview:
<asp:CommandField ButtonType="Button"
ShowDeleteButton="True" ShowEditButton="True"
ShowSelectButton="True" />
►Implement the following events:
onrowcancelingedit="GridView1_RowCancelingEdit"
onrowdeleting="GridView1_RowDeleting"
onrowediting="GridView1_RowEditing"
onrowupdating="GridView1_RowUpdating"
.CS Code
static string ConnString ="ConnectionString";
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//Code to bind gridview
}
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
//Code to bind gridview
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int id = int.Parse(((Label)GridView1.Rows[e.RowIndex].FindControl("lblid")).Text);//ID
string name = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtname")).Text;
SqlConnection connect = new SqlConnection(ConnString);
connect.Open();
string q = "Update people set name=@name where id=@id";
SqlCommand comm = new SqlCommand(q, connect);
comm.Parameters.AddWithValue("name", name);
comm.Parameters.AddWithValue("id", id);
comm.ExecuteNonQuery();
connect.Close();
GridView1.EditIndex = -1;
//Code to bind gridview
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
BindGrid();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int id = int.Parse(((Label)GridView1.Rows[e.RowIndex].FindControl("lblid")).Text);//ID
SqlConnection connect = new SqlConnection(ConnString);
connect.Open();
string q = "Delete from table where id=@id";
SqlCommand comm = new SqlCommand(q, connect);
comm.Parameters.AddWithValue("id", id);
comm.ExecuteNonQuery();
connect.Close();
GridView1.EditIndex = -1;
//Code to bind gridview
}