| 发表于:2008-01-14 22:32:291楼 得分:0 |
using system; using system.web; using system.collections; using system.web.services; using system.web.services.protocols; using system.data; using system.data.sqlclient; /// <summary> /// spservice 的摘要说明 /// </summary> [webservice(namespace = "http://123456.com")] [webservicebinding(conformsto = wsiprofiles.basicprofile1_1)] public class spservice : system.web.services.webservice { public spservice() { //如果使用设计的组件,请取消注释以下行 //initializecomponent(); } [webmethod] public dataset getspservices() { sqlconnection conn; conn = new sqlconnection(); conn.connectionstring = system.configuration.configurationsettings.appsettings ["connstring"]; try { dataset ds = new dataset(); string searchstring = "select titleurl,titlename,titledesc from webservice"; sqldataadapter da = new sqldataadapter(searchstring, conn); da.fill(ds,"getspservices"); return ds; } catch { return null; } } } 这是我的代码 不知道怎么按照描述文件里的规则建立该web service 这是我上面代码调用返回的文档,大概数据结构就是这样 <?xml version="1.0" encoding="utf-8" ?> - <dataset xmlns="http://123456.com"> - <xs:schema id="newdataset" xmlns="" xmlns:xs="http://www.w3.org/2001/xmlschema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> - <xs:element name="newdataset" msdata:isdataset="true" msdata:usecurrentlocale="true"> - <xs:complextype> - <xs:choice minoccurs="0" maxoccurs="unbounded"> - <xs:element name="getspservices"> - <xs:complextype> - <xs:sequence> <xs:element name="titleurl" type="xs:string" minoccurs="0" /> <xs:element name="titlename" type="xs:string" minoccurs="0" /> <xs:element name="titledesc" type="xs:string" minoccurs="0" /> </xs:sequence> </xs:complextype> </xs:element> </xs:choice> </xs:complextype> </xs:element> </xs:schema> - <diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas- microsoft-com:xml-diffgram-v1"> - <newdataset xmlns=""> - <getspservices diffgr:id="getspservices1" msdata:roworder="0"> <titleurl> url1 </titleurl> <titlename> 【1】 </titlename> <titledesc> 1 </titledesc> </getspservices> - <getspservices diffgr:id="getspservices2" msdata:roworder="1"> <titleurl> url2 </titleurl> <titlename> 【2】 </titlename> <titledesc> 2 </titledesc> </getspservices> - <getspservices diffgr:id="getspservices3" msdata:roworder="2"> <titleurl> url3 </titleurl> <titlename> 【3】 </titlename> <titledesc> 3 </titledesc> </getspservices> </newdataset> </diffgr:diffgram> </dataset> | | |
|