database is not updating. I didn't get any error too.
name is id of textbox where i try to edit the text of textbox but i get old one value through this name id
so database is not updating
protected void Button2_Click(object sender, EventArgs e)
{
Session["name"] = name.Text.ToString();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
con.Open();
cmd.CommandText = "update category set category=@cat where Id=@id";
cmd.Parameters.AddWithValue("@cat", Session["name"].ToString());
cmd.Parameters.AddWithValue("@id", Session["cate"].ToString());
cmd.ExecuteNonQuery();
con.Close();
ClientScript.RegisterStartupScript(Page.GetType(), "validation", "<script language='javascript'>alert(' Updated successfully')</script>");
Response.Redirect("category.aspx");
GridView1.DataBind();
}
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="Id"
DataSourceID="SqlDataSource1" CssClass="table table-striped table-bordered table-hover">
<Columns>
<asp:TemplateField>
<ItemTemplate>
<a href="?id=<%#Eval("Id") %>">
<input type="button" name="button" value="Update" style="color: black; font: bolder" />
</a>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<a href="?did=<%#Eval("Id") %>">
<input type="button" name="button" value="Delete" style="color:black; font:bolder" class"btn" />
</a>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="Id" Visible="false" HeaderText="Id" InsertVisible="False"
ReadOnly="True" SortExpression="Id" HeaderStyle-CssClass="visible-lg" ItemStyle-CssClass="visible-lg"
ItemStyle-Width="100px"></asp:BoundField>
<asp:BoundField DataField="category" HeaderText="Category Name" SortExpression="category"
HeaderStyle-CssClass="visible-lg" ItemStyle-CssClass="visible-lg"></asp:BoundField>
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT * FROM [category]"></asp:SqlDataSource>
