GRIDVIEW COLUMN NOT GETTING UPDATED
Hi friends plzz go through this code and let me know whats the problem with this..Here the gridview column is not getting updated and even the delete button works but also gives and error... plzz help...
PAGE SOURCE IS:
<asp:GridView ID="gvcategory" runat="server" AutoGenerateColumns="False"
OnPageIndexChanging="gvcategory_PageIndexChanging"
OnRowCancelingEdit="gvcategory_RowCancelingEdit"
OnRowDeleting="gvcategory_RowDeleting" OnRowEditing="gvcategory_RowEditing"
OnRowUpdating="gvcategory_RowUpdating"
BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px"
CellPadding="3" GridLines="Vertical" AllowPaging="True" Width="50%">
<FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
<RowStyle BackColor="#EEEEEE" ForeColor="Black" />
<Columns>
<asp:TemplateField HeaderText="category id">
<ItemTemplate>
<asp:Label ID="lblcatid" runat="server" Text='<%#Eval("category_id") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="category name">
<ItemTemplate>
<asp:TextBox ID="txtcategory" runat="server" Text='<%#Eval("category_name") %>'></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
<EditItemTemplate>
<asp:LinkButton ID="lnkbtnUpdate" CausesValidation="true" CommandName="update" runat="server" Text="update"></asp:LinkButton>
<asp:LinkButton ID="lnkbtnCancel" runat="server" Text="cancel" CommandName="cancel" CausesValidation="true"></asp:LinkButton>
</EditItemTemplate>
<ItemTemplate>
<asp:LinkButton ID="lnkEdit" runat="server" CausesValidation="true" CommandName="edit" Text="edit"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
<asp:CommandField ShowDeleteButton="True" />
</Columns>
<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="#DCDCDC" />
</asp:GridView>
CODE BEHIND IS:
Imports System.Data.SqlClient
Imports System.Data
Partial Class management_add_category
Inherits System.Web.UI.Page
Dim obj As New data
Dim da As SqlDataAdapter
Dim ds As DataSet
Protected Sub btnadd_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnadd.Click
obj.Connect()
obj.cmd.CommandText = "insert into category_master(category_name)values('" & txtcategory.Text & "')"
obj.cmd.ExecuteNonQuery()
MsgBox("category added!", MsgBoxStyle.Information, "Mohire`s")
txtcategory.Text = ""
obj.db.Close()
fill_data()
End Sub
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Session("user_id") = "" Then
Response.Redirect("admin_login.aspx")
End If
fill_data()
End Sub
Private Sub fill_data()
obj.Connect()
obj.cmd.CommandText = "Select * from category_master order by category_id asc"
da = New SqlDataAdapter(obj.cmd)
ds = New DataSet
da.Fill(ds, "category_master")
gvcategory.DataSource = ds.Tables("category_master")
gvcategory.DataBind()
obj.db.Close()
End Sub
Protected Sub gvcategory_PageIndexChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewPageEventArgs) Handles gvcategory.PageIndexChanging
gvcategory.PageIndex = e.NewPageIndex
fill_data()
End Sub
Protected Sub gvcategory_RowCancelingEdit(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCancelEditEventArgs) Handles gvcategory.RowCancelingEdit
gvcategory.EditIndex = -1
fill_data()
End Sub
Protected Sub gvcategory_RowDeleting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewDeleteEventArgs) Handles gvcategory.RowDeleting
Dim l1 As Label = CType(gvcategory.Rows(e.RowIndex).FindControl("lblcatid"), Label)
obj.Connect()
obj.cmd.CommandText = "delete category_master where category_id=" & l1.Text & ""
obj.cmd.ExecuteNonQuery()
gvcategory.EditIndex = -1
MsgBox("category deleted!", MsgBoxStyle.Information, "Mohire`s")
obj.db.Close()
fill_data()
End Sub
Protected Sub gvcategory_RowEditing(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewEditEventArgs) Handles gvcategory.RowEditing
gvcategory.EditIndex = e.NewEditIndex
fill_data()
End Sub
Protected Sub gvcategory_RowUpdating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles gvcategory.RowUpdating
Try
Dim l1 As Label = CType(gvcategory.Rows(e.RowIndex).FindControl("lblcatid"), Label)
Dim txtcatname As TextBox = CType(gvcategory.Rows(e.RowIndex).FindControl("txtcategory"), TextBox)
obj.Connect()
obj.cmd.CommandText = "update category_master set category_name='" & txtcatname.Text & "' where category_id=" & l1.Text
obj.cmd.ExecuteNonQuery()
gvcategory.EditIndex = -1
MsgBox("category updated!", MsgBoxStyle.Information, "Mohire`s")
obj.db.Close()
Catch ex As Exception
MsgBox(ex.Message)
End Try
fill_data()
End Sub
End Class