SqlDataAdapter: 'select' command and the connection string : 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 
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 As Integer
            For i = 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
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.