WebService.cs
[WebMethod]
public string SelectUser(string strUser)
{
SqlConnection conn = new SqlConnection(strcon);
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select PUBLISHER from ArticleInfo where PUBLISHER=@name";
cmd.Parameters.AddWithValue("@name", strUser);
conn.Open();
object obj = cmd.ExecuteScalar();
string strMessage;
if (strUser ==Convert.ToString(obj))
{
strMessage = "true";
}
else
{
strMessage = "false";
}
return strMessage;
}
注册页面
<script type="text/javascript">
$(function () {
$('#PostButton').click(function () {
WebService.SelectUser($('#UserName').val(), onSuccess, onFailed);
function onSuccess(result) {
if (result == 'true') {
$('#Message').html('对不起,用户名已存在');
}
else if(result=='false'){
$('#Message').html('输入正确');
}
}
function onFailed() {
alert('调用失败');
}
})
})
</script>
<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server">
<Services>
<asp:ServiceReference Path="~/WebService.asmx" />
</Services>
</asp:ScriptManager>
<input id="UserName" type="text" />
<input id="PostButton" type="button" value="注 册" /><br />
<div id="Message">
</div>
</form>