Creating Primary data connection in VS.NET

[gnana]

How do i create primary data connection (which receive and submit data to
Access data base) in the new form that created in VS.NET 2003 (by creating
vs.net project of type infopath)?

Thanks!

 

[Franck Dauché]

Hi,

If you just need to manipulate data in your DB independently of your form,
then yes, you could just use Managed Code without creating a data connection
in InfoPath. You could connect to your Access DB through pure C# code as you
would do in a regular Winform.
Reading your previous post, I guess that it is what you are after...

Regards,

Franck Dauché

 

[gnana]

Thank you very much Franck.

If i use the manage code to retrieve/update the data, i should be keeping
track of changes that is happening to the form.

If i add infopath embeded data connection object, Infopath keep tracks of my
changes and submits the data for me.

Is there a way we can fire the dataadapters update method to update the data
source from the infopath form code.

Please let me know, any samples will help me a lot.

Thanks!

 

[Franck Dauché]

OK, I don't know exactly how you are going to set things up, but one of these
2 code snippets will do the trick:
1. http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=414
2. http://aspalliance.com/articleViewer.aspx?aId=498&pId=3

Bottom line is to call ".Query()"..

Hope that it helps.

Regards,

Franck Dauché

 

[Franck Dauché]

Just realized I didn't include a link to code for the Submit part:
http://www.perfectxml.com/InfoPath.asp

Good luck.

Franck Dauché