Parameterized Command Example : SqlConnection « Database ADO.net « VB.Net

Home
VB.Net
1.2D
2.Application
3.Class
4.Data Structure
5.Data Types
6.Database ADO.net
7.Development
8.Event
9.File Directory
10.Generics
11.GUI
12.Language Basics
13.LINQ
14.Network Remote
15.Security
16.Thread
17.Windows Presentation Foundation
18.Windows System
19.XML
20.XML LINQ
VB.Net Tutorial
VB.Net by API
VB.Net » Database ADO.net » SqlConnectionScreenshots 
Parameterized Command Example
  
Imports System
Imports System.Data
Imports System.Data.SqlClient
    Public Class MainClass
        Public Shared Sub ParameterizedCommandExample(ByVal con As SqlConnection, ByVal employeeID As Integer, ByVal title As String)
            Using com As SqlCommand = con.CreateCommand
                com.CommandType = CommandType.Text
                com.CommandText = "UPDATE HumanResources.Employee SET Title = @title WHERE EmployeeID = @id;"

                Dim p1 As SqlParameter = com.CreateParameter
                p1.ParameterName = "@title"
                p1.SqlDbType = SqlDbType.VarChar
                p1.Value = title
                com.Parameters.Add(p1)

                com.Parameters.Add("@id", SqlDbType.Int).Value = employeeID
                Dim result As Integer = com.ExecuteNonQuery
                Console.WriteLine(result)

            End Using
        End Sub

        Public Shared Sub Main()
            Using con As New SqlConnection
                con.ConnectionString = "Data Source=.\sqlexpress;Database=AdventureWorks;Integrated Security=SSPI;"
                con.Open()
                ParameterizedCommandExample(con, 16"Production Technician")
                con.Close()
            End Using
        End Sub
    End Class

   
    
  
Related examples in the same category
1.Connection state change eventConnection state change event
2.Info Message EventInfo Message Event
3.Display the information about the connection.
4.Execute Non Query Example
5.Obtain a pooled connection
6.Parse the SQL Server connection string and display the component configuration parameters.
7.SQL Server Online Check
www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.