VFPÈçºÎµ÷ÓÃASP.NET Web·þÎñÖеÄDataSet

Ò»¡¢ASP.NET Web Service´úÂë
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data.SqlClient;
 
namespace WebService1
{
    /// <summary>
    /// Service1 µÄժҪ˵Ã÷
    /// </summary>
    [WebService(Namespace = "http://tempuri.org/")]
    [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
    [ToolboxItem(false)]
    public class Service1 : System.Web.Services.WebService
    {
 
        [WebMethod]
        public DataTable GetProducts(int CategoryID)
        {
            SqlConnection sqlconn = new SqlConnection("server=.;uid=sa;database=NorthWind");
            sqlconn.Open();
            SqlDataAdapter sda = new SqlDataAdapter("select * from Products where CategoryID=" + CategoryID, sqlconn);
            DataSet ds = new DataSet();
            sda.Fill(ds,"temp");
            sqlconn.Close();
            return ds.Tables["temp"];
        }
    }
}
 
¶þ¡¢²âÊÔWEB·þÎñ¿ÉÓúóVFPÔõô½«Æäת»»³ÉÁÙʱ±í
         *  µ÷ÓÃWeb·þÎñ²¿·Ö
     local loSoap,lcXmlData
     loSoap = Createobject("MSSOAP.soapclient30")
     l