asp.net help!

[andrew_biggart]

Ok what I am trying to do is search a database to check for 6 numbers in any order for a lottery syndicate. so far i have got it working but the numbers have to be in the right order, i would like it to work when the numbers are checked in any order how do i go about do that with a if statement?

 

so far i have this

 

    protected void Button3_Click(object sender, EventArgs e)

    {

        numbersTableAdapters.BallsTableAdapter num = new

          numbersTableAdapters.BallsTableAdapter();

        numbers.BallsDataTable numtable = num.GetNumbers();

 

        Label7.Text = "";

 

        foreach (DataRow row in numtable.Rows)

            if (Label1.Text == System.Convert.ToString(row["Ball1"]) && Label2.Text == System.Convert.ToString(row["Ball2"]) && Label3.Text == System.Convert.ToString(row["Ball3"]) && Label4.Text == System.Convert.ToString(row["Ball4"]) && Label5.Text == System.Convert.ToString(row["Ball5"]) && Label6.Text == System.Convert.ToString(row["Ball6"]))

            {

                Label7.Text = "Mr " + System.Convert.ToString(row["LastName"]) + ", you have won";

            }

    }

}