GrapeCity -.NET with GrapeCity - InputMan Creation Date: Nov. 30, 2005 Last Update: Nov. 30, 2005 Version: 1.0
GrapeCity Microsoft Visual Studio.NET VB.NET Oracle Tips InputMan InputMan Oracle.NET Oracle Oracle Data Provider for.net( ODP.NET)!?.NET Oracle.NET GrapeCity 1. ActiveReports 2. InputMan 3. Spread 4. FlexGrid GrapeCity InputMan 1. InputMan 2. 3. InputMan ODP.NET!?.NET Oracle 3
GrapeCity OS Microsoft Windows 2000 Professional + SP4 RDBMS Oracle Database 10g Release 2 Standard Edition for Windows OS Microsoft Windows 2000 Professional + SP4 Microsoft Visual Studio.NET 2003!?.NET Oracle 4
InputMan InputMan XP Office InputMan for.net InputMan URL InputMan http://www.grapecity.com/japan/support/database/p7_307.htm InputMan 2006 1 InputMan for.net 3.0J http://otndnld.oracle.co.jp/easy/dotnet/inputman/sample.zip (sample.zip) InputManDemo Config InputManDemo VB.NET Windows Config Oracle sample.zip!?.net Oracle 5
Config gen_inputman.sql SQL*PLUS Oracle InputMan Oracle Config Images gif c: Temp gen_inputman.sql C: Temp Oracle Config gen_inputman.sql SQL*PLUS SQL / SYSTEM C: >sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 - Production on 2 14 09:12:05 2006 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL> @gen_inputman *---------------------------------------* * please enter password of system * *---------------------------------------* Enter password:!?.net Oracle 6
-< > - PL/SQL Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options Oracle sample.zip InputManDemo VS.NET InputManDemo.sln VS.NET InputManDemo.sln InputManDemo ODP.NET VS.NET ODP.NET!?.NET Oracle Data Provider for.net ODP.NET VS.NET ODP.NET Oracle InputManDemo Form1.vb emporacleconnection1!?.net Oracle 7
departmentoracleconnection1 ConnectionString User Id=inputman;Data Source=ORCL10GR2;Password=oracle; User Id inputman Config gen_inputman.sql inputman Data Source Oracle ASP.NET WEB VS.NET (D) (S)!?.NET Oracle 8
InputMan Windows InputMan ODP.NET InputMan ODP.NET Oracle DataSet InputMan Oracle DataSet DataSet InputMan DataSet Oracle DataSet 1. Oracle Oracle Oracle Oracle!?.NET Oracle 9
Oracle Developer Tools for Visual Studio.NET( ODT) ODT Oracle Oracle Oracle (A) Oracle < > inputman oracle!?.net Oracle 10
Network Configuration Assistant( netca) inputman oracle (T) OK Oracle 2. DataAdapter Oracle DataAdapter DataSet DataAdapter ODT Oracle!?.NET Oracle 11
(Y) DataAdapter DataAdapter Connection EMPLOYEE( ) DEPARTMENT( ) Oracle DataAdapter SelectCommand CommandText SQL SELECT * FROM EMPLOYEE!?.NET Oracle 12
SQL CommandText 3. DataSet DataAdapter DataSet DataAdapter DataSet DataSet!?.NET Oracle 13
ODT DataSet XML xsd ODT DataAdapter DataSet emporacledataadapter1.fill(emp11.emp) DataAdapter Fill DataSet DataSet ODT ODT DataSet InputMan DataSet InputMan DataSet InputMan InputMan DataBindings DataBindings!?.NET Oracle 14
DataSet DataBindings DataBindings ControlBindingsCollection Add DataSet edtname.databindings.add("text", Me.Employee11, "Employee.ENAME") DataBindings VS.NET Control.DataBindings BLOB BLOB InputMan BLOB InputMan!?.NET Oracle 15
employee BLOB ephoto InputMan ImageMember ephoto ListBoxStyle Text!?.NET Oracle 16
InputMan Oracle BLOB ListBoxStyle TextBoxStyle GrapeCity.Win.Input.ListBoxStyle ListBoxStyle.Text ListBoxStyle 0 - Image 1 - Text Text 2 - Both Both 3 - ImageWithDescription ImageWithDescription 4 - TextWithDescription TextWithDescription 5 - BothWithDescription BothWithDescription GrapeCity.Win.Input.TextBoxStyle GrapeCity.Win.Input.TextBoxStyle.TextOnly ListBoxStyle 0 - ImageOnly 1 - TextOnly 2 - Both InputMan!?.NET Oracle 17
Oracle dynamicsetproperties() employee InputMan InputMan Edit MaxLength Oracle InputMan Number Format GetSchemaTable ODP.NET OracleDataReader GetSchemaTable (AutoIncrement) GetSchemaTable ' ======== ' ' ======== Private Function getdynamicschema() As DataTable '' Dim acmd As OracleCommand Dim rdr As OracleDataReader acmd = emporacledataadapter1.selectcommand acmd.connection.open() rdr = acmd.executereader() getdynamicschema = rdr.getschematable!?.net Oracle 18
acmd.connection.close() End Function GetSchemaTable ' ======== ' ' ======== Private Sub dynamicsetproperties() Dim schematable As DataTable Dim datarowtmp As DataRow Dim NumericPrecision As Integer Dim NumericScale As Integer Dim str As String '' EMP schematable = getdynamicschema() '' ENAME datarowtmp = schematable.rows(1) Me.edtName.MaxLength = datarowtmp(2) '' JOB datarowtmp = schematable.rows(2) Me.edtJob.MaxLength = datarowtmp(2) '' SALARY datarowtmp = schematable.rows(5) NumericPrecision = datarowtmp(3) NumericScale = datarowtmp(4) If NumericScale = 0 Then!?.NET Oracle 19
str = Space(NumericPrecision) Else str = Space(NumericPrecision) + "." + Space(NumericScale) End If str = str.replace(" ", "#") Me.numSalary.Format.Digit = str End Sub schematable Rows employee Rows GetSchemaTable VS.NET GetSchemaTable Oracle InputMan SafeMapping InputMan Oracle!?.NET Oracle 20
DataSet OracleDataAdapter Oracle DataSet Oracle Oracle.NET DataSet Oracle 1 Oracle NUMBER 38.NET Decimal 28 2 Oracle DATE 4712 1 1 9999 12 31.NET Datetime 0001 1 1 9999 12 31 3 Oracle TIMESTAMP 4712 1 1 00:00:00.000000000.NET Datetime 0001 1 1 00:00:00. 0000000 9999 12 31 23:59:59.999999999 9999 12 31 23.59.59.9999999 4 Oracle INTERVAL -999999999 +999999999 DAY TO 23:59:59.999999999 23:59:59.999999999 SECOND.NET TimeSpan -10675199 02:48:05.4775808 +10675199 02:48:05.4775808 ODP.NET OracleDataAdapater SafeMapping Oracle DataSet.NET String Oracle.NET byte[] DATE SafeMapping -< > - cmd.commandtext = "SELECT empno, hiredate FROM employee" Dim da As New OracleDataAdapter(cmd) da.safemapping.add("hiredate", GetType(System.String)) Dim ds As New DataSet If ds.tables.contains("employee") Then ds.tables("employee").clear() da.fill(ds, "employee")!?.net Oracle 21
-< > - *.NET da.safemapping.add("*", GetType(System.String)) ODP.NET Oracle Data Provider for.net SafeMapping SELECT SELECT empno, hiredate as FROM emp da.safemapping.add(" ", GetType(System.String)) ODP.NET InputMan ODP.NET Oracle ODT InputMan!?.NET Oracle 22