CustomValidator无效???
控件:<asp:CustomValidator ID="Ctv_TextProName" runat="server" ControlToValidate="TextProName" ErrorMessage="该项目已存在,请重新输入!" OnServerValidate="Ctv_TextProName_ServerValidate"></asp:CustomValidator>
后台相关代码:protected void Ctv_TextProName_ServerValidate(object source, ServerValidateEventArgs args)
{
string connstr = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
OracleConnection Conn = new OracleConnection();
string sql = "SELECT * FROM pro_tab where proname='" + TextProName.Text.Trim() + "'";
Conn.ConnectionString = connstr;
Conn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = Conn;
cmd.CommandText = sql;
OracleDataReader odr = cmd.ExecuteReader();
if (odr.HasRows)
{
args.IsValid = false;
}
else
{
args.IsValid = true;
}
odr.Close();
Conn.Close();
}
预期实现功能:验证项目名的唯一性,当出现相同的项目名称时则提示,但是效果却没有达到,一样还是添加成功了。请问是什么原因,该如何修改?我用的是ASP.NET 2.0(C#),数据库是Oracle;