VB .Net: A function to return a DataTable from a database connection.

GetDataTable.vb

''' <summary>
    ''' Returns a DataTable from a database query defined by a ConnectionString.
    ''' </summary>
    ''' <param name="ConnectionString">ConnectionString to a database</param>
    ''' <param name="Sql">An SQL query</param>
    ''' <returns>DataTable</returns>
    Private Function GetDataTable(ConnectionString As String, Sql As String) As DataTable
        'the DataTable to return
        Dim MyDataTable As New DataTable

        'make a SqlConnection using the supplied ConnectionString 
        Dim MySqlConnection As New SqlConnection(ConnectionString)
        Using MySqlConnection
            'make a query using the supplied Sql
            Dim MySqlCommand As SqlCommand = New SqlCommand(Sql, MySqlConnection)

            'open the connection
            MySqlConnection.Open()

            'create a DataReader and execute the SqlCommand
            Dim MyDataReader As SqlDataReader = MySqlCommand.ExecuteReader()

            'load the reader into the datatable
            MyDataTable.Load(MyDataReader)

            'clean up
            MyDataReader.Close()
        End Using

        'return the datatable
        Return MyDataTable
    End Function

Excellent....