创建和调用自定义Web服务

最新推荐文章于 2024-07-22 10:11:29 发布

adlihgh692910

最新推荐文章于 2024-07-22 10:11:29 发布

阅读量122

点赞数

文章标签： xhtml ui c#

原文链接：http://www.cnblogs.com/hide0511/archive/2006/09/09/499773.html

版权

一、创建自定义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">

<title>CustomWebService调用</title>

</head>

<body>

<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();

}

转载于:https://www.cnblogs.com/hide0511/archive/2006/09/09/499773.html

adlihgh692910

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
创建和调用自定义Web服务

一、创建自定义Web服务CustomWebService.csusingSystem;usingSystem.Web;usingSystem.Collections;usingSystem.Web.Services;usingSystem.Web.Services.Protocols;usingSystem.Data;usingSystem.Data.Odbc;/**/...
复制链接

扫一扫