Grapecity -.NET with GrapeCity - ActiveReports Creation Date: Nov. 30, 2005 Last Update: Nov. 30, 2005 Version: 1.0
Grapecity Microsoft Visual Studio.NET VB.NET Oracle Tips ActiveReports ActiveReports.NET Oracle Oracle Data Provider for.net( ODP.NET)!?.NET Oracle.NET Grapecity 1. ActiveReports 2. InputMan 3. Spread 4. FlexGrid Grapecity ActiveReports 1. ActiveReports 2. 3. ActiveReports ODP.NET 4. HTMLDB!?.NET Oracle Grapecity (ActiveReports) 2
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 Oracle HTML DB 1.6!?.NET Oracle Grapecity (ActiveReports) 3
ActiveReports ActiveReports ActiveReports ActiveReports Professional Edition PDF Web Web HTTP Web Visual Studio.NET VS.NET UI ActiveReports URL ActiveReports http://www.grapecity.com/japan/support/database/p7_330.htm ActiveReports 2006 1 ActiveReports for.net 2.0J http://otndnld.oracle.co.jp/easy/dotnet/active_reports/sample.zip!?.net Oracle Grapecity (ActiveReports) 4
(sample.zip) ActiveReportDemo ActiveReportDemo_ASPNET ActiveReportDemo_WebService ActiveReportDemo VB.NET ActiveReportDemo_ASPNET ASP.NET ActiveReportDemo_WebService VB.NET XML WEB Internet Information Services(IIS) ( ) sample.zip ActiveReportDemo_ASPNET ActiveReportDemo_WebService Internet Information Services(IIS) sample.zip C: ActiveReport 1. IIS!?.NET Oracle Grapecity (ActiveReports) 5
2. Windows IIS ActiveReportDemo_ASPNET [ ] WEB!?.NET Oracle Grapecity (ActiveReports) 6
OK ActiveReportDemo ActiveReportDemo_WebService IIS ActiveReports ActiveReports ActiveReports Web ms-help://ms.vscc.2003/dd.activereports.1041/ddarug/html/artskmanualconfigur ationofwebsamples.html!?.net Oracle Grapecity (ActiveReports) 7
IIS sample.zip ActiveReportDemo VS.NET ActiveReportDemo.sln VS.NET ActiveReportDemo.sln ActiveReportDemo ActiveReportDemo_ASPNET ASP.NET WEB ActiveReportDemo_WebService ASP.NET WEB WEB Oracle WEB Oracle ASP.NET WEB Windows!?.NET Oracle Grapecity (ActiveReports) 8
Oracle WEB ActiveReportDemo_WebService ActiveRepotDemo.asmx demoproductinfooracleconnection1 ConnectionString User Id=sample;Data Source=orcl10gr2;Password=sample User Id Sample HTMLDB sample Data Source Oracle ASP.NET WEB VS.NET ActiveReportDemo_ASPNET A!?.NET Oracle Grapecity (ActiveReports) 9
VS.NET (D) (S) Active Report WEB VS.NET ActiveReprotDemo_WinForm A!?.NET Oracle Grapecity (ActiveReports) 10
VS.NET (D) (S)!?.NET Oracle Grapecity (ActiveReports) 11
Active Report Windows VS.NET Oracle HTML DB( HTMLDB) HTMLDB HTMLDB HTMLDB Oracle Technology Network( OTN) URL OTN - Oracle HTML DB http://otn.oracle.co.jp/software/products/htmldb/index.html Oracle HTML DB OTN Oracle Database 10g Oracle Database 10g Companion CD Oracle HTML DB ActiveReports HTMLDB HTMLDB 1. HTMLDB HTMLDB internal admin!?.net Oracle Grapecity (ActiveReports) 12
2. HTML DB 3. sample!?.net Oracle Grapecity (ActiveReports) 13
4. sample : 2MB 5. HTML DB HTML DB (ADMIN) 6.!?.NET Oracle Grapecity (ActiveReports) 14
HTMLDB HTMLDB ADMIN!?.NET Oracle Grapecity (ActiveReports) 15
HTML DB Sample Application v1.6 demo, sample sample( )!?.NET Oracle Grapecity (ActiveReports) 16
Products ActiveReports!?.NET Oracle Grapecity (ActiveReports) 17
ActiveReports ODP.NET ActiveReports ODP.NET Oracle DataSet ActiveReports WEB Oracle DataSet WEB WindowsForm, ASP.NET DataSet ActiveReports DataSet Oracle DataSet 1. Oracle Oracle Oracle Oracle Oracle Developer Tools for Visual Studio.NET( ODT) ODT Oracle Oracle Oracle (A)!?.NET Oracle Grapecity (ActiveReports) 18
Oracle < > sample sample Network Configuration Assistant( netca) HTMLDB sample (T) OK Oracle!?.NET Oracle Grapecity (ActiveReports) 19
2. DataAdapter Oracle DataAdapter DataSet DataAdapter ODT Oracle (Y) DataAdapter DataAdapter Connection!?.NET Oracle Grapecity (ActiveReports) 20
HTMLDB DEMO_PRODUCT_INFO( ) DEMO_IMAGES( ) ActiveReports DataAdapter SelectCommand CommandText SELECT a.*,b.image FROM demo_product_info a, demo_images b WHERE a.image_id = b.image_id(+) Oracle DataAdapter SelectCommand CommandText SQL SQL CommandText!?.NET Oracle Grapecity (ActiveReports) 21
3. DataSet DataAdapter DataSet DataAdapter DataSet DataSet ODT DataSet XML xsd ODT DataAdapter DataSet!?.NET Oracle Grapecity (ActiveReports) 22
demoproductinfooracledataadapter1.fill(productinfodataset) DataAdapter Fill DataSet DataSet ODT WEB ActiveReportDemo_WebService.vbproj ActiveRepotDemo.asmx DataSet ActiveReport DataSet ActiveReports WEB DataSet ActiveReports DataSet '' Web ds = ws.getproductinfo '' Dim rpt As New ActiveReport1 Dim dv As DataView = ds.tables(0).defaultview dv.sort = "PRODUCT_ID" rpt.datasource = dv '' Me.Viewer1.Document = rpt.document rpt.run(true) ActiveReports DataSource DataSet DataView DataReader DataTable!?.NET Oracle Grapecity (ActiveReports) 23
DataView ActiveReports DataSource BLOB BLOB ActiveReports BLOB ActiveReports HTMLDB demo_imagegs ActiveReports ActiveReports PictureBox ActiveReports DataSet ActiveReports!?.NET Oracle Grapecity (ActiveReports) 24
HTMLDB HTMLDB 1. HTMLDB HTMLDB 2. HTMLDB Sample Application v1.6 3. Products!?.NET Oracle Grapecity (ActiveReports) 25
4. 5. Products 1.10 6.!?.NET Oracle Grapecity (ActiveReports) 26
7. PRINTLIST Print List URL 8. Button!?.NET Oracle Grapecity (ActiveReports) 27
9. 10. URL URL ASP.NET ASP.NET http://[ IP ]/ActiveReportDemo_ASPNET/Report.aspx?Action=prtProductInfo http://[ IP ]/ActiveReportDemo/ bin/activereprotdemo_winform.exe!?.net Oracle Grapecity (ActiveReports) 28
Builder - 100!?.NET Oracle Grapecity (ActiveReports) 29
demo, sample sample( ) Products!?.NET Oracle Grapecity (ActiveReports) 30
Print List ActiveReports ASP.NET WEB!?.NET Oracle Grapecity (ActiveReports) 31
ActiveReports!?.NET Oracle Grapecity (ActiveReports) 32
HTMLDB ActiveReports!?.NET Oracle Grapecity (ActiveReports) 33