Re: can't display data from .mdb when startup the form

Greg Collins — Thu, 03 Aug 2006 16:20:04 GMT

Do not put such code in the Startup method... place it in an OnLoad event handler.

can't display data from .mdb when startup the form

Whitley — Thu, 03 Aug 2006 02:24:06 GMT

i am using vb.net to retrieve data from .mdb and display it into drop down list when startup the form. but now i have a problem to display the data.
hope someone to advice.

My Coding is shown as below.
Dim strConnection As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\eLeave.mdb"
Dim cn As OleDbConnection = New OleDbConnection(strConnection)
Dim strGetData As String
Dim str As Object

strGetData = "SELECT Name " & _
" FROM tblStaffŠ & _
" WHERE Designation = 'Manager'"

Dim strCommandRead As New OleDbCommand(strGetData, cn)

cn.Open()

str = strCommandRead.ExecuteReader()

thisXDocument.DOM.selectSingleNode("//myFields:field1").text = str

cn.Close()

Error message
The _Startup or _shutdown method in this form's code contains one or more calls to members of the microsoft.office.interop.infopath.semitrust namespace. calls to this namespace from these methods are not allowed.

Newbie Questions

Re: can't display data from .mdb when startup the form

can't display data from .mdb when startup the form