Link to home
Start Free TrialLog in
Avatar of mfarid2
mfarid2

asked on

Where I can find ADO Coding conventions?

Can anybody tell me how I can get hold of a coding convention document for ADO objects in the Microsoft site or MSDN Help or Visual Basic help? When a search is done in MSDN Help with the text "Visual Basic Coding Conventsions", I come up with coding coventions for DAO objects under Object Naming Conventions but not ADO.

I need somethig official that people can relate to, not your own coding conventions.

Thanks

Avatar of JonFish85
JonFish85

Well, microsoft recommends Hungarian notation for variable names. Basically that is approx. 3 letter prefix to a variable name, ie:

Dim strInfo As String
Dim intCount As String
Dim varMyObject As Variable
Dim objCreate As Object

Based on that, for ADO, I use:

Dim acnConnection As ADODB.Connection
Dim arsRecordset As ADODB.Recordset

(acn = Ado ConnectioN)
(ars = Ado RecordSet)

hope this helps!
ASKER CERTIFIED SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial