Setting Up a Connection
Click the List button at the connections group of the DataPoint menu.
Select the Microsoft SQL Server node in the tree and then click Add Connection.
Set the connection information; server, username, password, database. You will get this information from your database administrator.
We get a list of tables and views that are declared on the database. Alternatively, you can enter a custom SQL statement or enter a stored procedure call. Select the table you want to use on your slide.
You can change the refresh rate. This is a timer that checks for new or updated data at the sql server. Click OK to close.
You can rename the query and you will find a preview of the selected data. You can also add other connections as well, pointing to other tables and views. Click OK to close this connections form.
Draw some textboxes or tables on your slide(s).
Select the textbox and click DataPoint, Textbox. This opens the binding properties form of this textbox.
From the comboboxes, select the data connection, the column and row number of the database field that you want to display here in this textbox. Repeat this step for all other textboxes that you want to link dynamically to the sql server database.
Start the Slideshow
Start the slideshow and DataPoint will check every 5 seconds for new updates. Whenever a change of data is detected, DataPoint will immediately update the linked textbox on your slide. Now you can update the information in your database and leave the slideshow running.