Valhalla Legends Forums Archive | .NET Platform | [VB .NET]OleDB

AuthorMessageTime
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?
September 10, 2005, 3:04 AM
Myndfyr
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]
OleDbDataAdapter da = new OleDbDataAdapter(myConnection, new OleDbCommand("SELECT * FROM Users;"));
DataSet ds = new DataSet();
da.Fill(ds);
[/code]
That's the best of my memory.  A DataSet can represent more than one table.
September 10, 2005, 8:20 AM
Mangix
thanks :)
September 10, 2005, 7:39 PM

Search