Author | Message | Time |
---|---|---|
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 |