创建和调用自定义Web服务
一、创建自定义Web服务
CustomWebService.cs
using System;
using System.Web;
using System.Collections;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data;
using System.Data.Odbc;
/**//// <summary>
/// CustomWebService 的摘要说明
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class CustomWebService : System.Web.Services.WebService
{
public CustomWebService()
{
//如果使用设计的组件，请取消注释以下行
//InitializeComponent();
}
// WEB 服务示例
// HelloWorld() 示例服务返回字符串 Hello World
// 若要生成，请取消注释下列行，然后保存并生成项目
// 若要测试此 Web 服务，请按 F5 键
[WebMethod]
public DataSet DataFind(string stuNo)
{
//设置ConnectionString字符串
String ConnString = @"Driver=Microsoft Access Driver (*.mdb);Dbq=d:\WebSite\WebService\App_Data\WebServicedb.mdb;";
//实例化OdbcConnection对象
OdbcConnection myConnection = new OdbcConnection(ConnString);
//执行Open方法建立连接
myConnection.Open();
//设置SQL语句
string QueryString = "select * from stuInfo where 学号=" + stuNo;
//执行SQL语句
OdbcCommand myCommand = new OdbcCommand(QueryString, myConnection);
//实例化OdbcDataAdapter对象
OdbcDataAdapter myAdapter = new OdbcDataAdapter();
myAdapter.SelectCommand = myCommand;
//实例化DataSet对象
DataSet myDst = new DataSet();
myAdapter.Fill(myDst, "Student");
//关闭连接
myConnection.Close();
//返回DataSet集
return myDst;
}
//[WebMethod]
//public string HelloWorld()
//{
// return "Hello World";
//}
}
二、调用自定义Web服务
CustomWebServiceApp.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="CustomWebServiceApp.aspx.cs" Inherits="CustomWebServiceApp" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>CustomWebService调用</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<h3>使用自定义Web服务示例</h3>
<p>
请输入学号：<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="查询" /></p>
<p>
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
</p>
</div>
</form>
</body>
</html>
CustomWebServiceApp.aspx.cs
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class CustomWebServiceApp : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
CustomWebService stuInfo = new CustomWebService();
DataSet Dst = new DataSet();
Dst = stuInfo.DataFind(TextBox1.Text);
GridView1.DataSource = Dst.Tables[0].DefaultView;
GridView1.DataBind();
}
}
CustomWebService.csusing System;using System.Web;using System.Collections;using System.Web.Services;using System.Web.Services.Protocols;using System.Data;using System.Data.Odbc;/**//// <summary>/// CustomWebService 的摘要说明/// </summary>[WebService(Namespace = "http://tempuri.org/")][WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]public class CustomWebService : System.Web.Services.WebService{ public CustomWebService() { //如果使用设计的组件，请取消注释以下行 //InitializeComponent(); } // WEB 服务示例 // HelloWorld() 示例服务返回字符串 Hello World // 若要生成，请取消注释下列行，然后保存并生成项目 // 若要测试此 Web 服务，请按 F5 键 [WebMethod] public DataSet DataFind(string stuNo) { //设置ConnectionString字符串 String ConnString = @"Driver=Microsoft Access Driver (*.mdb);Dbq=d:\WebSite\WebService\App_Data\WebServicedb.mdb;"; //实例化OdbcConnection对象 OdbcConnection myConnection = new OdbcConnection(ConnString); //执行Open方法建立连接 myConnection.Open(); //设置SQL语句 string QueryString = "select * from stuInfo where 学号=" + stuNo; //执行SQL语句 OdbcCommand myCommand = new OdbcCommand(QueryString, myConnection); //实例化OdbcDataAdapter对象 OdbcDataAdapter myAdapter = new OdbcDataAdapter(); myAdapter.SelectCommand = myCommand; //实例化DataSet对象 DataSet myDst = new DataSet(); myAdapter.Fill(myDst, "Student"); //关闭连接 myConnection.Close(); //返回DataSet集 return myDst; } //[WebMethod] //public string HelloWorld() //{ // return "Hello World"; //}}二、调用自定义Web服务
CustomWebServiceApp.aspx<%@ Page Language="C#" AutoEventWireup="true" CodeFile="CustomWebServiceApp.aspx.cs" Inherits="CustomWebServiceApp" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" ><head runat="server"> <title>CustomWebService调用</title></head><body> <form id="form1" runat="server"> <div> <h3>使用自定义Web服务示例</h3> <p> 请输入学号：<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox> <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="查询" /></p> <p> <asp:GridView ID="GridView1" runat="server"> </asp:GridView> </p> </div> </form></body></html>CustomWebServiceApp.aspx.csusing System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;public partial class CustomWebServiceApp : System.Web.UI.Page{ protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) { CustomWebService stuInfo = new CustomWebService(); DataSet Dst = new DataSet(); Dst = stuInfo.DataFind(TextBox1.Text); GridView1.DataSource = Dst.Tables[0].DefaultView; GridView1.DataBind(); }}