自动判断记录是否存在

来源：互联网发布：小额网络贷款平台编辑：程序博客网时间：2024/06/09 05:51

html页面

function ValidationFunctionName1(source, arguments)

{

var vNumber=document.getElementById("<%=txtNumber.ClientID %>");

var oBao=false;

if(window.ActiveXObject)

{

oBao = new ActiveXObject("Microsoft.XMLHTTP");

}

else

{

oBao=new XMLHttpRequest();

}

//alert(userName.value);

//alert(userpwd.value);

oBao.open("Get","Chk.aspx?number="+ vNumber.value,false);

oBao.send();

var strResult = oBao.responseText;

//如果返回 1 就代表可以使用，否则不能通过验证

//alert(strResult);

if (Number(strResult) == 1)

arguments.IsValid = true;

else

arguments.IsValid = false;

}

<asp:TextBox ID="txtNumber" runat="server"></asp:TextBox><asp:RequiredFieldValidator

ID="RequiredFieldValidator1" runat="server" ErrorMessage="*" ControlToValidate="txtNumber" Display="Dynamic"></asp:RequiredFieldValidator>

<asp:CustomValidator ID="CustomValidator1" runat="server" ErrorMessage="重复"

ControlToValidate="txtNumber"

ClientValidationFunction="ValidationFunctionName1"></asp:CustomValidator>

chk.aspx页面

protected void Page_Load(object sender, EventArgs e)

{

Response.Clear();

if (isNoTitle(Request.QueryString["title"].ToString()))

{

Response.Write("1");

}

else

{

Response.Write("0");

}

Response.End();

}

/// <summary>

/// 用来判断用户在修改密码的时候原始密码是否正确

/// </summary>

/// <param name="admin_name">用户的昵称</param>

/// <param name="admin_pwd">用户的原始密码</param>

/// <returns></returns>

public bool isNoTitle(string title)

{

bool sve = false;

int i = 0;

using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"].ToString()))

{

conn.Open();

using (SqlCommand cmd = new SqlCommand("select count(classID) from info_class where className='" + title + "'", conn))

{

i = Convert.ToInt32(cmd.ExecuteScalar());

}

if(i>0)

{

sve = false;

}

else

{

sve = true;

}

return sve;

}