<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" OnRowCancelingEdit="GridView1_RowCancelingEdit" OnRowDeleting="GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating">
<Columns>
<asp:TemplateField HeaderText="id">
<ItemTemplate>
<asp:Label ID="lbl" runat="server" Text='<%#Eval("Id") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="name">
<ItemTemplate>
<%#Eval("name") %>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtname" runat="server" Text='<%#Eval("name") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:CommandField ShowDeleteButton="true" ShowEditButton="true" />
</Columns>
</asp:GridView>
public partial class Gridview : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
getdata();
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Label l1 = (Label)GridView1.Rows[e.RowIndex].FindControl("lbl");
TextBox t1=(TextBox)GridView1.Rows[e.RowIndex].FindControl("txtname");
SqlConnection cn = new SqlConnection(@"Data
Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\anwesh@codem.in\Documents\Visual
Studio 2012\WebSites\contact us\App_Data\Database.mdf;Integrated
Security=True");
cn.Open();
SqlCommand cmd = new SqlCommand("update gridview set
name='"+t1.Text+"' where Id='"+l1.Text+"'",cn);
int a=cmd.ExecuteNonQuery();
if (a > 0)
{
GridView1.EditIndex = -1;
getdata();
}
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
getdata();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
Label l1 = (Label)GridView1.Rows[e.RowIndex].FindControl("lbl");
SqlConnection cn = new SqlConnection(@"Data
Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\anwesh@codem.in\Documents\Visual
Studio 2012\WebSites\contact us\App_Data\Database.mdf;Integrated
Security=True");
cn.Open();
SqlCommand cmd = new SqlCommand("delete from gridview
where Id='" + l1.Text + "'", cn);
int a = cmd.ExecuteNonQuery();
if (a > 0)
{
GridView1.EditIndex = -1;
getdata();
}
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
getdata();
}
public void getdata()
{
SqlConnection cn = new SqlConnection(@"Data
Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\anwesh@codem.in\Documents\Visual
Studio 2012\WebSites\contact us\App_Data\Database.mdf;Integrated
Security=True");
SqlDataAdapter da = new SqlDataAdapter("select * from
gridview",cn);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
}
