Trying to make validation prevent invalid input to database, not working

Question

I'm trying to make a user registration form with the fields Name, Student ID, Year of Birth, Gender, Email Address and Password that is inputted into a Microsoft Access database. There is validation in place so that if, say, the password is less than 8 characters long, the user can't proceed unless it's changed.

But it's not working. The validation messages don't appear, except on the Email Address one which appears after tabbing away from the text field, and despite that invalid data can still be saved into the database. I cannot figure out why.

This is my HTML code:

And this is my C# code:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;


namespace APUBadmintonSportsClubWebsite
{
public partial class WebForm1 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //append item to the collection
        for (int i = 1900; i <= 2007; i++)
            this.DropDownList2.Items.Add(i.ToString());
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        //formulate a string containing the details of 
        //the database connection
        string connectionString = "provider=Microsoft.Ace.OleDB.12.0;"
            + "data source="
            + Page.Server.MapPath("App_Data\ABC.accdb");

        //create a OIeDbConnection object to connect to the database
        System.Data.OleDb.OleDbConnection conn = new
        System.Data.OleDb.OleDbConnection(connectionString);

        //create a OleDbCommand object
        System.Data.OleDb.OleDbCommand cmd = conn.CreateCommand();

        // add a collection of parameters associated with a OIeDbCommand

        cmd.Parameters.Add("StudentID", System.Data.OleDb.OleDbType.VarChar);
        cmd.Parameters["StudentID"].Value = this.TextBox2.Text;

        cmd.Parameters.Add("StudentName", System.Data.OleDb.OleDbType.VarChar);
        cmd.Parameters["StudentName"].Value = this.TextBox1.Text;

        cmd.Parameters.Add("YearBorn", System.Data.OleDb.OleDbType.VarChar);
        cmd.Parameters["YearBorn"].Value = this.DropDownList2.Text;

        cmd.Parameters.Add("Gender", System.Data.OleDb.OleDbType.VarChar);
        cmd.Parameters["Gender"].Value = this.DropDownList1.Text;

        cmd.Parameters.Add("StudentMail", System.Data.OleDb.OleDbType.VarChar);
        cmd.Parameters["StudentMail"].Value = this.TextBox4.Text;

        cmd.Parameters.Add("Password", System.Data.OleDb.OleDbType.VarChar);
        cmd.Parameters["Password"].Value = this.TextBox6.Text;

        // set the commandText property of the OleDbCommand object to
        // the INSERT statement
        cmd.CommandText = "INSERT INTO [Members] ([StudentID],[StudentName],[YearBorn],[Gender],[StudentMail],[Password]) VALUES (@StudentID,@StudentName,@YearBorn,@Gender,@StudentMail,@Password)";


        //open the database connection using the open() method of the OleDbConnection object
        conn.Open();

        //call the ExcuteNonQuery() method of the OleDbCommand object 
        //to run the INSERT statement
        int numberOfRows = cmd.ExecuteNonQuery(); //exception here when inserting duplicate data

        //close the OleDbConnection object using using the Close () method 
        conn.Close();

        if (Page.IsValid)
        {

        }

        //redirect to View.aspx
        Response.Redirect("Home.aspx");
    }

    protected void CustomValidator1_ServerValidate(object source, ServerValidateEventArgs args)
    {
        if (args.Value.Length < 8)
            args.IsValid = false;
        else
            args.IsValid = true;
    }

    protected void CustomValidator2_ServerValidate(object source, ServerValidateEventArgs args)
    {
        if (args.Value.Length < 8)
            args.IsValid = false;
        else
            args.IsValid = true;
    }

    protected void CustomValidator3_ServerValidate(object source, ServerValidateEventArgs args)
    {
        if (DropDownList1.SelectedValue == "0") //want to select text of drop down selection
            args.IsValid = false;
        else
            args.IsValid = true;
    }

}
}

Any help is appreciated, and I'll fill in more details if needed.

Trying to make validation prevent invalid input to database, not working

Answers (1)

Related Questions