Execute two queries together : SqlCommand Select « 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.Date Time
8.Development
9.Event
10.File Directory
11.Generics
12.GUI
13.Internationalization I18N
14.Language Basics
15.LINQ
16.Network Remote
17.Reflection
18.Security
19.Thread
20.Windows Presentation Foundation
21.Windows System
22.XML
23.XML LINQ
VB.Net » Database ADO.net » SqlCommand SelectScreenshots 
Execute two queries together
Execute two queries together

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


public class MainClass
   Shared Sub Main()
      Dim thisConnection As New SqlConnection("server=(local)\SQLEXPRESS;" & _
          "integrated security=sspi;database=MyDatabase")

      'Sql Query 1
      Dim sql1 As String ="SELECT FirstName FROM Employee;  "

      'Sql Query 2
      Dim sql2 As String ="SELECT LastName FROM Employee;"

      'Combine queries
      Dim sql As String = sql1 & sql2

      'Create Command object
      Dim thisCommand As New SqlCommand _
         (sql, thisConnection)

      Try
         ' Open Connection
         thisConnection.Open()
         Console.WriteLine("Connection Opened")

         ' Execute Query
         Dim thisReader As SqlDataReader = thisCommand.ExecuteReader()


      Catch ex As SqlException
         ' Display error
         Console.WriteLine("Error: " & ex.ToString())
      Finally
         ' Close Connection
         thisConnection.Close()
         Console.WriteLine("Connection Closed")

      End Try
   End Sub
End Class

           
       
Related examples in the same category
1.Read the result sets from two 'select' commandRead the result sets from two 'select' command
2.Use SqlDataReader to read result set from 'select' commandUse SqlDataReader to read result set from 'select' command
3.SqlDataAdapter: 'select' command and the connection string
4.Get data from 'Select' commandGet data from 'Select' command
5.Output data from 'Select' command in a table formatOutput data from 'Select' command in a table format
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.