Stored Procedure Example : Sql Server Store Procedure « 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 » Sql Server Store ProcedureScreenshots 
Stored Procedure Example
  
Imports System
Imports System.Data
Imports System.Data.SqlClient
    Public Class MainClass
        Public Shared Sub StoredProcedureExample(ByVal con As SqlConnection, ByVal managerID As Integer)
            Using com As SqlCommand = con.CreateCommand
                com.CommandType = CommandType.StoredProcedure
                com.CommandText = "uspGetManagerEmployees"
                com.Parameters.Add("@ManagerID", SqlDbType.Int).Value = managerID
                Dim result As Integer = com.ExecuteNonQuery
                Using reader As SqlDataReader = com.ExecuteReader
                    Console.WriteLine("Employees managed by manager #{0}.", managerID.ToString)
                    While reader.Read
                        Console.WriteLine("  {0}, {1} ({2})", reader("LastName"), reader("FirstName"), reader("employeeID"))
                    End While
                End Using
            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()
                StoredProcedureExample(con, 185)
                con.Close()
            End Using
        End Sub
    End Class

   
    
  
Related examples in the same category
1.Fill dataset with the results from Store Procedure
2.Call store Procedure and pass parameters
3.Call Store Procedure in SQL Server
www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.