使用vb.net连接到数据库并执行命令

源代码网整理以下Imports System
Imports System.Data  "引入数据类库
Imports System.Data.SqlClient  "引入SQL Server类库（用来访问SQL Server)

源代码网整理以下Module Module1
    Sub Main()
        AddRecord() "增加记录
 

源代码网整理以下
        RemoveRecord() "删除记录
        Pause()
    End Sub

源代码网整理以下    Sub Pause()
        Console.WriteLine("Press Enter To Continue...")
        Console.ReadLine()
    End Sub

源代码网整理以下    Sub AddRecord()
        "定义连接字符串
        Dim sConnectionString As String _
            = "User ID=sa;Initial Catalog=pubs;Data Source=(local)"
        "定义一个SQL连接对象 
        Dim objConn As New SqlConnection(sConnectionString)
        "连接对象
        objConn.Open()
        "定义一个插入记录命令字符
        Dim sSQL As String = "INSERT INTO Employee " & _
          "(emp_id, fname, minit, lname, job_id, job_lvl, pub_id, hire_date)" & _
          "VALUES ("MSD12923F", "Duncan", "W", "Mackenzie", " & _

源代码网整理以下        Dim objCmd As New SqlCommand(sSQL, objConn)
        Try
            objCmd.ExecuteNonQuery()  "执行插入动作
        Catch e As Exception
            Console.WriteLine(e.Message) "无法执行时提示出错信息
        End Try
        Console.WriteLine("Record Added")
    End Sub

源代码网整理以下    Sub RemoveRecord()
        Dim sConnectionString As String _
            = "User ID=sa;Initial Catalog=pubs;Data Source=(local)"
        Dim objConn As New SqlConnection(sConnectionString)
        objConn.Open()
        Dim sSQL As String = "DELETE FROM Employee WHERE emp_id = @emp_id"
        Dim objCmd As New SqlCommand(sSQL, objConn)

源代码网整理以下        objCmd.Parameters.Add("@emp_id", SqlDbType.Char, 9)
        objCmd.Parameters.Item("@emp_id").Value = "MSD12923F"

源代码网整理以下        Try
            objCmd.ExecuteNonQuery()
            Console.WriteLine("Record Deleted")
        Catch e As Exception
            Console.WriteLine(e.ToString)
        End Try
        Console.ReadLine()
    End Sub

源代码网整理以下End Module