SearchresultCollection not accessible because it's private?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Bmack500

    #1

    SearchresultCollection not accessible because it's private?

    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

Working...