Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

dumb Question..What does a recruiter mean by ADO experiance?

Status
Not open for further replies.

WhiteZiggy

Programmer
Jan 22, 2003
85
US
Ok,

I might be dumb, but what as far as recruiters does ADO mean?

If you use VB 6.0; dont most use ADO? Is ADO where the SQL is built in? Are you doing ADO by using the MSGRIDS?( is that the definition?) Is it a special packaging within VB?
I specialize in user interface and reporting and am just confused by the "name" game. :)

I have made many VB 6.0 and I believe they are all ADO. But maybe I dont know the dif because it is the only way I have worked.

Any reponses are appreciated...


Thanks...

WZ
 
Heres is a good example...

If this is your code...

"Public Function ProcDataMIN(ByRef xlwb As Workbook, ByRef xlws As Worksheet, _
ByRef currentrow As Long, filename As String, fpath As String, _
SearchValue1, override, xCount) As Long
Dim adoXL As ADODB.Connection
Dim adoRS As ADODB.Recordset
Dim filepath As String
Dim sqlstr As String
Dim rngstr As String
rngstr = "A" & currentrow
filepath = fpath & "\"
sqlstr = "Select * from [Sheet1$] Where [F1] > 40000 AND [F7] = " & SearchValue1
Set adoXL = New ADODB.Connection

With adoXL
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = "Data Source=" & filepath & filename & ";" & _
"Extended Properties=""Excel 8.0; HDR=No;"""
.Open
End With

Set adoRS = New ADODB.Recordset
adoRS.Open sqlstr, adoXL
xlws.Range(rngstr).CopyFromRecordset adoRS
xlws.Range("E" & currentrow & ":E" & currentrow + xCount - 1).Value = "M"
xlws.Range("F" & currentrow & ":F" & currentrow + xCount - 1).Value = override
currentrow = currentrow + xCount - 1
adoRS.Close

Set adoRS = Nothing
Set adoXL = Nothing
ProcDataMIN = currentrow
End Function
""

Is that all it takes to be ADO? if so...
Then what other options are there?

Thanks...
 
If you can create ADO objects and use them, you know ADO. From there it's just levels of proficiency.

All lessons learned from the School of Hard Knocks........at least tuition is cheap.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top