΢ͻӦ
MICROCOMPUTER & ITS APPLICATIONS
2000Vol.19No.6P.55-58




RDSʵµ޸
ƽл
ժҪRDSĹԭRDSʵֻ޸ĵľʵַ
ؼʣRemote Data ServiceRDS޸
еĽ죬еĹϵͳռϢʵֻ͹ϵͳԭڵʹõݿӦֲУΪؽ⡣
ͳݿӦҪάݲѯݷĹܡΪ˿ݿӦãҪ̽๦µĻµľʵַĽάйص޸ĵľʵչۡ
1  RDS乤ԭ
RDS(Remote Data Service)Microsoft˾ĻĿٶЧ뷢ĻܣǰV1.0Advanced Data Connector(ADC)V1.5ŸΪRDSǻHTTPHTTPS(HTTP over Secure Sockets layer)DCOMӦЭĿͻֲʽӦüͨʹþݸ֪ܵActiveXؼRDSʹÿϵݿӦÿƿһͻݿӦõķʽСҪ˽RDSؼ˽乤ģʽͼ1ʾ

ͼ1  RDSĹģʽ
ͼп֪ͻӦóͨActiveX Data Object(ADO)ݿҪͨRDSRDSͺһADOݵĴһģʽһActiveX Server Page(ASP)ͬͼ2ʾASPʽ£ADOODBCͬһϣRDSʽ£ADOODBCڲͬĻϣͨRDSá

ͼ2  ASPĹģʽ
RDSģʽ£ݷʸʺʽRDSݷʷʽġڿʼʱRDSWebݿȡҪļ¼Ȼ1ݣADOļ¼Ӹжȡݣڼ¼ݺдһֻڵRDSSubmitChanges󣬲ŰύWebݿ⡣乤ԭͼ3ʾ

ͼ3  RDSģʽ
2  RDSʵֻ޸
ʹVBȿٿݿӦʱҪʵֶݵ޸ģֱ۵ķʹ(GridBrowse)ؼֻҪúøÿؼԺ󣬾ͿԷʵӺ޸ĵȹܡ£ֻҪҳϲؼRDSؼDataSrcΪӦRDSͿʵؼRDSɵļ¼֮ӡźǣMicrosoftṩؼʾݣʵֶݵ޸ġҪʵֶݵ޸ģҪ
2.1 ʹActiveXؼSSDBGrid
SSDBGridؼSheridan SoftWareDBGridʵݵɾ޸ĵȲĹ¡
(1)ҳϲ
ҳϲRDSSSDBGridȿԽHTMLĿߣFrontPageInterDevȣÿӵķʽActiveXؼҲ԰ĴֱдĳHTML༭ȻҪ֤ƻ2ؼRDSڰװIE4.0ϰ汾ʱԶװģڰװ°汾IISPWSʱṩ1SSDBGridؼð汾вʱԶظÿؼҪעǣҪȷSSDBGridؼеcodebaseԣſ˳ɿؼع̡
RDSؼ
OBJECT classidclsidBD96C55665A311D0983A
00C04FC29E33 IDADC HEIGHT1 WIDTH 1
OBJECT
ҳϲRDSصť(硰桱롰ȡ)
ڲTable󣬲ڱĵԪвıѡHTML
ԡTable£
TABLE WIDTH100 ALIGNcenter BORDER1
IDtab1 DataSrc壣ADC DataPageSize2 CELLSPAC
ING1 CELLPADDING1
2ؼDataSrcDataPageSizeֱʾRDSͷҳʾʱÿҳʾļ¼
ʹñǣTHEADTHEAD룼TBODYTBODYֱʾͷ塣
Ϊвıѡ£
TDINPUT idtext2 nametext2 datafldname TD
TDSELECT idselect1 nameselect1 datafldsex
OPTION valueС selected
OPTION valueŮ壾Ů
SELECTTD
ҪDataFldԵãʾֶΡ
ܱд롣桱롰ȡťصĴƣڿƱݵݷҳİťд´롣
INPUT idbutton1 namebutton1
typebutton valueһҳ onclicktab1.next
PageP
INPUT idbutton2 namebutton2
typebutton valueǰһҳ onclicktab1.previ
ousPageP
1ʵ
HTML
HEAD
BODY
OBJECT classidclsidBD96C55665A311D0983A
00C04FC29E33 height1 idADC
width1OBJECT
SCRIPT LANGUAGEVBScript壾
ű
SUB WindowOnLoad  ʼ
ServerstrhttpRequest.ServerVariables(SERV
ERNAME)
ConnectstrDSNyyppuidscottpwdscottconnect
stringyypp
SQLstrSelect * from student
ADC.ServerServerstr
ADC.ConnectConnectstr
ADC.SQLSQLstr
ADC.Refresh
END SUB
SUB UpdateOnClick  䱣
On error Resume Next
SSDBGridؼ
OBJECT IDGRIDWIDTH600 HEIGHT200
Datasrc壣ADC
codebasehttp壼Request.ServerVariables(SERV
ERNAME)MSADCSamplesssdatb32.cab
CLASSIDCLSIDAC05DC807DF111d0839E
00A024A94B3A壾
PARAM NAMEVersion VALUE131072壾
PARAM NAMEBackColor VALUE壭2147483643壾
PARAM  NAMEBackColorOdd   VALUE壭2147483643壾
PARAM NAMEForeColorEven VALUE0壾
PARAM NAMEAllowAddNew   VALUE1壾
PARAM NAMEAllowDelete塡VALUE1壾
OBJECT
ύť
INPUT TYPEBUTTON NAMEUpdate VALUE屣壾
(2)
ڲ󣬱ʵÿؼԡҪGridؼDatasrcΪӦRDSؼĲAllowAddnewAllowDeletֵΪ1
Datasrc壣ADC
PARAM NAMEAllowAddNew VALUE1壾
PARAM NAMEAllowDelete VALUE1壾
(3)д
ڱǣSCRIPT LANGUAGEVBScript壾룼SCRIPT֮뼰¼磬ύ޸ĵİťġClick¼´룺
SCRIPT LANGUAGEVBScript壾
SUB UpdateOnClick
If ADC.ReadyState  adcReadyStateLoaded then
ADC.SubmitChanges  ύ޸
ADC.Refresh  ·
Grid.Rebind   °
Else
MsgBox Query results still arrivingPlease wait
End if
END SUB
SCRIPT
ˣӡɾ޸ĳĹѻˡڰװIIS4.0ӦPWSʾĿ¼msadcsamplesadctest.aspҵﲻ׸
2.2 ʹHTML
IE4.0Microsoft˾չ˻HTMLʹRDSϣͬһݿӦõĻܡһ棬HTMLڽҪװһ棬ҪӵķãHTMLĸֱʹǳ㡣ͨʵ˵RDSHTMLʵֻWebݿӦõĹ̡
HTML
HEAD
BODY
OBJECT classidclsidBD96C55665A311D0983A00C04FC29E33 height1 idADC width1OBJECT
SCRIPT LANGUAGEVBScript壾
ű
SUB WindowOnLoad  ʼ
ServerstrhttpRequest.ServerVariables(SERV
ERNAME)
ConnectstrDSNyyppuidscottpwdscottconnect
stringyypp
SQLstrSelect * from student
ADC.ServerServerstr
ADC.ConnectConnectstr
ADC.SQLSQLstr
ADC.Refresh
END SUB
SUB UpdateOnClick  䱣
On error Resume Next
ADC.SubmitChanges
If Err.Number0 then
ADC.CancelUpdate
End If
ADC.Refresh
END SUB
SUB CancelOnClickȡ
ADC.CancelUpdate
ADC.Refresh
END SUB
SCRIPT
TABLE WIDTH100 ALIGNcenter BORDER1 
TRTDINPUT idbutton1 namebutton1
typebutton valueһҳ onclicktab1.next
PageTD
TDINPUT idbutton2 namebutton2
typebutton valueǰһҳ onclicktab1.previ
ousPageTD
TDINPUT TYPEbutton NAMEUpdate 
VALUE屣壾TD
TDINPUT TYPEbutton NAMECancel 
VALUEȡ壾TD
TRTABLE
TABLE WIDTH100 ALIGNcenter BORDER1
IDtab1 DataSrc壣ADC DataPageSize2
CELLSPACING1 CELLPADDING1
THEAD
TR
TDnumTD
TDnameTD
TDsexTD
TDmariageTD
TDtelTD
TDaddressTD
TR
THEAD
TBODY
TR
TDINPUT idtext1 nametext1
DataFldnum TD
TDINPUT idtext2 nametext2
datafldname   TD
TDSELECT idselect1 nameselect1
datafldsex
OPTION valueС selected
OPTION valueŮ壾Ů
SELECTTD
TDINPUT typecheckbox idcheck
box1 namecheckbox1
datafldmariTD
TDINPUT idtext3 nametext3 datafld
telTD
TDINPUT idtext4 nametext4 datafld
addressTD
TR
TBODY
TABLE
BODY
HTML
ڱĵԪвʽĿؼñDataSrcԼصԪĿؼDataFldԡʵϣҲԲʹñ񣬶ֱòؼDataSrcDataFldԡ磺
INPUT idtext3 nametext3 DataSrc壣ADC 
Datafldtel 
ͨѶĿؼһ𣬾Ϳʵʽĵ¼ӡʾ޸ɾȲ
ռWebݿ⼼ϳ졣ĽܵķȻѾһʵüֵһЩҪ簲ȫ⡣ΪڿͻִУԴ鿴磬ݿӴȣȻͨWebODBCӴһϢϾһȫ
ƽɳϲƾѧԺϢͳϵ410079
л£ϳϢϵͳ޹˾
ο
1٣սܣΰActive Server Page ݿ⣮ʵ磬1999
2Martiner WVisual BasicWebָϣ ҵ磬1998
3ƽܴ죬ȣInternetIntranetĿӦãɶӿƼѧ磬1999
ոڣ19991211
