Infopath and SQL

[Papanii]

Hi i am a newbie who is trying to understand how Infopath works when
connecting to an sql database. Assuming that i have a sql database, and this
database was developed based on a XSD. When i create an infopath form to
input and recieve data from tthe database, do i use the database fields or
do i use the schema fileds to create the form fields? Secondly, after the
form is populated can i send the data to the database using sql/xml? Is that
considered secure? Should i use ADO.Net for the connection b/n the infopath
form and the database?
Thanx..

Newbie

 

[Roger Jennings]

InfoPath's Data Connection Wizard makes it easy to connect to SQL Server or
Access (Jet) databases. The Wizard works with individual tables and handles
related (child) tables by automatically creating a repeating table. The
Wizard automatically generates the InfoPath schema, so the schema from which
you design the database isn't relevant.

InfoPath generates default forms for data retrieval and table updates. All
operations use ADO under the covers, so you don't need to write code for
basic data entry operations. Thus, SQLXML operations aren't applicable and
you don't need to add ADO.NET managed code unless you're working with
databases other than SQL Server/MSDE or Access.

--rj

 

[Papanii Okai]

Thanks a lot RJ

--Newbie

InfoPath's Data Connection Wizard makes it easy to connect to SQL Server
or
Access (Jet) databases. The Wizard works with individual tables and
handles
related (child) tables by automatically creating a repeating table. The
Wizard automatically generates the InfoPath schema, so the schema from
which
you design the database isn't relevant.

InfoPath generates default forms for data retrieval and table updates. All
operations use ADO under the covers, so you don't need to write code for
basic data entry operations. Thus, SQLXML operations aren't applicable and
you don't need to add ADO.NET managed code unless you're working with
databases other than SQL Server/MSDE or Access.

--rj