Hi ,
This Example Will Guid you .
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (!IsPostBack)
{
Getdata();
}
}
}
DataClassesDataContext db = new DataClassesDataContext();
void Getdata() {
var res = from x in db.cates
select x;
GridView1.DataSource = res;
GridView1.DataBind();
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
Getdata();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int Id = Convert.ToInt32((GridView1.Rows[e.RowIndex].FindControl("Label2") as Label).Text);
if (Id == 0)
{
return;
}
var result = (from x in db.cates where x.id == Id select x).FirstOrDefault();
result.cate1 = (GridView1.Rows[e.RowIndex].FindControl("TextBox1") as TextBox).Text;
db.SubmitChanges();
GridView1.EditIndex = -1;
Getdata();
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
int Id = Convert.ToInt32((GridView1.Rows[e.NewEditIndex].FindControl("Label2") as Label).Text);
if (Id == 0)
{
return;
}
GridView1.EditIndex = e.NewEditIndex;
Getdata();
}
<div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
onrowcancelingedit="GridView1_RowCancelingEdit"
onrowediting="GridView1_RowEditing" onrowupdating="GridView1_RowUpdating">
<Columns>
<asp:TemplateField HeaderText="ID">
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("id") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text="<%# Bind('cate1') %>"></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text="<%# Bind('cate1') %>"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:CommandField ShowEditButton="True" />
</Columns>
</asp:GridView>
</div>