Using SQL Connectivity: Difference between revisions
m
mention free usage for up 5 users
(Executing embedded SQL to fill up a grid) |
m (mention free usage for up 5 users) |
||
| Line 1: | Line 1: | ||
[http://www.educ2008.com/Include/ElectosFileStreaming.asp?FileId=76 Eddy Kleinjans presentation at EDUC2008] | =Using the express versions of sql servers= | ||
You are allowed to the connectivity kit with up 5 users with no startup cost. | |||
checkout [http://www.educ2008.com/Include/ElectosFileStreaming.asp?FileId=76 Eddy Kleinjans presentation at EDUC2008] | |||
=Example code= | |||
Below is some sample code that fills up a 2-column grid with data which is retrieved from a SQL Server backend using a SQL Statement that is dynamically created. Note that it uses the existing connection from an already opened table called Customer. This way you don't have to make the connection with the SQL Server yourself and it is more maintenance friendly in case the tables get move over to a different server or database. | Below is some sample code that fills up a 2-column grid with data which is retrieved from a SQL Server backend using a SQL Statement that is dynamically created. Note that it uses the existing connection from an already opened table called Customer. This way you don't have to make the connection with the SQL Server yourself and it is more maintenance friendly in case the tables get move over to a different server or database. | ||