Wednesday, August 31, 2011

Deleting Selected row from gridview in asp.net, vb.net

1.add a buttonfield in grid view set command name as "Delete" then add this code

Imports System.Data
Imports System.Data.OleDb
Imports System.Web
Imports System.Web.UI.WebControls
Imports System.IO

Partial Class _Default
    Inherits System.Web.UI.Page
    Public con As OleDbConnection
    Public cmd As OleDbCommand
    Public da As OleDbDataAdapter
    Public dr As OleDbDataReader
    Public ds As DataSet
    Public cmb As OleDbCommandBuilder



Protected Sub GridView1_RowDeleting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewDeleteEventArgs) Handles GridView1.RowDeleting
        con = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("youraccessdatabase/db.mdb") & "")
        con.Open()
        da = New OleDbDataAdapter("select * from cust_details order by ID desc", con)
        ds = New DataSet()
        cmb = New OleDbCommandBuilder(da)
        da.Fill(ds)
        ds.Tables.Item(0).Rows.Item(e.RowIndex).Delete()
        da.Update(ds)
        GridView1.DataSource = ds
        GridView1.DataBind()
    End Sub

End Class

No comments:

Post a Comment