server1.asm代码清单如下:
using System;
using System.Data;
using System.Data.SqlClient;
using System.Web;
using System.Collections;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.ComponentModel;
using System.Configuration;
namespace SecurityWebService
{
??? /// <summary>
??? /// Service1 的摘要说明
??? /// </summary>
??? [WebService(Namespace = "http://tempuri.org/")]
??? [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
??? [ToolboxItem(false)]
??? public class Service1 : System.Web.Services.WebService
??? {
??????? [WebMethod]
??????? public int Add(int a,int b)
??????? {
??????????? return a + b;
??????? }
??????? [WebMethod]
??????? public string Fdk()
??????? {
??????????? return "asd";
??????? }
??????? [WebMethod]
??????? public string HelloWorld()
??????? {
??????????? return "Hello World";
??????? }
??????? [WebMethod]
??????? public DataSet GetInfo()
??????? {
??????????? return Getds("Select * From MtmCompanyIntro");
??????? }
??????? public DataSet Getds(string sSQL)
??????? {
??????????? string sConnection = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;
??????????? SqlConnection conn;
??????????? conn = new SqlConnection(sConnection);
??????????? conn.Open();
??????????? SqlCommand myCMD = new SqlCommand(sSQL,conn);
??????????? SqlDataAdapter myda = new SqlDataAdapter();
??????????? myda.SelectCommand = myCMD;
??????????? DataSet myDs = new DataSet();
??????????? myda.Fill(myDs,"mds");
??????????? conn.Close();
??????????? return myDs;
??????? }
??? }}?
