求各位大神帮助!!
<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<div>
<asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="Conditional">
<ContentTemplate>
<asp:Label ID="Label1" runat="server" Text="昵称:"></asp:Label>
<asp:TextBox ID="TextBox1" runat="server"
Width="166px" ontextchanged="TextBox1_TextChanged" AutoPostBack="True"></asp:TextBox>
<asp:CustomValidator ID="cv" runat="server" ControlToValidate="TextBox1"
ErrorMessage="昵称已存在,换个试试!" ForeColor="#FF3300"
onservervalidate="cv_ServerValidate"></asp:CustomValidator>
</ContentTemplate>
<Triggers>
<asp:AsyncPostBackTrigger ControlID="TextBox1" EventName="TextChanged" />
</Triggers>
</asp:UpdatePanel>
<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="提交" />
</div>
</form>
我想让他自动检测昵称在数据库中 是否已存在?该怎么办?
这是 代码:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
public partial class CustomValidator : System.Web.UI.Page
{
string conStr = ConfigurationManager.ConnectionStrings["conStr"].ConnectionString;
protected void Page_Load(object sender, EventArgs e)
{
}
protected void TextBox1_TextChanged(object sender, EventArgs e)
{
if (TextBox1.Text!="")
{
cv.Enabled = true;
cv.Visible = true;
}
}
protected void cv_ServerValidate(object source, ServerValidateEventArgs args)
{
string name = TextBox1.Text;
using (SqlConnection con=new SqlConnection(conStr))
{
SqlCommand com = new SqlCommand();
com.Connection = con;
com.CommandText = "select * from Name where Name='"+name+"'";
con.Open();
int result = com.ExecuteNonQuery();
if (result>0)
{
args.IsValid = true;
}
else
{
args.IsValid = false;
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string name = TextBox1.Text;
using (SqlConnection con=new SqlConnection(conStr))
{
SqlCommand com = new SqlCommand();
com.Connection = con;
com.CommandText = "insert into Name(Name) values('"+name+"')";
con.Open();
int result = com.ExecuteNonQuery();
if (result>0)
{
Response.Write("<script>window.alert('加入成功!')</script>");
}
con.Close();
}
}
}
我就是不能自动检测 一定要单机按钮之后 customvalidator 才会显示是否已存在!