![how to get outlook contact groups from sql server how to get outlook contact groups from sql server](https://www.nucleustechnologies.com/blog/wp-content/uploads/2019/03/Recovering-Contacts-in-Office-365-2.png)
- #How to get outlook contact groups from sql server code
- #How to get outlook contact groups from sql server windows
The database can use either Microsoft Windows authentication or SQL Server authentication to determine how users can access the database. The authentication required by the database.
![how to get outlook contact groups from sql server how to get outlook contact groups from sql server](https://www.emailarchitect.net/img/easendmail/easendmail_csharp_sample2.jpg)
The name of the database that you will use with this form template. The name of the server with the database that you will use with this form template.
#How to get outlook contact groups from sql server code
Using custom code requires a developer to create the custom code.īefore you add a secondary data connection to a SQL Server database to your form template, you need the following information from your database administrator:
![how to get outlook contact groups from sql server how to get outlook contact groups from sql server](https://www.lifewire.com/thmb/4EJNFg7MWhrvGuvgpBPzcXYO_0E=/1051x1051/smart/filters:no_upscale()/01-how-to-see-full-email-headers-in-outlookcom-6639b15a15234f309b889d00cfda81ff.jpg)
Use custom code If you cannot add a rule or button, you can use custom code to get data by using the query data connection. You can also configure your form template to use the query data connection in one of the following ways:Īdd a rule You can configure a rule to use the query data connection whenever the condition in the rule occurs.Īdd a button You can add a button to the form template that users can click to get data by using the query data connection. When you add a query data connection to a form template, by default the forms that are based on this form template use the data connection when they are opened by a user. If you disable this feature, the data will be available only if the user is connected to the network. Security Note: If you are using a secondary data connection to retrieve sensitive data from an external data source, you may want to disable this feature to help protect the data from unauthorized use in case the computer is lost or stolen. Depending on the nature of the data, you may want to display the query results only when users are connected to a network. You can configure each query data connection to save the results so that users have access to the data when their form is not connected to a network. Because the data structure in the secondary data source must match the way that data is stored in the database tables, you cannot modify the fields or groups in the secondary data source. When you add a query data connection to a database, InfoPath creates a secondary data source with data fields and groups that corresponds to the way that the data is stored in the database. You cannot add a submit data connection to a SQL Server database as a secondary data connection. You add this data connection only if you need data from an external data source other than the one in the main data connection. You can add a query data connection to your form template only as a secondary data connection to a SQL Server database. This data connection can be a query data connection or a submit data connection. To get values from another external data source, you can add a secondary data connection to your form template.Ī secondary data connection is a data connection that you add to a form template. These values may exist in another external data source, such as another SQL Server database. However, the external data source used in the main data connection may not have the values that you want to put in the controls on the form template. InfoPath then creates the main data source for the form template based on the way that data is stored in the external data source. When you create a form template that is based on an external data source, Microsoft Office InfoPath creates a main data connection to that external data source. Step 2: Configure the form template to use the data connection Step 2: Configure the form template to use the data connection If you want your users to use this data connection after the form opens, you can add a rule or a button to the form template to allow users to get data from this data connection. You can also configure the form template to allow forms to use this data connection when the form first opens. Step 1: Add a secondary data connection to the form template This step creates the secondary data source with the appropriate fields and groups based on the way that data is stored in the database.
![how to get outlook contact groups from sql server how to get outlook contact groups from sql server](https://tipsmail.info/wp-content/uploads/2019/01/set-up-email-in-outlook-mobile.jpg)
In order to add a secondary data connection to a database, you must do the following: Find links to more information about adding a secondary data connection to a Web service in the See Also section. If you want to use a secondary data connection to submit form data to a database, use a secondary data connection to a Web service that works with that database. You cannot add a secondary data connection to your form template that submits form data to a database. You can add a secondary data connection to your form template that queries a Microsoft SQL Server database.