<script src="jquery-1.7.2.js" type="text/javascript"></script>
<script type="text/javascript">
$(function () {
$("#btn").click(function () {
WebService.GetUername($("#Text1").val(), $('#Password1').val(), onSuccess, onFailed);//在这调用WebService的方法
function onSuccess(result) {
$('#mydiv').html(result);
}
function onFailed() {
alert('调用失败!');
}
})
})
</script>
</head>
<body>
<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server">
<Services>
<asp:ServiceReference Path="~/WebService.asmx" />
</Services>
</asp:ScriptManager>
<div>
<table>
<tr>
<td>
用户名:
</td>
<td>
<input id="Text1" type="text" />
</td>
</tr>
<tr>
<td>
密码:
</td>
<td>
<input id="Password1" type="password" />
</td>
</tr>
<tr>
<td>
</td>
<td>
<input id="btn" type="button" value="注册" />
</td>
</tr>
</table>
</div>
<div id="mydiv"></div>
</form>
</body>
</html>
WebService
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Configuration;
using System.Data.SqlClient;
/// <summary>
///WebService 的摘要说明
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
//若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务,请取消对下行的注释。
[System.Web.Script.Services.ScriptService]
public class WebService : System.Web.Services.WebService {
public WebService () {
//如果使用设计的组件,请取消注释以下行
//InitializeComponent();
}
[WebMethod]
public string HelloWorld() {
return "Hello World";
}
[WebMethod]
public string GetUername(string username,string pwd)
{
string strcnn = ConfigurationManager.ConnectionStrings["connstring"].ConnectionString;
SqlConnection cnn = new SqlConnection(strcnn);
SqlCommand cmd = cnn.CreateCommand();
cmd.CommandText = "select count(*) from UserInfo where username=@name";
cmd.Parameters.AddWithValue("@name",username);
cnn.Open();
int a = Convert.ToInt32(cmd.ExecuteScalar());
string s="";
if (a > 0)
{
s="用户名已被注册,请换个名称";
}
else
{
cmd.CommandText = "insert into UserInfo (username,userpwd) values(@username,@pwd)";
cmd.Parameters.AddWithValue("@username", username);
cmd.Parameters.AddWithValue("@pwd",pwd);
int i=Convert.ToInt32(cmd.ExecuteNonQuery());
if (i>0)
{
s="注册成功!";
}
}
cmd.Dispose();
cnn.Close();
cnn.Dispose();
return s;
}
}