to delete a row in database in runtime

i doing a project in using sqlserver i want to delete a row in the data base during run time


  • : hi,
    : i doing a project in using sqlserver i want to delete a row in the data base during run time


    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

    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]
    <%@ 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
    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, _
    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 = _
    ' Connect to the database and delete the specified row.
    ' Test whether the delete was accomplished, and display the
    ' appropriate message to the user.
    Message.InnerHtml = "Record Deleted
    Catch ex As SqlException
    Message.InnerHtml = "ERROR: Could not delete record"
    Message.Style("color") = "red"
    End Try

    ' Close the connection.
    ' Rebind the DataGrid to show the updated information.
    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()
    End Sub

    Dr M.

Sign In or Register to comment.

Howdy, Stranger!

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


In this Discussion