to delete a row in database in runtime - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

to delete a row in database in runtime

keerthi23keerthi23 Posts: 7Member
hi,
i doing a project in vb.net using sqlserver i want to delete a row in the data base during run time

Comments

  • DrMartenDrMarten Posts: 748Member
    : hi,
    : i doing a project in vb.net using sqlserver i want to delete a row in the data base during run time

    ----------------------------------------------------------------------
    Hi,

    See the following Microsoft example.>>

    Deleting Data in a SQL Database.
    See Also:-
    Accessing Data with ASP.NET | Accessing Data with ADO.NET | System.Web.UI.WebControls Namespace | DataGrid Class
    Language

    Visual Basic

    Show All
    The following code example presents a page with a column on the left side of the DataGrid that contains a link titled Delete Author in each row. Clicking on the link deletes that row of data from the database.

    To see a similar example executed, run the DataGrid10.aspx sample in the ASP.NET QuickStart.

    [Visual Basic]
    [code]
    <%@ Import Namespace="System.Data" %>
    <%@ Import Namespace="System.Data.SqlClient" %>


    Dim myConnection As SqlConnection
    Sub Page_Load(Src As Object, E As EventArgs)
    ' Create a connection to the "pubs" SQL database located on
    ' the local computer.
    myConnection = New SqlConnection ("server=localhost;" _
    & "database=pubs;Trusted_Connection=Yes")
    ' Determine whether the page is a postback. If it is not a
    ' postback, call BindGrid.
    if Not IsPostBack Then
    BindGrid()
    End If
    End Sub
    ' When the Delete Author link is clicked, set up a SQL DELETE
    ' statement, connect to the database, delete the indicated row, and
    ' rebind the DataGrid to display the updated database.
    Sub MyDataGrid_Delete(sender As Object, E As DataGridCommandEventArgs)
    Dim deleteCmd As String = "DELETE FROM Authors WHERE au_id = @Id;"
    Dim myCommand As SqlCommand = New SqlCommand(deleteCmd, _
    myConnection)
    myCommand.Parameters.Add(New SqlParameter("@Id", _
    SqlDbType.VarChar, 11))
    ' Initialize the SqlCommand "@Id" parameter to the ID of the row
    ' that was clicked.
    myCommand.Parameters("@Id").Value = _
    MyDataGrid.DataKeys(CInt(E.Item.ItemIndex))
    ' Connect to the database and delete the specified row.
    myCommand.Connection.Open()
    ' Test whether the delete was accomplished, and display the
    ' appropriate message to the user.
    Try
    myCommand.ExecuteNonQuery()
    Message.InnerHtml = "Record Deleted
    "
    Catch ex As SqlException
    Message.InnerHtml = "ERROR: Could not delete record"
    Message.Style("color") = "red"
    End Try

    ' Close the connection.
    myCommand.Connection.Close()
    ' Rebind the DataGrid to show the updated information.
    BindGrid()
    End Sub
    ' The BindGrid procedure connects to the database and implements
    ' a SQL SELECT query to get all the data in "Authors" table.
    public Sub BindGrid()
    Dim myCommand As SqlDataAdapter = New SqlDataAdapter("SELECT *" _
    & " FROM authors", myConnection)
    Dim ds As DataSet = New DataSet()
    myCommand.Fill(ds)
    MyDataGrid.DataSource=ds
    MyDataGrid.DataBind()
    End Sub
    [/code]

    Regards,
    Dr M.


Sign In or Register to comment.