Execute the command and retrieve and XmlReader to access the results : Database Reader « 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 » Database ReaderScreenshots 
Execute the command and retrieve and XmlReader to access the results
  
Imports System
Imports System.Xml
Imports System.Data
Imports System.Data.SqlClient

    Public Class MainmClass
        Public Shared Sub ConnectedExample()
            Using con As New SqlConnection
                con.ConnectionString = "Data Source=.\sqlexpress;Database=AdventureWorks;Integrated Security=SSPI;"
                Using com As SqlCommand = con.CreateCommand
                    com.CommandType = CommandType.Text
                    com.CommandText = "SELECT DepartmentID, [Name], GroupName FROM HumanResources.Department FOR XML AUTO"
                    con.Open()
                    ' .
                    Using reader As XmlReader = com.ExecuteXmlReader
                        While reader.Read
                            If reader.NodeType = XmlNodeType.Element Then
                                Dim currentEle As XElement = XElement.ReadFrom(reader)
                                Console.WriteLine("Element:  {0}", currentEle.Name)
                                If currentEle.HasAttributes Then
                                    For i As Integer = To currentEle.Attributes.Count - 1
                                        Console.Write("  {0}: {1}", currentEle.Attributes()(i).Name, currentEle.Attributes()(i).Value)
                                    Next
                                End If
                            End If
                        End While

                    End Using
                    con.Close()
                End Using
            End Using
        End Sub
        Public Shared Sub Main()
            ConnectedExample()

        End Sub

    End Class

   
    
  
Related examples in the same category
1.Use SqlDataReader to read a single row of dataUse SqlDataReader to read a single row of data
2.Select top 5 Records in data tableSelect top 5 Records in data table
3.Execute Reader Example
4.Execute Scalar Example
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.