[VB .NET]OleDB

[Mangix]

im trying to access a database and do a few stuff with it. well i already have connected to the database but i dont know how to do anything with it. im looking for something that can make a recordset of that. anyone know how i can do this?

[MyndFyre]

You don't make a RecordSet, that's a COM object.  You'll want to make a DataSet.  I'd go with something like:

Code Select Expand


OleDbDataAdapter da = new OleDbDataAdapter(myConnection, new OleDbCommand("SELECT * FROM Users;"));
DataSet ds = new DataSet();
da.Fill(ds);

That's the best of my memory.  A DataSet can represent more than one table.

[Mangix]

thanks