[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 225
  • Last Modified:

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

0
mfarid2
Asked:
mfarid2
1 Solution
 
JonFish85Commented:
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!
0
 
Anthony PerkinsCommented:
Here check this out:
http://www.xoc.net/standards/rvbanc.asp#ADO

Anthony
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now