John W. Colby
jwcolby at colbyconsulting.com
Sun May 2 16:27:19 CDT 2004
yea, yea, yea. But you still need dim statements, you still need to set one to refer to the next to the next. Do you ever do this? John W. Colby www.ColbyConsulting.com -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com]On Behalf Of Mike & Doris Manning Sent: Sunday, May 02, 2004 2:49 PM To: dba-vb at databaseadvisors.com Subject: RE: [dba-VB] VB.Net 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 _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com