c_ 中通用winform组件的数据绑定（data binding of common winform components in c_）

C_中通用WINFORM组件的数据绑定（DATABINDINGOFCOMMONWINFORMCOMPONENTSINC_）DATABINDINGFORGENERALWINFORMCOMPONENTSINCWEKNOWTHATBECAUSEVISUALCITSELFHASNOLIBRARY,ASWITHOTHERNETDEVELOPMENTLANGUAGES,THECLASSLIBRARYTHATVISUALCCALLSISACOMMONLIBRARYINTHENETFRAMEWORK,THENETFRAMEWORKSDKADONETISACOLLECTIONOFACOLLECTIONOFLIBRARIESDEVELOPEDBYTHENETFRAMEWORKSDKFORDATABASEDEVELOPMENTINADONET,ALARGENUMBEROFLIBRARIESAREPROVIDEDFORDATABASECONNECTIVITYANDDATAPROCESSING,BUTTHEREISNOSUCHTHINGASDBTEXTCOMPONENTS,DBLISTCOMPONENTS,DBLABLECOMPONENTS,ANDDBCOMBOXCOMPONENTSUSINGDATABINDINGTECHNOLOGYISTHEMOSTCONVENIENTANDSTRAIGHTFORWARDWAYTODISPLAYDATAINTHEFORMOFCOMBOX,LISTBOX,ETCADATABINDINGTECHNIQUEISATECHNIQUETHATBINDSANOPENDATASETTOSOMEOFTHEATTRIBUTESOFACOMPONENTORSOMEOFTHEFIELDSTOBESPECIFIC,ITISTHEABILITYTOBINDSOMEORSOMEOFTHEFIELDSTHATHAVEALREADYOPENEDDATATOTHEPROPERTIESOFTHETEXTCOMPONENT,THELISTBOXCOMPONENT,THECOMBOX,ANDSOONWHENTHEDATABINDINGISDONETOTHECOMPONENT,THECONTENTOFTHEDISPLAYFIELDCHANGESASTHEDATARECORDPOINTERCHANGESTHISALLOWSTHEPROGRAMMERTOCUSTOMIZETHEDATADISPLAYMETHODSANDCONTENTTOPREPAREFORFUTUREDATAPROCESSINGSOTHEDATABINDINGISTHEFOUNDATIONANDTHEMOSTIMPORTANTFIRSTSTEPINVISUALCFORDATABASEPROGRAMMINGONLYWHENTHEDATABINDINGMETHODISMASTEREDCANITBEVERYCONVENIENTTOBROWSE,DELETE,INSERTANDOTHERSPECIFICDATAMANIPULATIONANDPROCESSINGFORTHERECORDSTHATHAVEBEENOPENEDDATABINDINGCANBEDIVIDEDINTOTWOTYPESACCORDINGTODIFFERENTCOMPONENTS,ONEISSIMPLEDATABINDING,ANDTHEOTHERISCOMPLEXDATABINDINGASIMPLEMODELOFDATABINDINGISBINDINGCOMPONENTDISPLAYFIELDAFTERJUSTASINGLERECORD,THISBINDINGONTHEUSEOFASINGLEVALUEISDISPLAYEDINTHEGENERALCOMPONENTS,SUCHASTEXTBOXCOMPONENTSANDLABELANDCOMPLEXITYOFDATABINDINGISDISPLAYEDAFTERBINDINGCOMPONENTFIELDISMORERECORDS,THISBINDINGGENERALLYUSEONDISPLAYMULTIPLEVALUESOFCOMPONENTS,SUCHASCOMBOXCOMPONENTS,LISTBOXCOMPONENT,ETCTHISARTICLEEXPLAINSHOWTOUSEVISUALCTOIMPLEMENTTHESETWOBINDINGSINORDERTOMAKETHECONTENTMORECOMPREHENSIVE,WEADOPTEDTWOPOPULARDATABASES,THELOCALDATABASEACESS2000,ANDTHEREMOTEDATABASESQLSERVER2000,INORDERTOMAKETHECONTENTMORECOMPREHENSIVE1SOFTWAREENVIRONMENTFORTHEDESIGNANDOPERATIONOFTHISARTICLE1MICROSOFTWINDOWS2000SERVEREDITION2NETFRAMEWORKSDKBETA23MADC26MICROSOFTACESSDATACOMPONENTIIDATADICTIONARYOFTHEDATABASEUSEDINTHEPROGRAM1THEDATABASEINTHELOCALDATABASEACCESS2000ISNAMED“DBMDB“,WHICHDEFINESATABLE“PERSON“INTHISDATABASETHEDATASTRUCTUREOFTHISTABLEISASFOLLOWSFIELDNAMEFIELDTYPEFIELDMEANINGIDNUMBERXMTEXTNAMEXBTEXTGENDERNLTEXTAGEZIPTEXTZIPCODE2THEREMOTEDATABASESQLSERVER2000DATABASESERVERNAMEFOR“SERVER1“,THENAMEOFTHEDATABASEFOR“DATA1“,LOGINIDFORTHE“SA“,PASSWORDISEMPTY,ALSODEFINESA“PERSON“INTHEDATABASETABLE,DATASTRUCTURES,SUCHASTHEABOVEMENTIONED3GENERALSTEPSOFDATABINDING1WHETHERITISSIMPLEDATABINDINGORCOMPLEXDATABINDING,THEFIRSTSTEPTOBINDINGISTOCONNECTTOTHEDATABASEANDGETTHEDATASETTHATCANBEMANIPULATEDTHENEXTTWOSECTIONSARECONNECTEDTOTHEACCESS2000ANDSQLSERVER2000DATABASES,ANDGETTHEDATASET1CONNECTACCESS2000ANDGETTHEDATASET/CREATEANOLEDBCONNECTION“STRINGSTRCON“PROVIDERMICROSOFT“OLEDBCONNECTIONMYCONNNEWOLEDBCONNECTIONSTRCONSTRINGSTRCOM“SELECTFROMPERSON“/CREATEADATASETMYDATASETNEWDATASETMYCONNTHEOPEN/USETHEOLEDBDATAADAPTERTOGETADATASETOLEDBDATAADAPTERMYCOMMANDNEWOLEDBDATAADAPTERSTRCOM,MYCONN/BINDTHEDATASETTOTHEPERSONDATATABLEMYDATASET,“PERSON“/CLOSETHISOLEDBCONNECTIONMYCONNCLOSE2CONNECTSQLSERVER2000TOGETTHEDATASET/SETTHEDATACONNECTIONSTRING,WHICHMEANSTOOPENTHESQLSERVERDATABASE,THESERVERNAMEISSERVER1,ANDTHEDATABASEISDATA1STRINGSTRCON“PROVIDERSQLOLEDB1PERSISTSECURITYINFOFALSEUSERIDSAINITIALCATALOGDATASOURCESERVER1OLEDBCONNECTIONMYCONNNEWOLEDBCONNECTIONSTRCONMYCONNTHEOPENSTRINGSTRCOM“SELECTFROMPERSON“/CREATEADATASETMYDATASETNEWDATASET/USETHEOLEDBDATAADAPTERTOGETADATASETOLEDBDATAADAPTERMYCOMMANDNEWOLEDBDATAADAPTERSTRCOM,MYCONN/BINDTHEDATASETTOTHEPERSONDATATABLEMYCOMMANDFILLMYDATASET,“PERSON“/CLOSETHISOLEDBCONNECTIONMYCONNCLOSE2ACCORDINGTODIFFERENTCOMPONENTS,DIFFERENTDATABINDINGISADOPTEDFORSIMPLEDATABINDING,DATABINDINGMETHODISRELATIVELYSIMPLE,AFTERGETTHEDATASET,USUALLYTHROUGHAFIELDOFTHEDATASETISBOUNDTOTHECOMPONENTSOFTHEPROPERTYSHOWNABOVE,SUCHASTHETEXTBOXCOMPONENTSANDTHELABELCOMPONENT,ISBOUNDTOTHE“TEXT“ATTRIBUTEFORCOMPLEXDATABINDING,BINDINGISUSUALLYDONEBYSETTINGSOMEATTRIBUTEVALUETHESEAREDESCRIBEDBELOW4DATABINDINGFORSIMPLECOMPONENTS1THEDATABINDINGOFTHETEXTBOXCOMPONENTYOUCANBINDTHEDATASETIE,MYDATASETTOTHETEXTBOXCOMPONENTS“TEXT“PROPERTYBYUSINGTHEFOLLOWINGSTATEMENTTEXTBOX1DATABINDINGSADD“TEXT“,MYDATASET,“PERSONTHEXM“NOTETHEBINDINGISTHE“XM“FIELDOFTHE“PERSON“TABLEINTHEACCESS2000DATABASEFROMTHIS,YOUCANGETTHESOURCECODETEXTBOX01CSTHATBINDSTHETEXTBOXCOMPONENT,ANDTHEFOLLOWINGCODEOPERATIONISACCESS2000,ASFOLLOWSPUBLICCLASSFORM1FORMPRIVATETEXTBOX1TEXTBOXPRIVATEBUTTONFORPRIVATESYSTEMDATATHEDATASETMYDATASETPRIVATESYSTEMCOMPONENTMODELCONTAINERCOMPONENTSNULLPUBLIC_CLICK/OPENTHEDATALINKANDGETTHEDATASETGETCONNECTINITIALIZECOMPONENT/REMOVALOFRESOURCESUSEDINTHEPROGRAMPROTECTEDOVERRIDEVOIDDISPOSEBOOLDISPOSINGIFDISPOSINGIFCOMPONENTSNULLCOMPONENTSTHEDISPOSEDISPOSINGDISPOSINGPRIVATEVOIDGETCONNECT/CREATEANOLEDBCONNECTION“STRINGSTRCON“PROVIDERMICROSOFT“OLEDBCONNECTIONMYCONNNEWOLEDBCONNECTIONSTRCONSTRINGSTRCOM“SELECTFROMPERSON“/CREATEADATASETMYDATASETNEWDATASETMYCONNTHEOPEN/USETHEOLEDBDATAADAPTERTOGETADATASETOLEDBDATAADAPTERMYCOMMANDNEWOLEDBDATAADAPTERSTRCOM,MYCONN/BINDTHEDATASETTOTHEPERSONDATATABLEMYDATASET,“PERSON“/CLOSETHISOLEDBCONNECTIONMYCONNCLOSEPRIVATEVOIDBUTTON1_CLICKOBJECTSENDER,SYSTEMEVENTARGSETEXTBOX1DATABINDINGSADD“TEXT“,MYDATASET,“PERSONTHEXM“STATICVOIDMAINAPPLICATIONRUNNEWFORM1GETTHETEXTBOXCOMPONENTISAPPLIEDTOTHEFIELDSTOTHELOCALDATABASETODATABINDINGPROCESS,CANBECONVENIENTFORREMOTEDATABASEOFDATABINDINGOFCERTAINFIELDSINTHESOURCECODETEXTBOX02CS,SPECIFICASFOLLOWSPUBLICCLASSFORM1FORMPRIVATETEXTBOX1TEXTBOXPRIVATEBUTTONFORPRIVATESYSTEMDATATHEDATASETMYDATASETPRIVATESYSTEMCOMPONENTMODELCONTAINERCOMPONENTSNULLPUBLIC_CLICK/OPENTHEDATALINKANDGETTHEDATASETGETCONNECTINITIALIZECOMPONENT/REMOVALOFRESOURCESUSEDINTHEPROGRAMPROTECTEDOVERRIDEVOIDDISPOSEBOOLDISPOSINGIFDISPOSINGIFCOMPONENTSNULLCOMPONENTSTHEDISPOSEDISPOSINGDISPOSINGPRIVATEVOIDGETCONNECT/SETTHEDATACONNECTIONSTRING,WHICHMEANSTOOPENTHESQLSERVERDATABASE,THESERVERNAMEISSERVER1,ANDTHEDATABASEISDATA1STRINGSTRCON“PROVIDERSQLOLEDB1PERSISTSECURITYINFOFALSEUSERIDSAINITIALCATALOGDATASOURCESERVER1OLEDBCONNECTIONMYCONNNEWOLEDBCONNECTIONSTRCONMYCONNTHEOPENSTRINGSTRCOM“SELECTFROMPERSON“/CREATEADATASETMYDATASETNEWDATASET/USETHEOLEDBDATAADAPTERTOGETADATASETOLEDBDATAADAPTERMYCOMMANDNEWOLEDBDATAADAPTERSTRCOM,MYCONN/BINDTHEDATASETTOTHEPERSONDATATABLEMYCOMMANDFILLMYDATASET,“PERSON“/CLOSETHISOLEDBCONNECTIONMYCONNCLOSEPRIVATEVOIDBUTTON1_CLICKOBJECTSENDER,SYSTEMEVENTARGSETEXTBOX1DATABINDINGSADD“TEXT“,MYDATASET,“PERSONTHEXM“STATICVOIDMAINAPPLICATIONRUNNEWFORM12DATABINDINGOFLABELCOMPONENTAFTERYOUHAVEMASTEREDTHEDATABINDINGOFTHETEXTBOXCOMPONENT,YOUCANEASILYGETTHEDATABINDINGMETHODOFTHELABELCOMPONENT,BECAUSETHEMETHODSAREVERYSIMILARTHEFOLLOWINGSTATEMENTISTOBINDTHE“XM“FIELDOFTHEDATASETTOTHE“TEXT“ATTRIBUTEOFTHELABELCOMPONENTLABEL1DATABINDINGSADD“TEXT“,MYDATASET,“PERSONXM“NOTETHEBINDINGISTHE“XM“FIELDOFTHE“PERSON“TABLEINTHEACCESS2000DATABASETHESOURCECODELABEL01CSFORTHELABELCOMPONENTDATABINDINGCANBEOBTAINED,ANDTHISCODEOPERATIONDATABASEISACCESS2000PUBLICCLASSFORM1FORMPRIVATELABELLABEL1PRIVATEBUTTONFORPRIVATESYSTEMDATATHEDATASETMYDATASETPRIVATEPONENTMODELATSYSTEMCOMCONTAINERCOMPONENTSNULLPUBLIC_CLICK/OPENTHEDATALINKANDGETTHEDATASETGETCONNECTINITIALIZECOMPONENT/REMOVALOFRESOURCESUSEDINTHEPROGRAMPROTECTEDOVERRIDEVOIDDISPOSEBOOLDISPOSINGIFDISPOSINGIFCOMPONENTSNULLCOMPONENTSTHEDISPOSEDISPOSINGDISPOSINGPRIVATEVOIDGETCONNECT/CREATEANOLEDBCONNECTION“STRINGSTRCON“PROVIDERMICROSOFT“OLEDBCONNECTIONMYCONNNEWOLEDBCONNECTIONSTRCONSTRINGSTRCOM“SELECTFROMPERSON“/CREATEADATASETMYDATASETNEWDATASETMYCONNTHEOPEN/USETHEOLEDBDATAADAPTERTOGETADATASETOLEDBDATAADAPTERMYCOMMANDNEWOLEDBDATAADAPTERSTRCOM,MYCONN/BINDTHEDATASETTOTHEPERSONDATATABLEMYDATASET,“PERSON“/CLOSETHISOLEDBCONNECTIONMYCONNCLOSEPRIVATEVOIDBUTTON1_CLICKOBJECTSENDER,SYSTEMEVENTARGSELABEL1DATABINDINGSADD“TEXT“,MYDATASET,“PERSONXM“STATICVOIDMAINAPPLICATIONRUNNEWFORM1GOTTHELABELCOMPONENTTOACCESS2000DATABASEDATABINDINGCODE,CHANGEYOURPROGRAMINTHEDATALINK,YOUCANGETTHELABELCOMPONENTOFSQLSERVER2000DATABASEDATABINDINGSOURCEPROGRAMCODELABEL02CS,SPECIFICASFOLLOWSPUBLICCLASSFORM1FORMPRIVATELABELLABEL1PRIVATEBUTTONFORPRIVATESYSTEMDATATHEDATASETMYDATASETPRIVATESYSTEMCOMPONENTMODELCONTAINERCOMPONENTSNULLPUBLIC_CLICK/OPENTHEDATALINKANDGETTHEDATASETGETCONNECTINITIALIZECOMPONENT/REMOVALOFRESOURCESUSEDINTHEPROGRAMPROTECTEDOVERRIDEVOIDDISPOSEBOOLDISPOSINGIFDISPOSINGIFCOMPONENTSNULLCOMPONENTSTHEDISPOSEDISPOSINGDISPOSINGPRIVATEVOIDGETCONNECT/SETTHEDATACONNECTIONSTRING,WHICHMEANSTOOPENTHESQLSERVERDATABASE,THESERVERNAMEISSERVER1,ANDTHEDATABASEISDATA1STRINGSTRCON“PROVIDERSQLOLEDB1PERSISTSECURITYINFOFALSEUSERIDSAINITIALCATALOGDATA1DATASOURCESERVER1OLEDBCONNECTIONMYCONNNEWOLEDBCONNECTIONSTRCONMYCONNTHEOPENSTRINGSTRCOM“SELECTFROMPERSON“/CREATEADATASETMYDATASETNEWDATASET/USETHEOLEDBDATAADAPTERTOGETADATASETOLEDBDATAADAPTERMYCOMMANDNEWOLEDBDATAADAPTERSTRCOM,MYCONN/BINDTHEDATASETTOTHEPERSONDATATABLEMYCOMMANDFILLMYDATASET,“PERSON“/CLOSETHISOLEDBCONNECTIONMYCONNCLOSEPRIVATEVOIDBUTTON1_CLICKOBJECTSENDER,SYSTEMEVENTARGSELABEL1DATABINDINGSADD“TEXT“,MYDATASET,“PERSONXM“STATICVOIDMAINAPPLICATIONRUNNEWFORM15DATABINDINGOFCOMPLEXCOMPONENTSINTHEINTRODUCTIONABOVE,YOULEARNEDTHATDATABINDINGTOCOMPLEXCOMPONENTSISDONEBYSETTINGCERTAINPROPERTIESOFTHECOMPONENTTOCOMPLETEDATABINDINGLETSSTARTBYINTRODUCINGTHEDATABINDINGOFTHECOMBOBOXCOMPONENT1DATABINDINGOFCOMBOBOXCOMPONENTSAFTERYOUGETTHEDATASET,YOUCANCOMPLETETHEDATABINDINGBYSETTINGTHETHREEATTRIBUTESOFTHECOMBOBOXCOMPONENT,WHICHARE“DISPLAYMEMBER“,“VALUEMEMBER“THE“DATASOURCE“ISTHEDATASETTODISPLAY,“DISPLAYMEMBER“ISTHEFIELDTHATTHECOMBOBOXCOMPONENTDISPLAYS,AND“VALUEMEMBER“ISTHEACTUALUSEVALUETHEDETAILSAREASFOLLOWSCOMBOBOX1THEDATASOURCEMYDATASETCOMBOBOX1DISPLAYMEMBER“PERSONTHEXM“COMBOBOX1VALUEMEMBER“PERSONTHEXM“NOTETHEBINDINGISTHE“XM“FIELDOFTHE“PERSON“TABLEINTHEACCESS2000DATABASETHEREFORE,THESOURCECODEOFCOMBOBOXCOMPONENTDATABINDINGCOMBO01CSISAVAILABLE,ANDTHISCODEOPERATIONDATABASEISACCESS2000PUBLICCLASSFORM1FORMPRIVATECOMBOBOXCOMBOBOX1PRIVATEBUTTONFORPRIVATESYSTEMDATATHEDATASETMYDATASETPRIVATESYSTEMCOMPONENTMODELCONTAINERCOMPONENTSNULLPUBLIC_CLICK/OPENTHEDATALINKANDGETTHEDATASETGETCONNECTINITIALIZECOMPONENT/REMOVALOFRESOURCESUSEDINTHEPROGRAMPROTECTEDOVERRIDEVOIDDISPOSEBOOLDISPOSINGIFDISPOSINGIFCOMPONENTSNULLCOMPONENTSTHEDISPOSEDISPOSINGDISPOSINGPRIVATEVOIDGETCONNECT/CREATEANOLEDBCONNECTION“STRINGSTRCON“PROVIDERMICROSOFT“OLEDBCONNECTIONMYCONNNEWOLEDBCONNECTIONSTRCONSTRINGSTRCOM“SELECTFROMPERSON“/CREATEADATASETMYDATASETNEWDATASETMYCONNTHEOPEN/USETHEOLEDBDATAADAPTERTOGETADATASETOLEDBDATAADAPTERMYCOMMANDNEWOLEDBDATAADAPTERSTRCOM,MYCONN/BINDTHEDATASETTOTHEPERSONDATATABLEMYDATASET,“PERSON“/CLOSETHISOLEDBCONNECTIONMYCONNCLOSEPRIVATEVOIDBUTTON1_CLICKOBJECTSENDER,SYSTEMEVENTARGSECOMBOBOX1THEDATASOURCEMYDATASETCOMBOBOX1DISPLAYMEMBER“PERSONTHEXM“COMBOBOX1VALUEMEMBER“PERSONTHEXM“STATICVOIDMAINAPPLICATIONRUNNEWFORM1FIGURE03THEINTERFACEOFTHECOMBOBOXCOMPONENTDATABINDINGWITHTHECOMBOBOXCOMPONENTSDATABINDINGPROGRAMFORTHELOCALDATABASE,ITISEASYTOGETTHECOMBOBOXCOMPONENTBINDINGSQLSERVER2000SOURCECODECOMBOX02CSASFOLLOWSPUBLICCLASSFORM1FORMPRIVATECOMBOBOXCOMBOBOX1PRIVATEBUTTONFORPRIVATESYSTEMDATATHEDATASETMYDATASETPRIVATESYSTEMCOMPONENTMODELCONTAINERCOMPONENTSNULLPUBLIC_CLICK/OPENTHEDATALINKANDGETTHEDATASETGETCONNECTINITIALIZECOMPONENT/REMOVALOFRESOURCESUSEDINTHEPROGRAMPROTECTEDOVERRIDEVOIDDISPOSEBOOLDISPOSINGIFDISPOSINGIFCOMPONENTSNULLCOMPONENTSTHEDISPOSEDISPOSINGDISPOSINGPRIVATEVOIDGETCONNECT/SETTHEDATACONNECTIONSTRING,WHICHMEANSTOOPENTHESQLSERVERDATABASE,THESERVERNAMEISSERVER1,ANDTHEDATABASEISDATA1STRINGSTRCON“PROVIDERSQLOLEDB1PERSISTSECURITYINFOFALSEUSERIDSAINITIALCATALOGDATASOURCESERVER1OLEDBCONNECTIONMYCONNNEWOLEDBCONNECTIONSTRCONMYCONNTHEOPENSTRINGSTRCOM“SELECTFROMPERSON“/CREATEADATASETMYDATASETNEWDATASET/USETHEOLEDBDATAADAPTERTOGETADATASETOLEDBDATAADAPTERMYCOMMANDNEWOLEDBDATAADAPTERSTRCOM,MYCONN/BINDTHEDATASETTOTHEPERSONDATATABLEMYCOMMANDFILLMYDATASET,“PERSON“/CLOSETHISOLEDBCONNECTIONMYCONNCLOSEPRIVATEVOIDBUTTON1_CLICKOBJECTSENDER,SYSTEMEVENTARGSECOMBOBOX1THEDATASOURCEMYDATASETCOMBOBOX1DISPLAYMEMBER“PERSONTHEXM“COMBOBOX1VALUEMEMBER“PERSONTHEXM“STATICVOIDMAI