InfoPath Dev

hi,

To who may concern, can someone send some sample code/form for "how to submit data into .mdb / access database" to me? Because i am new in this...

thanks.

Hello Whitley,

Welcome to Infopathdev Forums

Please read the link below to understand how to Connect/Submit data into Access database
http://office.microsoft.com/en-au/assistance/ha011199501033.aspx

I hope it will help you.

hi drgkreddy,

sorry, i tried it before but unsuccessful.
Now i am looking for how to write code(for example vb.net) to connect to .mdb
thanks.

hi drgkreddy,

may i know whether you have any sample code / form to me?
thanks in advance.
:)

Hi,

Check out these links,

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ipsdk/html/ipsdkConnectingToDBInADOForm_HV01031080.asp

http://blogs.3sharp.com/Blog/davidg/archive/2005/05/05/637.aspx

I hope this will help you,

Thanks.

hi,

http://blogs.3sharp.com/Blog/davidg/archive/2005/05/05/637.aspx

for this link - third paragraph as shown below
The first step is to create data connections for your table(s). Also, note that the form will need to be fully trusted in order to write to the database. Next, add a reference to the System.Data.dll .NET component and include the using System.Data.OleDb directive in your form code file. After the reference and directive have been added, you can declare member variables for the database connection and each of the update commands that your code requires.

i not really understand for it.
because i can using the method which provided by infopath features.
but now i cannot save the info into .mdb through vb.net code since i already add a reference to the System.Data.dll .NET component into the form.
beside this, i have set the form to "FULL TRUST" in form option already.


hope someone kindly advice or send other example coding to me.
thanks.
:)