[RESOLVED] Function that retrives a datatable from a sql statement VS2008 and MySql

[Niya]

You could use a DataAdapter. Here is an example using it to retrieve data from Sql Server:-

'
        Dim conn As SqlConnection = New SqlConnection(connectionString)
 
        Dim myDataAdapter As New SqlDataAdapter
        Dim cmd As New SqlCommand("Select * From MyTable", conn)
        Dim myDataTable As New DataTable
 
        'Set the select command on the DataAdapter
        myDataAdapter.SelectCommand = cmd
 
        'Fill the DataTable
        myDataAdapter.Fill(myDataTable)

Note that whatever state the connection was in when Fill was called will be restored after Fill is finished. So if the connection was closed before, it will be closed after.