Oracle Lite Tutorial

Size: px

Start display at page:

Download "Oracle Lite Tutorial"

ひさともなみこし
5 years ago
Views:

1 GrapeCity -.NET with GrapeCity - InputMan Creation Date: Nov. 30, 2005 Last Update: Nov. 30, 2005 Version: 1.0

2 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 InputMan ODP.NET!?.NET Oracle 3

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

4 InputMan InputMan XP Office InputMan for.net InputMan URL InputMan InputMan InputMan for.net 3.0J (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.

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 Production on :12: Copyright (c) 1982, 2005, Oracle. All rights reserved. * * * 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.

6 -< > - PL/SQL Oracle Database 10g Enterprise Edition Release 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

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

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

9 Oracle Developer Tools for Visual Studio.NET( ODT) ODT Oracle Oracle Oracle (A) Oracle < > inputman oracle!?.net Oracle 10

10 Network Configuration Assistant( netca) inputman oracle (T) OK Oracle 2. DataAdapter Oracle DataAdapter DataSet DataAdapter ODT Oracle!?.NET Oracle 11

11 (Y) DataAdapter DataAdapter Connection EMPLOYEE( ) DEPARTMENT( ) Oracle DataAdapter SelectCommand CommandText SQL SELECT * FROM EMPLOYEE!?.NET Oracle 12

12 SQL CommandText 3. DataSet DataAdapter DataSet DataAdapter DataSet DataSet!?.NET Oracle 13

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

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

15 employee BLOB ephoto InputMan ImageMember ephoto ListBoxStyle Text!?.NET Oracle 16

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

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

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

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

20 DataSet OracleDataAdapter Oracle DataSet Oracle Oracle.NET DataSet Oracle 1 Oracle NUMBER 38.NET Decimal 28 2 Oracle DATE NET Datetime Oracle TIMESTAMP :00: NET Datetime :00: :59: Oracle INTERVAL DAY TO 23:59: :59: SECOND.NET TimeSpan :48: :48: 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

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

Oracle Lite Tutorial

Oracle Lite Tutorial GrapeCity -.NET with GrapeCity - FlexGrid Creation Date: Nov. 30, 2005 Last Update: Nov. 30, 2005 Version: 1.0 Document Control Internal Use Only Author Hiroshi Ota Change Logs Date Author Version Change