Using XML as a Table In Delphi

[fayyaz]

Hi
I have writen a web service. this web service has a method that returnes a Table as XML format
and I need to use it as a table.
how can i use this web service as a table.
is any way to convert XML format to Table format
Thank you

[pritaeas]

Can you show the code that is returning the XML?

[fayyaz]

Yes of course
this is my code in Delphi prism

namespace;

interface

uses
  System,
  System.Web,
  System.Collections,
  System.Web.Services,
  System.Web.Services.Protocols,
  System.Data,
  System.Data.SqlClient,
  Microsoft.SqlServer.Server,
  System.Data.SqlTypes;

type
  [WebService(&Namespace := 'http://***.***.***.***')]
  [WebServiceBinding(ConformsTo := WsiProfiles.BasicProfile1_1)]
  Service = public class(System.Web.Services.WebService)
  public        
    method HelloWorld: string;
    method SUM(a,b:Integer):Integer;
    method GetData :DataTable;
  end;

implementation

[WebMethod]
method Service.HelloWorld: string;
begin
  result := 'Hello World';
end;

[WebMethod]
method Service.SUM(a,b:Integer): Integer;
begin
  result := a+b;
end;

[WebMethod]
method Service.GetData: DataTable;
Var
  StrCon:String;
  Con:SqlConnection;
  DS:DataSet;
  Da:SqlDataAdapter;
begin
  Con:= New SqlConnection;
  Con.ConnectionString:='Data Source=***.***.***.***;Initial Catalog=Data_Transform;Persist Security Info=True;User ID=*****;Password=****';
  Con.Open;
  Da:= new SqlDataAdapter('Select * From ADAM1_In_Data',Con);
  DS:= new DataSet;
  Da.Fill(DS,'Table1');
  Con.Close;
  result:=DS.Tables[0];
  //.Rows[0].Item[7].ToString;
end;

end.

and its output in IE is attached as XML File

[pritaeas]

IIRC a DataSet has a LoadFromFile method which you can use to read the returned XML.

[fayyaz]

I Dont want to read XML File To a Dataset. I want to get the result of webservice methode as a Table;

On the outher hand
TClientDataset hase LoadFromFile method but it raise a run time error when I Try to load XML File

[pritaeas]

I want to get the result of webservice methode as a Table;

Not sure how to put XML in a Table component.

but it raise a run time error

What's the error?