1 <%@ Control Language="vb" %>
\r
2 <%@ Import Namespace="System.Data" %>
\r
3 <%@ Import Namespace="System.Data.OleDb" %>
\r
4 <%@ Import Namespace="System.Data.SqlClient" %>
\r
5 <%@ Import Namespace="System.Data.Odbc" %>
\r
6 <%@ Import Namespace="Rico" %>
\r
8 <script runat="server">
\r
10 Public dbConnection as object, accessRights as string
\r
11 Public LastErrorMsg as String
\r
12 Public defaultDB as String = "Northwind"
\r
13 Public dbDialect as dbDialects = dbDialects.Access
\r
16 Public Function OpenDB()
\r
18 select case dbDialect
\r
20 case dbDialects.Access: dbConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("../data/" & defaultDB & ".mdb") & ";User ID=;Password=;")
\r
23 'case dbDialects.Access: dbConnection = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & server.mappath("../data/" & defaultDB & ".mdb") & ";User ID=;Password=;")
\r
25 case dbDialects.TSQL: dbConnection = new SqlConnection("Data Source=MATTSPROBOOK\SQLEXPRESS;User ID=userid;Password=password;Initial Catalog=" & defaultDB & ";")
\r
26 case dbDialects.Oracle: dbConnection = new OleDbConnection("Provider=OraOLEDB.Oracle;Data Source=XE;User ID=" & defaultDB & ";Password=Password;")
\r
27 case dbDialects.MySQL: dbConnection = new OdbcConnection("DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=" & defaultDB & ";USER=userid;PASSWORD=password;")
\r
28 case dbDialects.DB2: dbConnection = new OleDbConnection("Provider=IBMDADB2;Data Source=NORTHWND;Protocol=local;CurrentSchema=SCHEMA;User ID=userid;Password=password;")
\r
32 Catch ex As Exception
\r
34 LastErrorMsg=ex.Message
\r
39 Public function OpenApp()
\r
41 if not OpenDB then exit function
\r
42 accessRights="rw" ' CHECK APPLICATION SECURITY HERE (in this example, "r" gives read-only access and "rw" gives read/write access)
\r
43 if IsNothing(accessRights) OrElse left(accessRights,1)<>"r" then
\r
44 LastErrorMsg="You do not have permission to access this application"
\r
51 Public function OpenGrid(oLiveGrid as object, optional menuevent as menuEvents = menuEvents.click)
\r
53 if not OpenApp() then
\r
54 response.write("ERROR: " & LastErrorMsg)
\r
58 SetGridOptions(oLiveGrid,menuevent)
\r
63 Public sub SetGridOptions(oLiveGrid as object, optional menuevent as menuEvents = menuEvents.click)
\r
64 oLiveGrid.dbConnection=Me.dbConnection
\r
65 oLiveGrid.dbDialect=Me.dbDialect
\r
67 '-------------------------------
\r
68 ' set application-wide defaults
\r
69 '-------------------------------
\r
70 oLiveGrid.menuEvent=menuevent
\r
75 Public function OpenGridForm(oLiveGrid as object)
\r
77 if not OpenGrid(oLiveGrid) then exit function
\r
79 '-------------------------------
\r
80 ' set security rights
\r
81 '-------------------------------
\r
82 dim CanModify as Boolean=CBool(accessRights="rw")
\r
83 oLiveGrid.canAdd=CanModify
\r
84 oLiveGrid.canEdit=CanModify
\r
85 oLiveGrid.canDelete=CanModify
\r
91 Public sub CloseApp()
\r
92 if IsNothing(dbConnection) then exit sub
\r
93 dbConnection.Close()
\r
94 dbConnection = Nothing
\r
98 Sub Page_Unload(Sender As object, e As EventArgs)
\r