My first db application works with this code to run SQL commands:

Code: Code:
  1. Dim RS As New ADODB.Recordset
  2.     Dim DS As New DataSet
  3.     Dim OL As New OleDb.OleDbDataAdapter
  4. '........ Other codes...
  5.     Private Function GetInfo() As Boolean
  6.         On Error GoTo Err
  7.  
  8.         DS.Tables.Add(TableCostumers)
  9.         OL.Fill(DS.Tables(TableCostumers), RS)
  10.         DS.DataSetName = CN.ConnectionString
  11.         DGW.DataSource = DS.Tables(TableCostumers)
  12.  
  13.  
  14.         Return True
  15.         Exit Function
  16.  
  17. Err:
  18.         MsgBox("...", MsgBoxStyle.Critical, AppTitle)
  19.         Return False
  20.  
  21.     End Function

Now I want to change it to ADO.Net without big changes. Idea is that my applciation generates SQL commands and gets info like the code in this post. I don't want to make big changes. Actually I only want to eliminate recordset, because I dont want that anything stay from ADODB...
How can I do that?