Execute Non Query Example : SqlConnection « Database ADO.net « VB.Net

1. VB.Net
2. Database ADO.net
3. SqlConnection

Execute Non Query Example

  

Imports System
Imports System.Data
Imports System.Data.SqlClient

    Public Class MainClass
        Public Shared Sub ExecuteNonQueryExample(ByVal con As IDbConnection)
            Dim com As IDbCommand = con.CreateCommand
            com.CommandType = CommandType.Text
            com.CommandText = "UPDATE HumanResources.Employee SET Title = 'Production Supervisor' WHERE EmployeeID = 24;"
            Dim result As Integer = com.ExecuteNonQuery
            Console.WriteLine(result)
        End Sub
        Public Shared Sub Main()
            Using con As New SqlConnection
                con.ConnectionString = "Data Source=.\sqlexpress;Database=AdventureWorks;Integrated Security=SSPI;"
                con.Open()

                ExecuteNonQueryExample(con)
                con.Close()
            End Using
        End Sub
    End Class

   
    
  

Related examples in the same category

1.	Connection state change event
2.	Info Message Event
3.	Display the information about the connection.
4.	Obtain a pooled connection
5.	Parameterized Command Example
6.	Parse the SQL Server connection string and display the component configuration parameters.
7.	SQL Server Online Check