Microsoft Office Tutorials and References
In Depth Information
Populating Microsoft Office InfoPath with Microsoft SQL Server 2008
Populating Microsoft Office InfoPath with
Microsoft SQL Server 2008
Now, let's take a look at how to connect Microsoft Office InfoPath 2007 to Microsoft
SQL Server 2008 and populate InfoPath fields with data from a Microsoft SQL Server
database. Connecting to a Microsoft SQL Server database is not a complex task in
InfoPath. Using the data connection wizard, you can achieve this in a very simple
way. In some scenarios, this process will not be sufficient to satisfy your business
requirements. If this is the case, then you may have to go for custom coding. Using
custom programming, you can connect to Microsoft SQL Server database, and
manage, manipulate, and validate data. Let's see how to connect to Microsoft
SQL Server 2008 and display data from a Microsoft SQL Server database in the
Start Microsoft Visual Studio 2008.
On the File menu, click on New Project .
In the New Project dialog box, expand Visual C# project types .
Select New project . Under Office select 2007 and select InfoPath 2007 Form
template and name the project as per your requirements.
Add the System.Data.dll reference to the solution.