Ok I am new to ADO.net 2.0 I've gotten a book and it has just too much information and is primarily for SQL Server. I am working with an access database. Here is how I am loading my form.

Private Sub frmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

'Get the current User on the machine
strUserID = Mid(GetTheUserName(), 2)

'Create the connection string to open the database
m_cnADONetConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source = F:\VBAStuff\VB 2005\Database Example\NewPride.mdb"

'Open the the database and establish a connection to it.
m_cnADONetConnection.Open()

'Initialize the DataAdapter
m_daDataAdapter = New OleDb.OleDbDataAdapter("Select ID, FirstName From Employee_Roster where [Reports To ID#] = '" & strUserID & "'", m_cnADONetConnection)

'Initialize the Commandbuilder object
m_cbCommandBuilder = New OleDb.OleDbCommandBuilder(m_daDataAdapter)

'Fill the DataTable with the data from the table
m_daDataAdapter.Fill(m_dtEmployee_Roster)

Me.ShowCurrentRecord()

End Sub

Basicly what I am wanting to do is change the select statement and then requery the database and refill the dataAdapter but do not know how to do this.

thanks for all you assistance.

Mythos