΢ͻӦ
MICROCOMPUTER & ITS APPLICATIONS
2000Vol.19No.4P.14-16



ڣңģӿؼģףݿӦ
ֽ
ժ Ҫ ʹãңģӿؼʣףݿĻͼϵͳΪ˵Ӧã󽫴ַӣз˱Ƚϡ
ؼʣ ңģӿؼ ףݿ ӣз ȣԣͣĵ
ĿǰʵWebݿʴ¿ɷΪ2ࣺһWebΪн飬ԴڷִжݿķʣݸͻASPCGIȷһǰݿصͻˣڿͻִнűӦóʵֶݿķʲȻٰдصWebݿСMicrosoftƳݰ󶨣Data BindingIE40һ𷢲2Active XؼRDSRemote Data ServicesԶݷ񣩺TDCTabular Data ControlʽݿؼRDSʵԽInternetݴȡڷODBCԴеݣTDCڷıļеݡ
ȽʹRDSؼWebݿĻȻͨʵRDSؼʵֶWebݿĸġɾӵȲ󽫴ַWebݿķASP˱Ƚϡ
1ʹRDSؼWebݿ
RDSؼʵֶWebݿķͼ1ʾ

ͼ1RDSؼWebݿķ
ִĳһHTMLĵʱҪWebݿ⣬ͨRDSؼWebIISPWSODBCݿ⽨ӣȡWebݿйؼ¼RecordsetУȻһݲṩݲڿͻʵֶWebݿĲѯġɾӵȣһ׶ΣʹWebݿе䶯ͻ˵Ҳûб䶯ͻ˶ݿϺ󣬵RDSSubmitchanges޸ĺݲŻдصWebݿС
1RDSؼʹüԺͷ
HTMLĵʹRDSؼҪHTMLģOBJECTǡ磺
object classidclsidBD96C55665A311D0983A00C04FC29E33 idtest
param nameservervaluehttpserver壾
param nameconnectvaluedsntskuidsuperpwdpj壾
param namesql valueselect * from ͼ壾object
testΪRDS䳣ServerConnectSqlServerָWebIPַConnectODBCָӵݿ⣻SqlҪеĽṹѯָ⻹ExecuteOptionsReadyStateԣҪݿʱȴĿơ
RDSĳ÷3RefreshSubmitchangesCancelUpdata
TestRefreshWebݿеݣ
TestSubmitchangesݿ޸ĺ󣬽дWebݿУ
TestCancelUpdataȡжԼ¼RecordsetеĲ
2RecordsetĳԺͷ
ΪʵֶWebݿеݼ¼вRecordsetĳԺͷ
RecordsetFieldsCountRecordsetֶ
RecordsetiNameiֶ
Recordsetֶֶָεļ¼
RecordsetMovefirstָ1¼
RecordsetMovepreviousָǰ1¼
RecordsetMovelastָ1¼
RecordsetNextָ1¼
Recordsetdeleteɾǰݼ¼
RecordsetAddnewµݼ¼
RecordsetUpdateµǰݼ¼
2Ӧþ
ͼϵͳһΪ¼ġ顢ѯԤԼȲ֡Ե¼ͼΪ˵RDSؼWebݿķ
1ڷˣMicrosoft Access1⣮mdbڿ½1ͼڿODBCûDSNУ1Դtsk⣮Mdbӳ䡣
2RDSݿؼ
object classidclsidBD96C55665A311D0983A00C04FC29E33 idtest
param nameserver valuehttpserver壾
param nameconnect valuedsntskuidsuperpwdpj壾
param namesql valueselect*from ͼ壾
object
3RDSؼHTMLǵʹáRDSıʹá
ͼţinput typetext datasrc䣣test datafldͼšsize10 idtsbhbr
ͼͣinput typetext datasrc䣣test datafldͼ͡size10 idtslxbr
input typetext datasrc䣣testdatafldsize30 idsmbr
ߣinput typetext datasrc䣣testdatafldߡsize8 idbzbr
۸input typetext datasrc䣣testdatafld۸size10 idjgbr
磼input typetext datasrc䣣testdatafldsize20 idcbsbr
ڣinput typetext datasrc䣣testdatafldڡsize12 idcbrqbr
input typetext datasrc䣣testdatafldsize6 idkcslbr
ժҪinput typetext datasrc䣣testdatafldժҪsize30 idzybr
datasrc䣣testʾıtestRDSdatafldͼšʾֶΪͼš
üʾݿ¼Ŀưť1¼壬1壬1壬1塣
input typebutton value1¼ titleTo Firstiddyg
input typebutton value1 titleTo Previous idshyg
input typebutton value1 titleTo Next idxyg
input typebutton value¼ titleTo Last idzhyg
òݼ¼İť4
input typebutton value屣 titleSave Current Change idsaverec 
input typebutton valueġ titleUpdate current Record idupdaterec
input typebutton valueӡ titleAdd a New Record idaddrec
input typebutton valueɾ titleDelete current record iddelerec
4RDSؼűԵʹáʾݿ¼ưťͲݼ¼Vbscriptűԣ
script languagevbscript壾
sub jianyan
dim msgRe
select case windoweventsrcElementid
case dyg壺
testrecordsetmoveFirst
case shyg壺
if testrecordsetAbsolutePosition1 then testrecordsetmovePrevious
else
msgbox ǵ1¼ˣ壬ʾ
end if
case xyg壺
if testrecordsetAbsolutePositiontestrecordsetRecordCount then 
msgbox 1¼ˣ壬ʾ
else
testrecordsetmove Next
end if
case zhyg壺
testrecordsetmoveLast
case updaterec
if tsbhvalue or tslxvalue or smvalue or bzvalue then
msgbox ݣ壬ʾ
else
testrecordsetupdate
end if
case addrec壺
testrecordsetaddnew
case delerec壺
msgRemsgboxɾü¼𣿡壬4徯壩
if msgRe6 then
testrecordsetdelete
end if
case saverec
testsubmitchanges
end select
end sub
script
3RDSASPWebݿıȽ
RDSؼASPʵֶWebݿķʣǸԵص㼰÷Χ
1ASPWebݿʹActive XݶADO֮⣬ASPпʹASP5öRequestResponseServerApplicationSessionԼASP 4õActive XԼVisual BasicJavaVisual C⹦ܵķASPͶ̬ҳЧߡRDSActive XзWebݿһؼVBرƳVB60УҳRDSHTMLʹãVBScriptűִд
2RDSWebݿķǽݿصͻˣȻִнűʵֶݿĲڽűڿͻˣݿĲȽASPWebݿڷִеģͻֻܸݷṩķʷݿ⣬ظͻĽǲַнϸߵЧʣܼϢͬʱݿİȫȽϿɿ濪ߵ֪ʶȨõЧ
3ASPʵWebݿ⡣ASPWebݿͬһ̨ϣASPֻǰѶȡݴ߽ṩݸWebݿݣRDSʵWebݿġԶ̡ݿ⣬֮󣬿Recordsetݼ¼ٶ뵥ݿһ졣ݵ޸ķʽҲͬASPУû޸ʱֱɷɣRDS޸Ĺ̸µWebݿУڸ޸ģֱû´Submitchanges֮󣬲ŻдWebݿСַʷInternetIntranetϹҵϢϵͳС
ֽ(ݾùѧԺϵ221006)
ο
ֽڣӣмģףݿʷְҵѧѧ
ɽ¼룮ףݿĽеҵ磬
ոڣ
