I'm getting an error when I try to access the properties in oResult,
stating: "System.Directo ryServices.Sear chResultCollect ion.Properties is
not accessible in this context because it is 'private'". I don't
understand why, since I've passed it as a parameter to the sub. Thanks
in advance for any help.
Here's the entire (unfinished) sub:
Sub insertADRecords (ByVal strCurrOU As String, ByVal oResult As
SearchResultCol lection)
Dim iIndex1 As Integer
Dim strSql, strDN, strProxyAdd, strProxy(), strMyString As
String, rowsAffected As Integer
sqlConnection.O pen()
Dim sqlCMD As SqlClient.SqlCo mmand = New SqlCommand("INS ERT
INTO Tradoc.dbo.Curr AD (objclass, cn, mailnickname, targetAddress,
proxyAddresses, displayname," _
&
"givenName,init ials,sn,title,t elephoneNumber, company,departm ent,physicalDel iveryOfficeName ,l,st,postalcod e,"
_
& "co,ou,dn,adspa th) VALUES
(?,?,?,?,?,?,?, ?,?,?,?,?,?,?,? ,?,?,?,?,?,?))" )
For Each oResult In objRS
sqlCMD.Paramete rs.Add(New SqlParameter("@ objclass",
SqlDbType.Text, 50))
sqlCMD.Paramete rs.Add(New SqlParameter("@ cn",
SqlDbType.Text, 100))
sqlCMD.Paramete rs.Add(New SqlParameter("@ mailnickname",
SqlDbType.Text, 100))
sqlCMD.Paramete rs.Add(New SqlParameter("@ targetAddress",
SqlDbType.Text, 400))
sqlCMD.Paramete rs.Add(New SqlParameter("@ proxyAddresses" ,
SqlDbType.Text, 400))
sqlCMD.Paramete rs.Add(New SqlParameter("@ displayName",
SqlDbType.Text, 400))
sqlCMD.Paramete rs.Add(New SqlParameter("@ givenName",
SqlDbType.Text, 100))
sqlCMD.Paramete rs.Add(New SqlParameter("@ initials",
SqlDbType.Text, 50))
sqlCMD.Paramete rs.Add(New SqlParameter("@ sn",
SqlDbType.Text, 100))
sqlCMD.Paramete rs.Add(New SqlParameter("@ title",
SqlDbType.Text, 400))
sqlCMD.Paramete rs.Add(New SqlParameter("@ telephoneNumber ",
SqlDbType.Text, 400))
sqlCMD.Paramete rs.Add(New SqlParameter("@ company",
SqlDbType.Text, 400))
sqlCMD.Paramete rs.Add(New SqlParameter("@ department",
SqlDbType.Text, 400))
sqlCMD.Paramete rs.Add(New
SqlParameter("@ physicalDeliver yOfficeName", SqlDbType.Text, 400))
sqlCMD.Paramete rs.Add(New SqlParameter("@ l",
SqlDbType.Text, 50))
sqlCMD.Paramete rs.Add(New SqlParameter("@ st",
SqlDbType.Text, 50))
sqlCMD.Paramete rs.Add(New SqlParameter("@ postalcode",
SqlDbType.Text, 50))
sqlCMD.Paramete rs.Add(New SqlParameter("@ co",
SqlDbType.Text, 50))
sqlCMD.Paramete rs.Add(New SqlParameter("@ ou",
SqlDbType.Text, 400))
sqlCMD.Paramete rs.Add(New SqlParameter("@ dn",
SqlDbType.Text, 300))
sqlCMD.Paramete rs.Add(New SqlParameter("@ adspath",
SqlDbType.Text, 400))
'************** *************** *************** ***************
Try
'I get the errors below where it says "oResult.Proper ties("xxx")(0)"
sqlCMD.Paramete rs("@objclass") .Value =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("ob jClass")(0))))
sqlCMD.Paramete rs("@cn").Valu e =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("cn ")(0))))
sqlCMD.Paramete rs("@mailnickna me").Value =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("ma ilnickname")(0) )))
sqlCMD.Paramete rs("@targetAddr ess").Value =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("ta rgetAddress")(0 ))))
sqlCMD.Paramete rs("@proxyAddre sses").Value =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("pr oxyAddresses")( 0))))
sqlCMD.Paramete rs("@displayNam e").Value =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("di splayName")(0)) ))
sqlCMD.Paramete rs("@givenName" ).Value =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("gi venName")(0))))
sqlCMD.Paramete rs("@initials") .Value =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("in itials")(0))))
sqlCMD.Paramete rs("@sn").Valu e =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("sn ")(0))))
sqlCMD.Paramete rs("@title").Va lue =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("ti tle")(0))))
sqlCMD.Paramete rs("@telephoneN umber").Value =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("te lephoneNumber") (0))))
sqlCMD.Paramete rs("@company"). Value =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("co mpany")(0))))
sqlCMD.Paramete rs("@department ").Value =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("de partment")(0))) )
sqlCMD.Paramete rs("@physicalDe liveryOfficeNam e").Value
=
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("ph ysicalDeliveryO fficeName")(0)) ))
sqlCMD.Paramete rs("@l").Value =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("l" )(0))))
sqlCMD.Paramete rs("@st").Valu e =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("st ")(0))))
sqlCMD.Paramete rs("@postalcode ").Value =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("po stalcode")(0))) )
sqlCMD.Paramete rs("@co").Valu e =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("co ")(0))))
sqlCMD.Paramete rs("@ou").Valu e =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("ou ")(0))))
sqlCMD.Paramete rs("@dn").Valu e =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("dn s")(0))))
sqlCMD.Paramete rs("@adspath"). Value =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("ad spath")(0))))
If sqlConnection.S tate = ConnectionState .Closed Then
sqlConnection.O pen()
End If
rowsAffected = sqlCMD.ExecuteN onQuery()
Catch ex As Exception
Finally
sqlCMD.Dispose( )
End Try
Next
End Sub
stating: "System.Directo ryServices.Sear chResultCollect ion.Properties is
not accessible in this context because it is 'private'". I don't
understand why, since I've passed it as a parameter to the sub. Thanks
in advance for any help.
Here's the entire (unfinished) sub:
Sub insertADRecords (ByVal strCurrOU As String, ByVal oResult As
SearchResultCol lection)
Dim iIndex1 As Integer
Dim strSql, strDN, strProxyAdd, strProxy(), strMyString As
String, rowsAffected As Integer
sqlConnection.O pen()
Dim sqlCMD As SqlClient.SqlCo mmand = New SqlCommand("INS ERT
INTO Tradoc.dbo.Curr AD (objclass, cn, mailnickname, targetAddress,
proxyAddresses, displayname," _
&
"givenName,init ials,sn,title,t elephoneNumber, company,departm ent,physicalDel iveryOfficeName ,l,st,postalcod e,"
_
& "co,ou,dn,adspa th) VALUES
(?,?,?,?,?,?,?, ?,?,?,?,?,?,?,? ,?,?,?,?,?,?))" )
For Each oResult In objRS
sqlCMD.Paramete rs.Add(New SqlParameter("@ objclass",
SqlDbType.Text, 50))
sqlCMD.Paramete rs.Add(New SqlParameter("@ cn",
SqlDbType.Text, 100))
sqlCMD.Paramete rs.Add(New SqlParameter("@ mailnickname",
SqlDbType.Text, 100))
sqlCMD.Paramete rs.Add(New SqlParameter("@ targetAddress",
SqlDbType.Text, 400))
sqlCMD.Paramete rs.Add(New SqlParameter("@ proxyAddresses" ,
SqlDbType.Text, 400))
sqlCMD.Paramete rs.Add(New SqlParameter("@ displayName",
SqlDbType.Text, 400))
sqlCMD.Paramete rs.Add(New SqlParameter("@ givenName",
SqlDbType.Text, 100))
sqlCMD.Paramete rs.Add(New SqlParameter("@ initials",
SqlDbType.Text, 50))
sqlCMD.Paramete rs.Add(New SqlParameter("@ sn",
SqlDbType.Text, 100))
sqlCMD.Paramete rs.Add(New SqlParameter("@ title",
SqlDbType.Text, 400))
sqlCMD.Paramete rs.Add(New SqlParameter("@ telephoneNumber ",
SqlDbType.Text, 400))
sqlCMD.Paramete rs.Add(New SqlParameter("@ company",
SqlDbType.Text, 400))
sqlCMD.Paramete rs.Add(New SqlParameter("@ department",
SqlDbType.Text, 400))
sqlCMD.Paramete rs.Add(New
SqlParameter("@ physicalDeliver yOfficeName", SqlDbType.Text, 400))
sqlCMD.Paramete rs.Add(New SqlParameter("@ l",
SqlDbType.Text, 50))
sqlCMD.Paramete rs.Add(New SqlParameter("@ st",
SqlDbType.Text, 50))
sqlCMD.Paramete rs.Add(New SqlParameter("@ postalcode",
SqlDbType.Text, 50))
sqlCMD.Paramete rs.Add(New SqlParameter("@ co",
SqlDbType.Text, 50))
sqlCMD.Paramete rs.Add(New SqlParameter("@ ou",
SqlDbType.Text, 400))
sqlCMD.Paramete rs.Add(New SqlParameter("@ dn",
SqlDbType.Text, 300))
sqlCMD.Paramete rs.Add(New SqlParameter("@ adspath",
SqlDbType.Text, 400))
'************** *************** *************** ***************
Try
'I get the errors below where it says "oResult.Proper ties("xxx")(0)"
sqlCMD.Paramete rs("@objclass") .Value =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("ob jClass")(0))))
sqlCMD.Paramete rs("@cn").Valu e =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("cn ")(0))))
sqlCMD.Paramete rs("@mailnickna me").Value =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("ma ilnickname")(0) )))
sqlCMD.Paramete rs("@targetAddr ess").Value =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("ta rgetAddress")(0 ))))
sqlCMD.Paramete rs("@proxyAddre sses").Value =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("pr oxyAddresses")( 0))))
sqlCMD.Paramete rs("@displayNam e").Value =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("di splayName")(0)) ))
sqlCMD.Paramete rs("@givenName" ).Value =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("gi venName")(0))))
sqlCMD.Paramete rs("@initials") .Value =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("in itials")(0))))
sqlCMD.Paramete rs("@sn").Valu e =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("sn ")(0))))
sqlCMD.Paramete rs("@title").Va lue =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("ti tle")(0))))
sqlCMD.Paramete rs("@telephoneN umber").Value =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("te lephoneNumber") (0))))
sqlCMD.Paramete rs("@company"). Value =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("co mpany")(0))))
sqlCMD.Paramete rs("@department ").Value =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("de partment")(0))) )
sqlCMD.Paramete rs("@physicalDe liveryOfficeNam e").Value
=
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("ph ysicalDeliveryO fficeName")(0)) ))
sqlCMD.Paramete rs("@l").Value =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("l" )(0))))
sqlCMD.Paramete rs("@st").Valu e =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("st ")(0))))
sqlCMD.Paramete rs("@postalcode ").Value =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("po stalcode")(0))) )
sqlCMD.Paramete rs("@co").Valu e =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("co ")(0))))
sqlCMD.Paramete rs("@ou").Valu e =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("ou ")(0))))
sqlCMD.Paramete rs("@dn").Valu e =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("dn s")(0))))
sqlCMD.Paramete rs("@adspath"). Value =
strQuoteReplace (Trim(Convert.T oString(oResult .Properties("ad spath")(0))))
If sqlConnection.S tate = ConnectionState .Closed Then
sqlConnection.O pen()
End If
rowsAffected = sqlCMD.ExecuteN onQuery()
Catch ex As Exception
Finally
sqlCMD.Dispose( )
End Try
Next
End Sub