public partial class _Default : System.Web.UI.Page
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ConnectionString);
SqlDataAdapter da;
DataSet ds;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
filldata();
}
}
public void filldata()
{
string str = “select * from login”;
da = new SqlDataAdapter(str,con);
ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string uname=GridView1.Rows[0].Cells[2].Text;
string qyry = “delete from login where uname=’”+uname+”‘”;
da = new SqlDataAdapter(qyry,con);
ds = new DataSet();
da.Fill(ds);
filldata();
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
filldata();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
TextBox txtunam = (TextBox)GridView1.Rows[e.RowIndex].Cells[2].Controls[0];
TextBox txtpassword = (TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[0];
TextBox txtconfirmpwd = (TextBox)GridView1.Rows[e.RowIndex].Cells[4].Controls[0];
TextBox txtemail = (TextBox)GridView1.Rows[e.RowIndex].Cells[5].Controls[0];
//string qry = “update login set password=’”+txtpassword.Text+”‘,confirm_password=’”+txtconfirmpwd.Text+”‘,email=’”+txtemail.Text+”‘where uname=’”+txtunam.Text+”‘”;
string qryy = “update login set password=’”+txtpassword.Text+”‘,confirm_password=’”+txtconfirmpwd.Text+”‘,email=’”+txtemail.Text+”‘where uname=’”+txtunam.Text+”‘”;
da = new SqlDataAdapter(qryy, con);
ds = new DataSet();
da.Fill(ds);
GridView1.EditIndex = -1;
filldata();
}

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

}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
filldata();
}
}

———————————————————————————————————-

In .aspx side you need to add a GridView data control.
for update/delete you have to define the datakey in gridview at aspx side:

———————————————————————————————————–

<form id=”form1″ runat=”server”>
<div>
<asp:GridView ID=”GridView1″ runat=”server” AllowPaging=”True” OnPageIndexChanging=”GridView1_PageIndexChanging”
OnRowCancelingEdit=”GridView1_RowCancelingEdit” OnRowDeleting=”GridView1_RowDeleting”
OnRowEditing=”GridView1_RowEditing” OnRowUpdating=”GridView1_RowUpdating” OnSelectedIndexChanged=”GridView1_SelectedIndexChanged”
PageSize=”3″ Style=”z-index: 100; left: 0px; position: absolute; top: 0px”>
<Columns>
<asp:CommandField ShowEditButton=”True” />
<asp:CommandField ShowDeleteButton=”True” />
</Columns>
</asp:GridView>

</div>
</form>