User account already exists using Customvalidator

[Dave]

I've suprisingly not been able to find examples on this. I'm creating
a user account setup page, and the validators work fine on all the
other fields. But now I'm creating a customvalidator (for the first
time) and it is not doing anything. The page needs to see if a
username already exists. Am I doing this right?
<asp:textbox TabIndex="1" ID="tLogin" MaxLength="40" runat="server" />
<asp:customvali dator id="Customvalid ator1" runat="server"
EnableClientScr ipt="False" Font-Bold="True" ErrorMessage="U sername
already exists." ControlToValida te="tLogin"
OnServerValidat e="CheckUser" Display="Dynami c"/>

void CheckUser(objec t source,
System.Web.UI.W ebControls.Serv erValidateEvent Args args)
{
TextBox b;
b = fLogin.FindCont rol("tLogin") as TextBox;
String lg = b.Text;
String strConn = "PROVIDER=Micro soft.Jet.OLEDB. 4.0;DATA
SOURCE=" + Server.MapPath( "info.mdb") + ";";
OleDbConnection Conn = new OleDbConnection (strConn);
Conn.Open();
String strSQL = "SELECT * FROM Customers WHERE Login = '" + lg
+ "'";
OleDbCommand Cmd = new OleDbCommand(st rSQL, Conn);
OleDbDataReader Dr =
Cmd.ExecuteRead er(System.Data. CommandBehavior .CloseConnectio n);
if (Dr.HasRows)
{
args.IsValid = false;
} else args.IsValid = true;
Conn.Close();
}

[bruce barker]

does your codebehind call Page.Validate?
-- bruce (sqlwork.com)

Dave wrote:

I've suprisingly not been able to find examples on this. I'm creating
a user account setup page, and the validators work fine on all the
other fields. But now I'm creating a customvalidator (for the first
time) and it is not doing anything. The page needs to see if a
username already exists. Am I doing this right?
<asp:textbox TabIndex="1" ID="tLogin" MaxLength="40" runat="server" />
<asp:customvali dator id="Customvalid ator1" runat="server"
EnableClientScr ipt="False" Font-Bold="True" ErrorMessage="U sername
already exists." ControlToValida te="tLogin"
OnServerValidat e="CheckUser" Display="Dynami c"/>

void CheckUser(objec t source,
System.Web.UI.W ebControls.Serv erValidateEvent Args args)
{
TextBox b;
b = fLogin.FindCont rol("tLogin") as TextBox;
String lg = b.Text;
String strConn = "PROVIDER=Micro soft.Jet.OLEDB. 4.0;DATA
SOURCE=" + Server.MapPath( "info.mdb") + ";";
OleDbConnection Conn = new OleDbConnection (strConn);
Conn.Open();
String strSQL = "SELECT * FROM Customers WHERE Login = '" + lg
+ "'";
OleDbCommand Cmd = new OleDbCommand(st rSQL, Conn);
OleDbDataReader Dr =
Cmd.ExecuteRead er(System.Data. CommandBehavior .CloseConnectio n);
if (Dr.HasRows)
{
args.IsValid = false;
} else args.IsValid = true;
Conn.Close();
}

[Dave]

On Jun 22, 2:27 pm, bruce barker <nos...@nospam. comwrote:

does your codebehind call Page.Validate?

-- bruce (sqlwork.com)

Dave wrote:

I've suprisingly not been able to find examples on this. I'm creating
a user account setup page, and the validators work fine on all the
other fields. But now I'm creating a customvalidator (for the first
time) and it is not doing anything. The page needs to see if a
username already exists. Am I doing this right?

<asp:textbox TabIndex="1" ID="tLogin" MaxLength="40" runat="server" />
<asp:customvali dator id="Customvalid ator1" runat="server"
EnableClientScr ipt="False" Font-Bold="True" ErrorMessage="U sername
already exists." ControlToValida te="tLogin"
OnServerValidat e="CheckUser" Display="Dynami c"/>

void CheckUser(objec t source,
System.Web.UI.W ebControls.Serv erValidateEvent Args args)
{
TextBox b;
b = fLogin.FindCont rol("tLogin") as TextBox;
String lg = b.Text;
String strConn = "PROVIDER=Micro soft.Jet.OLEDB. 4.0;DATA
SOURCE=" + Server.MapPath( "info.mdb") + ";";
OleDbConnection Conn = new OleDbConnection (strConn);
Conn.Open();
String strSQL = "SELECT * FROM Customers WHERE Login = '" + lg
+ "'";
OleDbCommand Cmd = new OleDbCommand(st rSQL, Conn);
OleDbDataReader Dr =
Cmd.ExecuteRead er(System.Data. CommandBehavior .CloseConnectio n);
if (Dr.HasRows)
{
args.IsValid = false;
} else args.IsValid = true;
Conn.Close();
}- Hide quoted text -

- Show quoted text -

No.

[Dave]

Actually even when I set the custom event handler to just return
false, it still does not kick in with the error message. Why isn't it
doing anything? Any help would be appreciated.

[Dave]

Nevermind, I gave up on the server side customvalidator and placed the
query code in the submit button handler.

[=?Utf-8?B?U2VyZ2V5IFp1eWV2?=]

Custom Validator ServerValidate event will not fire if text is empty. By
default ValidateEmptyTe xt property is set to False. Set it to true and try
again.
--
Programmer
"Dave" wrote:

I've suprisingly not been able to find examples on this. I'm creating
a user account setup page, and the validators work fine on all the
other fields. But now I'm creating a customvalidator (for the first
time) and it is not doing anything. The page needs to see if a
username already exists. Am I doing this right?
<asp:textbox TabIndex="1" ID="tLogin" MaxLength="40" runat="server" />
<asp:customvali dator id="Customvalid ator1" runat="server"
EnableClientScr ipt="False" Font-Bold="True" ErrorMessage="U sername
already exists." ControlToValida te="tLogin"
OnServerValidat e="CheckUser" Display="Dynami c"/>

void CheckUser(objec t source,
System.Web.UI.W ebControls.Serv erValidateEvent Args args)
{
TextBox b;
b = fLogin.FindCont rol("tLogin") as TextBox;
String lg = b.Text;
String strConn = "PROVIDER=Micro soft.Jet.OLEDB. 4.0;DATA
SOURCE=" + Server.MapPath( "info.mdb") + ";";
OleDbConnection Conn = new OleDbConnection (strConn);
Conn.Open();
String strSQL = "SELECT * FROM Customers WHERE Login = '" + lg
+ "'";
OleDbCommand Cmd = new OleDbCommand(st rSQL, Conn);
OleDbDataReader Dr =
Cmd.ExecuteRead er(System.Data. CommandBehavior .CloseConnectio n);
if (Dr.HasRows)
{
args.IsValid = false;
} else args.IsValid = true;
Conn.Close();
}