how to delete a row in a gridview

shyam_oec's Avatar, Join Date: Nov 2007
Contributor
hi,
in a grid view i have enabled delete link,so that when a user clicks a delete link,corresponding row gets deleted from the database as well as from grid view.Data in the grid view is filled through coding,in the program using DataAdapter.
So, how to do that?
0
nimesh's Avatar, Join Date: Apr 2009
Invasive contributor
This is the code that I've used in my program for this purpose.

Code: vb
Protected Sub DeleteSQLCode(ByVal sender As Object, ByVal e As EventArgs)
        Try
            Dim lnkRemove As LinkButton = DirectCast(sender, LinkButton)
            strSql = "delete from myreports where ID = @id"
            con = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("./App_Data/Reports.mdb") & ";User Id=admin;Password=;")
            com = New OleDbCommand(strSql, con)
            com.CommandText = strSql
            com.CommandType = CommandType.Text
            com.Parameters.Add("@id", OleDbType.Integer).Value = lnkRemove.CommandArgument
            com.Connection.Open()
            com.ExecuteNonQuery()
            com.Connection.Close()
            disp_myrep()
        Catch
            msg = "<h1 class=""ErrMsg"">Error Encountered: </h1>" & "<br/><b><font color=""red"">Error Source: " & Err.Source & "<br/>Error Description: " & Err.Description & "</font></b>"
        End Try
        If con.State = ConnectionState.Open Then
            con.Close()
        End If
    End Sub
0
nimesh's Avatar, Join Date: Apr 2009
Invasive contributor
I referred this page for gridview operations. But still stuck on Edit Record.
http://www.aspsnippets.com/post/2009...-AJAX-way.aspx