2007쓪ꆡꆡ9퓂횣훝듳톧톧놨(릤톧냦)Sep1ꆡ2007뗚28뻭ꆡ뗚3웚JournalofZhengzhouUniversity(EngineeringScience)Vol128ꆡNo13ꆡꆡ컄헂뇠뫅:1671-6833(2007)03-0073-03샻폃MSChart뿘볾뚯첬짺돉춳볆춼헅돉닅1,췵폀탅1,쇵떤떤1,쏏뗂뎼2(1.횣훝듳톧뮷뺳폫쮮샻톧풺,뫓쓏횣훝450001;2.뫓쓏쪡붻춨쳼몽컱뻖,뫓쓏횣훝450052)햪ꆡ튪:죧뫎붫쫽뻝뿢훐뗄쫽뻝틔춼탎뗄랽쪽횱맛뗘쿔쪾돶살,튻횱쫇돌탲뾪랢죋풱얬솦뷢뻶뗄컊쳢.ퟷ헟닻쫶쇋믹폚ADO(ActiveXDataObjects)뛔쿳뗄,샻폃VisualBasic뾪랢뮷뺳ퟔ듸뗄MSChart뿘볾짺돉뚯첬춳볆춼뗄랽램,뷩짜짺돉뚯첬춳볆춼뗄뻟쳥늽훨,횸돶MSChart뿘볾퓚짺돉뚯첬춳볆춼랽쏦뗄늻ퟣ횮뒦,늢쳡돶쿠맘뗄룄뷸랽램.뷡뫏뫓쓏쪡몽뗀믹뒡뗘샭탅쾢쾵춳뗄뾪랢쪵샽뷸탐럖컶,뇭쏷헢훖랽램뻟폐뫜뫃뗄펦폃볛횵.맘볼듊:ADO;VisualBasic;뚯첬춳볆춼;MSChart뿘볾훐춼럖샠뫅:ꆡꆡꆡ컄쿗뇪쪶싫:A0ꆡ틽퇔닮뇰뇈뷏듳,떫ퟜ뗄살쮵뇈뗚튻훖랽램랽뇣뗃뛠[1].뇊헟쳖싛뗄뻍쫇믹폚ADO뛔쿳뗄,퓚Visu2VisualBasicퟷ캪떱듺쇷탐뗄쫽뻝뿢뾪랢릤alBasic뾪랢뮷뺳훐샻폃MSChart뿘볾짺돉뚯첬뻟,뻟폐뫜잿뗄쫽뻝럃컊쓜솦,뫍쫽뻝뿢뗄솬뷓튲춳볆춼뗄랽램.쪮럖뇣샻[1].튻떩펵폐쇋쫽뻝,죧뫎죃훚뛠랱퓓ꆡADO뛔쿳쒣탍뗄쫽뻝틔횱맛뗄춼탎랽쪽뇭쪾돶살,뎣뎣쫇쾵춳ADO쫽뻝럃컊뷓뿚쫇Microsoft뒦샭쫽뻝뿢뾪랢죋풱튪쏦쇙뗄컊쳢[2],샻폃춳볆춼뿉틔뷢뻶탅쾢뗄ퟮ탂벼쫵.쯼쫇튻훖ActiveX뛔쿳,닉폃쇋헢튻컊쳢,뿉틔냑폫VisualBasic솬뷓뗄쫽뻝뿢훐놻돆캪OLEDB뗄쫽뻝럃컊쒣쪽,쫇쫽뻝럃컊뛔뗄쫽뻝횱맛뗘쿔쪾돶살.퓚쪵볊뗄쾵춳뾪랢훐,룹쿳DAOꆢ풶돌쫽뻝뛔쿳RDO뫍뾪럅쫽뻝뿢뮥솬뻝쫤죫뗄닩톯쳵볾뚯첬뗘짺돉춳볆춼뻟폐뫜잿뗄ODBC죽훖랽쪽뗄삩햹.ADO뛔쿳쒣탍뚨틥쇋튻쪵폃탔,틲듋퇐뺿뚯첬춳볆춼뗄짺돉벼쫵,뻟폐뫜룶뿉뇠돌뗄럖닣뛔쿳벯뫏,훷튪폐3룶뛔쿳돉풱훘튪뗄쿖쪵틢틥.ConnectionꆢCommand뫍Recordset,틔벰벸룶벯뫏뛔쿳ErrorsꆢParameters뫍Fields뗈ퟩ돉[4].1ꆡ뚯첬춳볆춼뗄짺돉ꆡMSChart뿘볾춼탎쫇뇭쿖쫽뻝뗄튻훖폐킧랽쪽,춨맽붫쫽MSChart뿘볾쫇튻룶ActiveX뿘볾,ActiveX뻝뿉쫓뮯,뿉틔볲뷠횱맛뗘쿲릫훚쿔쪾쳘뚨탅쾢,뿘볾쫇4훖ActiveX늿볾뗄튻훖,뛸ActiveX늿볾뛔쫽뻝뷸탐폐킧럖컶.춳볆춼쫇퓚춳볆뇭뗄믹뒡쫇ActiveX벼쫵뒴붨뗄1룶믲뛠룶뛔쿳쯹ퟩ돉짏,뇭쿖춳볆쇏뗄튻훖탎쪽,튲쫇춳볆럖컶뗄튻뗄,뿉훘뢴쪹폃뗄뇠돌듺싫뫍쫽뻝.MSChart뿘볾훖훘튪릤뻟.쯼냑춳볆뇭훐뗄쫽ퟖ탎쿳뮯,샻폃벸쪹폃잰탨튪춨맽ꆰ릤돌|늿볾ꆱ닋떥쏼쇮,퓚떯돶뫎춼탎랴펳쫽솿볤뗄뛔뇈맘쾵[3].뗄뛔뮰뿲훐톡퓱,떥믷튻냣뗄,퓚VisualBasic훐춼탎쿔쪾폐2훖랽ퟳ뇟뢴톡뿲,좻뫳내ꆰ좷뚨ꆱ내얤,붫웤쳭볓떽릤램:뗚튻,샻폃VB쳡릩뗄룷훖믦춼몯쫽(죧Lineꆢ뻟쿤훐.MSChart뿘볾뿉틔폐3훖랽램살좡뗃쫽뻝[4]Pset뗈)믲헟쪹폃Windows쳡릩뗄GUI(춼탎폃뮧:뷧쏦)몯쫽믦훆춼탎;뗚뛾,샻폃쿖폐뗄뿘볾.뗚(1)쪹폃ChartData쫴탔.춼뇭뿘볾뗄쫽뻝듦튻훖랽램뇈뷏쇩믮,떫듺싫솿첫듳,쟒죝틗돶듭.뒢폚쓚늿뗄쫽뻝췸룱쓚,폃ChartData쫴탔뿉틔횱뗚뛾훖랽램쫜뿘볾훊솿펰쿬,릦쓜뫍틗폃탔랽쏦뷓듦좡쫽뻝췸룱.쫽ퟩ뗄뗚튻룶풪쯘듦뒢컄놾뇪ꆡꆡ쫕룥죕웚:2007-04-04;탞뚩죕웚:2007-05-25ꆡꆡ믹뷰쿮쒿:쮮샻늿믆뫓쓠즳훘뗣쪵퇩쫒훺쿮쒿(2007005)ꆡꆡퟷ헟볲뷩:헅돉닅(1964-),쓐,뫓쓏쪡떦돇쿘죋,횣훝듳톧뷌쫚,늩쪿,훷튪듓쫂쮮샻탅쾢뮯벼쫵펦폃퇐뺿.' 1994-2009 China Academic Journal Electronic Publishing House. All rights reserved.
ꆡ74횣훝듳톧톧놨(릤톧냦)2007쓪잩,웤폠풪쯘듦뒢쫽뻝.샻폃뫓쓏쪡몽뗀믹뒡뗘샭탅쾢쾵춳쿮쒿(2)쪹폃Date쫴탔.샻폃춼뇭뿘볾뗄Date쫴쇏,냑ADO뛔쿳뫍SQL(StructuredQueryLan2탔뿉틔횸뚨쫽뻝췸룱훐쒳튻룶풪쯘뗄듳킡,떫탨guage)폯퇔뷡뫏웰살,뷸탐솪뫏뇠돌,샻폃Visual튪쿈횸뚨춼뇭뿘볾뗄탐쫽RowCount뫍쇐쫽Basic뾪랢뮷뺳ퟔ듸뗄MSChart뿘볾뚯첬짺돉폃ColumnCount.뮧탨튪뗄룷룶춳볆춼.ퟜ짨볆뷧쏦죧춼1쯹쪾,퓚(3)쪹폃SetData랽램.샻폃SetData랽램춬웤훐뿉틔톡퓱쫽뻝뿢훐늻춬뗄쫽뻝뇭,퓚쫽뻝뇭퇹뿉틔횸뚨쫽뻝췸싧훐쒳튻룶풪쯘뗄듳킡,춬퇹훐뿉틔룹뻝탨튪톡퓱짺돉춳볆춼쯹탨뗄X훡ퟖ탨튪쿈횸뚨춼뇭뿘볾뗄탐쫽RowCount뫍쇐쫽뛎,Y훡ퟖ뛎,튲뿉틔톡퓱웤훐뗄튻쳵볇슼,횻튪랽램룱쪽캪룄뇤쫤죫쳵볾,뻍쓜뚯첬뗘뗃떽늻춬뗄쫤돶춳볆탐,쇐,쫽횵,NullFlag.춼.춼2쿔쪾뗄쫇샻폃듋랽램짺돉뗄럖몽뗀쯹퓚ꆡ돌탲쪵쿖쮮폲샠탍ꆢ럖벼쫵뗈벶쓚뫓몽뗀샯돌춳볆춼.ꆡ틽죫ADO뛔쿳튪쿫퓚돌탲훐쪹폃ADO뛔쿳뇠돌,뇘탫쿈캪떱잰릤돌틽폃ADO뗄뛔쿳뿢.횴탐릤돌닋떥훐뗄틽폃쏼쇮,웴뚯틽폃뛔뮰뿲,퓚쟥떥훐톡퓱ꆰꆱ(늻춬뗄냦놾x뗄횵늻튻퇹).ꆡ짹쏷ADO뛔쿳캪쇋쓜릻퓚돌탲훐쪹폃ADO뛔쿳,쫗쿈뇘탫짹쏷룃뛔쿳.짹쏷폯뻤죧쿂:춼1ꆡퟜ짨볆뷧쏦ꆡGeneraldesigninterface틔짏짹쏷쇋Connection뫍Recordset뛔쿳,죧맻쿫짹쏷좫뻖뇤솿,틔뇣퓚헻룶돌탲훐뚼뿉틔쪹폃,퓲뿉틔쿲돌탲훐볓죫튻룶쒣뿩컄볾(.bas컄볾),좻뫳퓚웤훐춨맽맘볼ퟖꆰPublicꆱ살짹쏷.ꆡ뒴붨ADO뛔쿳쪵샽짹쏷쇋뛔쿳틔뫳,뮹탨튪뒴붨뛔쿳쪵샽늢짨훃솬뷓쫴탔,뻟쳥쪵쿖듺싫죧쿂:뒴붨Connection뛔쿳쪵샽="Provider=;Da춼2ꆡ럖몽뗀쯹퓚쮮폲샠탍,럖벼쫵뗈벶taSou쓚뫓몽뗀샯돌춼rce="&&"\"짨뚨ꆡThefreshwaterwaterwaylengthmapbasedononnectionString쫴탔솬뷓쫽뻝뿢,쫇쫽뻝뿢쏻 1994-2009 China Academic Journal Electronic Publishing House. All rights reserved.
ꆡ뗚3웚헅돉닅뗈ꆡ샻폃MSChart뿘볾뚯첬짺돉춳볆춼ꆡ75쪾춼뇭훐뗄쫽뻝.믡폐룼듳뗄랢햹잰뺰.(2)뮻폃릦쓜룼잿듳뗄짌폃춼뇭뿘볾,죧3ꆡ뷡쫸폯Formulaone뫍TeeChart,살짺돉춳볆춼.춼3쯹쪾뗄뻍쫇폃TeeChart뿘볾룄뷸짺돉뗄퓚VisualBasic뾪랢뮷뺳훐냑ADO뛔쿳뫍뫓쓏쪡쓚뫓몽뗀춼.평춼3뿉횪,TeeChart뿘볾쿔SQL폯퇔뷡뫏웰살,샻폃MSChart뿘볾뚯첬뗘짺쪾뗄킧맻룼뫃,퓚뫡훡짏쿔쪾늻췪뗄몽뗀쏻돆뿉돉폃뮧탨튪뗄룷훖춳볆춼.헢훖랽램볈뇜쏢쇋닙틔퓚ퟝ훡짏틔뇪잩뗄탎쪽쿔쪾돶살,뷢뻶쇋평폚ퟷ킧싊뗍뗄좱뗣,폖돤럖샻폃SQL폯퇔뗄쇩믮춼뇭탐쇐뷏뛠,뾴늻쟥돾쫽뻝뫍뇪잩쇨싒뗄컊쳢.탔,쯹폐쫽뻝뿢닙ퟷ뚼춨맽뇠돌쪵쿖,뿉틔듳듳쳡뿉틔풤퇔,퓚춳볆춼뗄짺돉랽쏦,TeeChart뿘볾붫룟쾵춳뾪랢킧싊,뷚쪡쾵춳뾪랢쪱볤.춼3ꆡTeeChart짺돉뗄뫓쓏쪡쓚뫓몽뗀춼ꆡThefreshwaterwaterwaymapofHenanprovincebasedonTeeChart닎뾼컄쿗[3]ꆡ풷뻼죣,믆?캨,쇵뚬쇖.WebGIS뛾듎뾪랢훐춳볆:쫽뻝뗄뿉쫓뮯쪵쿖[J].닢믦폫뿕볤뗘샭탅쾢,2005,28(2):42-461[1]ꆡ헔쮹쮼.VisualBasic쫽뻝뿢뇠돌벼쫵폫쪵샽[M].놱뺩:죋쏱폊뗧돶냦짧,-1611[4]ꆡ릨엦퓸,슽캿쏱,퇮횾잿.VisualBasic돌탲짨볆볲쏷뷌돌(냦)[M].놱뺩:룟뗈뷌폽돶냦짧,2002.[2]ꆡ샮쏴뻼.VFP뮷뺳쿂뚯첬춳볆춼뗄쪵쿖[J].뢣붨뗧쓔,2005,(9):142-1451260-2621TheBuildingofDynamicStatisticalGraphicsBasedonMSChartZHANGC11heng2cai,WANGY12ong2xin,LIUDan2dan,MENGDe2chen(,ZhengzhouUniversity,Zhengzhou450001,China;,CommunicationsDepartmentofHenanProvince,Zhengzhou450052,China)Abstract:Themethodofbuildingdynamicstatisticalgraphicsisdiscussedinthispaper,usingMSChartcon2trolcomponentandADOobject,,thedisadvantagesofMSChartcontrolcomponentonbuildingofdynamicstatisticalgraphicsarepointedout,,:ActiveXDataObjects;VisualBasic;statisticalgraphics;MSChartcontrolcomponent' 1994-2009 China Academic Journal Electronic Publishing House. All rights reserved.
