欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

WebService提供Add和getStudent服务(IIS发布)

程序员文章站 2022-12-01 18:26:22
-------------WebService1.asmx.cs-----------------  public class WebService1 : System...
-------------WebService1.asmx.cs-----------------

 public class WebService1 : System.Web.Services.WebService

 {

 

[WebMethod]

 public int Add(int a, int b)

 {

 return a + b;

 }

 [WebMethod]

 public DataSet GetStudent()

 {

 string constr = ConfigurationManager.ConnectionStrings["studentConstr"].ConnectionString;

 string sql = "select * from student";

 SqlDataAdapter adapter = new SqlDataAdapter(sql, constr);

 DataSet ds = new DataSet();

 adapter.Fill(ds);

 return ds;

 }

 }

==========================Web.config==========================

<configuration>

 <system.web>

 <webServices>

 <protocols>

 <add name="HttpGet"/>

 </protocols>

 </webServices>

 <compilation debug="true" targetFramework="4.0" />

 </system.web>

 <connectionStrings>

 <add name="studentConstr" connectionString="data source=.;initial catalog=student;user 

 

id=sa;password=111111;"/>

 </connectionStrings>

</configuration>

 

 

 

-------WebAddStudent.aspx前台--------------- 

<body>

 <form id="form1" runat="server">

 <p>

 <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

&nbsp;+

 <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>

&nbsp;<asp:Button ID="Button1" runat="server" Xonclick="Button1_Click" Text="Button" />

&nbsp;<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>

 

<br />

 <br />

 <asp:GridView ID="GridView1" runat="server">

 </asp:GridView>

 

</p>

 </form>

</body>

 

-------WebAddStudent.aspx.cs后台------------

 

protected void Button1_Click(object sender, EventArgs e)

 {

 localhost.WebService1 ws=new localhost.WebService1();

 this.TextBox3.Text= ws.Add(Convert.ToInt32(this.TextBox1.Text),Convert.ToInt32

 

(this.TextBox2.Text)).ToString();

 

this.GridView1.DataSource = ws.GetStudent();

 this.GridView1.DataBind();

 }

 

 

==========================Web.config==========================

<configuration>

 <configSections>

 <sectionGroup name="applicationSettings" type="System.Configuration.ApplicationSettingsGroup, 

 

System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" >

 <section name="userWebService.Properties.Settings" 

 

type="System.Configuration.ClientSettingsSection, System, Version=4.0.0.0, Culture=neutral, 

 

PublicKeyToken=b77a5c561934e089" requirePermission="false" />

 </sectionGroup>

 </configSections>

 <system.web>

 <compilation debug="true" targetFramework="4.0" />

 </system.web>

 

<applicationSettings>

 <userWebService.Properties.Settings>

 <setting name="userWebService_localhost_WebService1" serializeAs="String">

 <value>https://localhost:1095/WebService1.asmx</value>

 </setting>

 </userWebService.Properties.Settings>

 </applicationSettings>

</configuration>