SqlDataAdapter: 'select' command and the connection string : SqlCommand Select « Database ADO.net « VB.Net





SqlDataAdapter: 'select' command and the connection string

Imports System
Imports System.Xml
Imports System.Xml.Schema
Imports System.IO
Imports System.Data.SqlClient
Imports System.Collections
Imports System.Data


Public Class MainClass
    
    Shared Sub Main()
        Dim da As New SqlDataAdapter( _
                   "SELECT ID, FirstName, LastName FROM Employee", _
                   "Server=(local)\SQLEXPRESS;Initial Catalog=MyDatabase;Integrated Security=SSPI")

        Dim ds As New DataSet("Employee")
        da.FillSchema(ds, SchemaType.Source)
        ds.ReadXml("Employee.xml")

        Dim Table As DataTable = ds.Tables(0)
        Dim numCols As Integer = Table.Columns.Count

        Dim Row As DataRow
        For Each Row In Table.Rows
            Dim i As Integer
            For i = 0 To numCols - 1
                Console.WriteLine(Table.Columns(i).ColumnName & " = " & Row(i))
            Next
            Console.WriteLine()
        Next
    End Sub
End Class



           
       










Related examples in the same category

1.Execute two queries togetherExecute two queries together
2.Read the result sets from two 'select' commandRead the result sets from two 'select' command
3.Use SqlDataReader to read result set from 'select' commandUse SqlDataReader to read result set from 'select' command
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