WebService提供Add和getStudent服务(IIS发布)
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>
+
<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
<asp:Button ID="Button1" runat="server" Xonclick="Button1_Click" Text="Button" />
<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>