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
Ïà¹ØÎĵµ£º
Õâ¸öÎÊÌâÀ§ÈÅÁËÎÒÁ½Ì죬ÊÖ»úÏÂÔØ
protected void Page_Load(object sender, EventArgs e)
{
string filename = Server.UrlDecode(Request["upload"]);
string filePath = Server.MapPath("uploa ......
½éÉÜ
»º´æÊÇÔÚÄÚ´æ´æ´¢Êý¾ÝµÄÒ»Ïî¼¼Êõ£¬Ò²ÊÇASP.NETÖÐÌṩµÄÖØÒªÌØÐÔÖ®Ò»¡£ÀýÈçÄã¿ÉÒÔÔÚ¸´ÔÓ²éѯµÄʱºò»º´æÊý¾Ý£¬ÕâÑùºóÀ´µÄÇëÇó¾Í²»ÐèÒª´ÓÊý¾Ý¿âÖÐÈ¡Êý¾Ý£¬¶øÊÇÖ±½Ó´Ó»º´æÖлñÈ¡¡£Í¨¹ýʹÓûº´æ¿ÉÒÔÌá¸ßÓ¦ÓóÌÐòµÄÐÔÄÜ¡£
Ö÷ÒªÓÐÁ½ÖÖÀàÐ͵Ļº´æ£º
1.Êä³ö»º´æOutput caching
2.Êý¾Ý»º´æData caching
1. Êä³ö»º´æ(Output ......
1. C#ÓïÑÔ·½Ãæ
1.1 À¬»ø»ØÊÕ
¡¡À¬»ø»ØÊÕ½â·ÅÁËÊÖ¹¤¹ÜÀí¶ÔÏóµÄ¹¤×÷£¬Ìá¸ßÁ˳ÌÐòµÄ½¡×³ÐÔ£¬µ«¸±×÷ÓþÍÊdzÌÐò´úÂë¿ÉÄܶÔÓÚ¶ÔÏó´´½¨±äµÃËæÒâ¡£
¡¡1.1.1 ±ÜÃâ²»±ØÒªµÄ¶ÔÏó´´½¨
¡¡ÓÉÓÚÀ¬»ø»ØÊյĴú¼Û½Ï¸ß£¬ËùÒÔC#³ÌÐò¿ª·¢Òª×ñѵÄÒ»¸ö»ù±¾ÔÔò¾ÍÊDZÜÃâ²»±ØÒªµÄ¶ÔÏó´´½¨¡£ÒÔÏÂÁоÙһЩ³£¼ûµÄÇéÐΡ£
¡¡1.1.1.1 ±ÜÃâÑ»·´´½¨¶ÔÏ ......
Ò»£¬Èç¹ûÖ±½Ó°Ñasp.net mvc2 RC ²¿ÊðÔÚiis5.1ÉÏ£¬»á³öÏÖÎÞ·¨ÏÔÊ¾Ò³ÃæµÄÇé¿ö£¬ÔÒò¿ÉÄÜÊÇ·¾¶Ó³ÉäûÓÐÆð×÷Óá£
½â¾ö°ì·¨£º
1.ÔÚ routes.MapRoute(
"Default", ......