键入Delphi7的WebService与数据库Delphi教程

精选公文范文管理资料

Delphi7的WebService与数

据库Delphi教程

Server端 SoapDataModule中加入ADOConnection1、 ADODataSet1、DataSetProvider 1  D ataSetProvider 1 的DataSet设置为ADODataSet1ADODataSet1的C o mm an dTe xt设置为空C o nne ct i o n设置为AD OConnection1 。

D ataSetProvider 1的D ataRe que st事件functionTDataMod.DataSetProvider1 DataRequest(Sender:TObj e ct;

Input:OleVariant):OleVariant;beginif ADOConnection 1.Connected thenbegin

AD OD at a S et 1.CommandTe xt :=I nput;[键入文字] [键入文字] [键入文字]

精选公文范文管理资料

Re sult :=D ataSetProvider 1.D ata;end;end;proce dureTDataMod.SoapDataModuleCreate(Sender:TObj e ct);v ar

DataPath: string;const

SQL :string =‘Provider=Microsoft.Jet.OLEDB.4.0;D ataSource=E:\programs\De lphi 7\Demos\Web S ervices\SOAPDataModule\Data\Tree.mdb;PersistSecurity Info=False’;begin

D at aP ath :=ExtractFileP ath(Application.ExeName)+

‘. .\Data\’;

XMLTransformProvider 1.XMLD ataFile :=DataPath+‘XML_Document.xml’ ;

[键入文字] [键入文字] [键入文字]

精选公文范文管理资料

XMLTransformProvider 1.TransformRead.TransformationF ile:=D ataP ath+‘ToDp.xtr’;

XMLTransformProvider 1.TransformWrite.Trans formati onFile :=D ataP ath+‘ToXml.xtr’;try

AD OConne cti on 1.C onne cte d:=false;

ADOConnection1.ConnectionString:=S QL;

AD OConne cti on 1.C onne cte d:=true;except

//showme ssage(A_ParentP ath+’D ata\InfoMat.mdb调用失败’);end;end;

Client端

SoapConnection 1 、 ClientDataSet 1 ClientDataSet1的ConnectionBroker属性为So apC onne ction 1  Provi derN ame 属性为DataSetProvider 1

查询记录集

[键入文字] [键入文字] [键入文字]

精选公文范文管理资料proce dureTClientForm.Button 1 Click(Sender:TObject);var SQL:string;beginif not SoapConnection1.Connected thenbegin

S o apC onne ction 1.URL:=URLLi st.Te xt+’/so ap/IDataMod’;

SoapConnection1.Open;end;

S QL:=Edit 1.text;with ClientDataSet1 dobegin

D ata:=D ataRe quest(S QL);end;end;

[键入文字] [键入文字] [键入文字]