Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
431 views
in Technique[技术] by (71.8m points)

vb.net - ADODB BC30526 Property 'Item' is 'ReadOnly'

Why i am getting this error? Property 'Item' is 'ReadOnly' ive created this in my class, Please help me to configured this error. i found in the Internet about this Property 'Item' is 'ReadOnly' but i think were not the same question Property 'Item' is 'ReadOnly'

class

Public Function GetRecordDataSet(ByVal sStoreProcName As String, ByVal sParameterList As String) As ADODB.Recordset
        Dim cmd As New ADODB.Command
        Dim arrParameter, arrParamName
        Dim sParamName As String
        Dim sDataValue
        Dim lCtr As Long
        On Error GoTo errhandler

        GetRecordDataSet = New ADODB.Recordset
        cmd.ActiveConnection = con
        cmd.CommandTimeout = 1800
        cmd.CommandType = ADODB.CommandTypeEnum.adCmdStoredProc
        cmd.CommandText = sStoreProcName
        If Not Trim(sParameterList) = "" Then
            arrParameter = Split(sParameterList, "|", , vbTextCompare)
            If UBound(arrParameter) >= 0 And IsArray(arrParameter) Then
                For lCtr = 0 To UBound(arrParameter)
                    arrParamName = Split(arrParameter(lCtr), "$", , vbTextCompare)
                    sParamName = arrParamName(0)
                    sDataValue = arrParamName(1)
                    cmd.Parameters.Item(sParamName) = sDataValue
                Next lCtr
            End If
        End If
        GetRecordDataSet = cmd.Execute
        cmd = Nothing
        Exit Function
errhandler:
        MessageBox.Show("Records Not Found!!!")
    End Function

form

Public Function Listdata()
        Dim username = txtbox_username.Text //value Client1
        Dim objDataInquiry As New clsDataQuery
        Dim objFunction As New clsFunction
        Dim rs As ADODB.Recordset
        Dim lCtr As Long
        'Dim xItem As ListItem
        Dim sParametList As String
        On Error GoTo errhndler
        lCtr = 0
        sParameterList = "@strUserName$" & username
        rs = objDataInquiry.GetRecordDataSet("GetRecordDataSet", sParameterList)
        Exit Function
errhndler:
        MessageBox.Show("Error found. Please try again. If error persists please contact the administrator.")
    End Function
question from:https://stackoverflow.com/questions/66057864/adodb-bc30526-property-item-is-readonly

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)
Waitting for answers

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...