Hello,
I use OleDbCommand object to make Insert, Update and Delete statements in SQL Server database but I don't destroy that <b>OleDbCommand object</b> and I wish to know what is the most optimal procedure to destroy it?

I have 3 choices:

<big>- DISPOSE in Finally section...</big>

<small>Imports System.Data.OleDb
Public Class Form1
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim connetionString As String
        Dim cnn As OleDbConnection
        Dim cmd As OleDbCommand
        Dim sql As String
        connetionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Your mdb filename;"
        sql = "Your SQL Statement Here"
        cnn = New OleDbConnection(connetionString)
        Try
            cnn.Open()
            cmd = New OleDbCommand(sql, cnn)
            cmd.ExecuteNonQuery()
            MsgBox(" ExecuteNonQuery in OleDbConnection executed !!")
        Catch ex As Exception
            MsgBox("Can not open connection ! ")
        End Try
    End Sub
End Class
Se debe hacer esto (ver texto en la sección Finally)…
Imports System.Data.OleDb
Public Class Form1
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim connetionString As String
        Dim cnn As OleDbConnection
        Dim cmd As OleDbCommand
        Dim sql As String
        connetionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Your mdb filename;"
        sql = "Your SQL Statement Here"
        cnn = New OleDbConnection(connetionString)
        Try
            cnn.Open()
            cmd = New OleDbCommand(sql, cnn)
            cmd.ExecuteNonQuery()
            MsgBox(" ExecuteNonQuery in OleDbConnection executed !!")
        Catch ex As Exception
            MsgBox("Can not open connection ! ")
Finally
            <b>cmd.Dispose()
            cnn.Close()
            cmd = nothing</b>
        End Try
    End Sub
End Class</small>
  • USING statement

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Try
    Dim connetionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Your mdb filename;"

    <b>Using</b> cnn As New OleDbConnection(connetionString)
        cnn.Open()

        Dim sql As String = "Your SQL Statement Here"
        Dim cmd As New OleDbCommand(sql, cnn)
        cmd.ExecuteNonQuery()

        MsgBox(" ExecuteNonQuery in OleDbConnection executed !!")
    <b>End Using</b>

Catch ex As Exception
    MsgBox("Can not open connection ! " + ex.Message)
End Try

End Sub

Thanks

Note: I use vs 2005 and VB.Net

This article has been dead for over six months. Start a new discussion instead.