Mike & Doris Manning
mikedorism at adelphia.net
Sun May 2 13:48:37 CDT 2004
VB.Net uses ADO in which you have a connection and command. You then use a dataset or datareader (forward only/read only) in place of a recordset. How you structure it via code all depends on whether you use OLE, ODBC, or SQLClient ADO providers. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of John W. Colby Sent: Sunday, May 02, 2004 10:53 AM To: VBA Subject: [dba-VB] VB.Net I need to know the syntax for just setting up access to data from code. In DAO you just dimmed a db and a recordset: dim db as dao.database dim rst as dao.database set db = currentdb set rst = db.openrecordset() etc. I know there are three parts to vb.net and can set them up with the wizard, but I want to be able to "just do it" from code as well. Anyone know how? John W. Colby www.ColbyConsulting.com _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com