random number linked with images

Hey,

I am building a lottery website and have generated random numbers between 1-49. Each sets of numbers have a specific colour, the code i have used is shown below:-

protected void Button1_Click(object sender, EventArgs e)
{
int[] num = new int[6];
Random RandomClass = new Random();

do

{

num[0] = RandomClass.Next(1, 50);

num[1] = RandomClass.Next(1, 50);

num[2] = RandomClass.Next(1, 50);

num[3] = RandomClass.Next(1, 50);

num[4] = RandomClass.Next(1, 50);

num[5] = RandomClass.Next(1, 50);

}

while

(num[0] == num[1] || num[0] == num[2] || num[0] == num[3] || num[0] == num[4] || num[0] == num[5] ||

num[1] == num[2] || num[1] == num[3] || num[1] == num[4] || num[1] == num[5] ||

num[2] == num[3] || num[2] == num[4] || num[2] == num[5] ||

num[3] == num[4] || num[3] == num[5] ||

num[4] == num[5]);
Array.Sort(num);

txt_b1.Text = Convert.ToString(num[0]);
txt_b2.Text = Convert.ToString(num[1]);
txt_b3.Text = Convert.ToString(num[2]);
txt_b4.Text = Convert.ToString(num[3]);
txt_b5.Text = Convert.ToString(num[4]);txt_b6.Text = Convert.ToString(num[5]);
numbercolour(txt_b1, num[0]);

numbercolour(txt_b2, num[1]);

numbercolour(txt_b3, num[2]);

numbercolour(txt_b4, num[3]);

numbercolour(txt_b5, num[4]);

numbercolour(txt_b6, num[5]);

}

private void numbercolour(TextBox numbers, int hello)
{
if (hello < 10)
numbers.BackColor = System.Drawing.Color.White;
else if (hello < 20)
numbers.BackColor = System.Drawing.Color.Blue;
else if (hello < 30)
numbers.BackColor = System.Drawing.Color.Pink;
else if (hello < 40)
numbers.BackColor = System.Drawing.Color.Green;
else if (hello < 50)numbers.BackColor = System.Drawing.Color.Yellow;
}

Upon doing this i insert the values of the text boxes into a database using the following code:-

string conString = "Provider=Microsoft.Jet.OleDb.4.0;" + "Data Source=|DataDirectory|star_lottery.mdb;";
OleDbConnection empConnection = new OleDbConnection(conString);

string insertStatement = "INSERT INTO syndicate_members "

+ "([mem_name], [mem_id], [syn_id], [num1], [num2], [num3], [num4], [num5], [num6])"
+ "VALUES (@mem_name, @mem_id, @syn_id, @num1, @num2, @num3, @num4, @num5, @num6)";
OleDbCommand insertCommand = new OleDbCommand(insertStatement, empConnection);
insertCommand.Parameters.Add("@mem_name", OleDbType.Char).Value = txt_name.Text;
insertCommand.Parameters.Add("@mem_id", OleDbType.Char).Value = Session["mem_id"];
insertCommand.Parameters.Add("@syn_id", OleDbType.Char).Value = Session["syn_id"];
insertCommand.Parameters.Add("@num1", OleDbType.Char).Value = txt_b1.Text;
insertCommand.Parameters.Add("@num2", OleDbType.Char).Value = txt_b2.Text;
insertCommand.Parameters.Add("@num3", OleDbType.Char).Value = txt_b3.Text;
insertCommand.Parameters.Add("@num4", OleDbType.Char).Value = txt_b4.Text;
insertCommand.Parameters.Add("@num5", OleDbType.Char).Value = txt_b5.Text;
insertCommand.Parameters.Add("@num6", OleDbType.Char).Value = txt_b6.Text;
empConnection.Open();

try

{
int count = insertCommand.ExecuteNonQuery();Response.Redirect("mysyndicates_add.aspx");
}
catch (OleDbException ex)
{
Label10.Text = "<b style=color:red>Error, Try Again</b>";
}

finally

{

empConnection.Close();

}

HOWEVER..i have created 49 images of lottery balls in Photoshop linking with the colour of each ball number according to my code. What i want to do is when the random button is clicked, pull out the speicific image of the ball. so for example if i click on random and it displays the numbers 4,12,34,35,7, and 9 it will display the images of the balls i have if you know what i mean..? Then i want to insert the information into a database. So basically using exactly the same concept i have used here but instead of a text box i want to firstly display the relevant image of the ball when the random button is clicked, then i want to add the value into a database.

Any ideas? Sorry for the confusion

Thank You

Kind Regards [:)]

Re: random number linked with images

I assume you named those images in this manner: 1.jpg, 2.jpg, 3.jpg... and you saved them in "images" folder.
If that's the case, you can achieve your goal with this DataList:

        <asp:DataList ID="DataList1" runat="server" CellPadding="5" CellSpacing="5"
            RepeatColumns="6">
            <ItemStyle HorizontalAlign="Center" />
            <ItemTemplate>
                <asp:Image ID="Image1" runat="server" ImageUrl='<%# string.Format("~/images/{0}.jpg", Container.DataItem) %>' />
            </ItemTemplate>
        </asp:DataList>

and modify your code a bit(I made it simplier, you just need to add database inserting funcionality):

    protected void Button1_Click(object sender, EventArgs e)
    {
        int[] num = new int[6];
        Random RandomClass = new Random();
        ArrayList nums = new ArrayList();
        for (int i = 1; i < 50; i++)
        {
            nums.Add(i);
        }
        for (int i = 0; i < 6; i++)
        {
            num[i] = (int)nums[RandomClass.Next(1, 49 - i)];
            nums.Remove(num[i]);
        }
        DataList1.DataSource = num;
        DataList1.DataBind();
    }

Re: random number linked with images

Hey,

Thanks for a great reply, it worked perfectly. The only annoying thing was that all 49 images were made one by one!!

I have another question... once i click on random and it displays the images of the balls, how can i insert that value in the text boxes, so then i can insert the numbers into the database.

For example i have enabled users to put their desired numbers in manually or randomly, so if they do not put it manually, once random is clicked it shows the random ball images, AND puts the numbers into the textboxes...

my code now looks like so:

<table cellspacing="5">
<tr>

<td><asp:Label ID="Label1" runat="server" Text="Player Name"></asp:Label></td>

<td></td>

<td><asp:Label ID="Label2" runat="server" Text="Ball 1"></asp:Label></td>

<td><asp:Label ID="Label3" runat="server" Text="Ball 2"></asp:Label></td>

<td><asp:Label ID="Label4" runat="server" Text="Ball 3"></asp:Label></td>

<td><asp:Label ID="Label5" runat="server" Text="Ball 4"></asp:Label></td>

<td><asp:Label ID="Label6" runat="server" Text="Ball 5"></asp:Label></td>

<td><asp:Label ID="Label7" runat="server" Text="Ball 6"></asp:Label></td>

</tr>

<tr>
<td><asp:TextBox ID="txt_name" runat="server"></asp:TextBox></td>
<td><asp:RequiredFieldValidator ID="RequiredFieldValidator8" runat="server"
ErrorMessage="*" ControlToValidate="txt_name"></asp:RequiredFieldValidator></td>
<td><asp:TextBox ID="txt_b1" runat="server" Width="29px"></asp:TextBox></td>

<td><asp:TextBox ID="txt_b2" runat="server" Width="29px"></asp:TextBox></td>

<td><asp:TextBox ID="txt_b3" runat="server" Width="29px"></asp:TextBox></td>

<td><asp:TextBox ID="txt_b4" runat="server" Width="29px"></asp:TextBox></td>

<td><asp:TextBox ID="txt_b5" runat="server" Width="29px"></asp:TextBox></td>

<td><asp:TextBox ID="txt_b6" runat="server" Width="29px"></asp:TextBox></td>
<td><asp:Button ID="Button1" runat="server" Text="Random" onclick="Button1_Click" /></td>

</tr>

<tr>

<td></td>

<td></td>
<td><asp:RangeValidator ID="RangeValidator1" runat="server" ErrorMessage="Invalid"
ControlToValidate="txt_b1" MaximumValue="49" MinimumValue="1" Type="Integer"></asp:RangeValidator></td>
<td><asp:RangeValidator ID="RangeValidator2" runat="server" ErrorMessage="Invalid"
ControlToValidate="txt_b2" MaximumValue="49" MinimumValue="1" Type="Integer"></asp:RangeValidator></td>

<td><asp:RangeValidator ID="RangeValidator3" runat="server" ErrorMessage="Invalid"
ControlToValidate="txt_b3" MaximumValue="49" MinimumValue="1" Type="Integer"></asp:RangeValidator></td>

<td><asp:RangeValidator ID="RangeValidator4" runat="server" ErrorMessage="Invalid"
ControlToValidate="txt_b4" MaximumValue="49" MinimumValue="1" Type="Integer"></asp:RangeValidator></td>

<td><asp:RangeValidator ID="RangeValidator5" runat="server" ErrorMessage="Invalid"
ControlToValidate="txt_b5" MaximumValue="49" MinimumValue="1" Type="Integer"></asp:RangeValidator></td>

<td><asp:RangeValidator ID="RangeValidator6" runat="server" ErrorMessage="Invalid"
ControlToValidate="txt_b6" MaximumValue="49" MinimumValue="1" Type="Integer"></asp:RangeValidator></td>

</tr>

</table>

<table cellspacing="5">

<tr>
<td><asp:Button ID="Button3" runat="server" Text="Add & Continue"
onclick="Button3_Click" /></td>
<td><asp:Button ID="Button2" runat="server" Text="Add & Finish"
onclick="Button2_Click" /></td>

<td><asp:Button ID="Button4" runat="server" Text="Test" onclick="Button4_Click" /></td>

<td><asp:Label ID="Label10" runat="server" Text=""></asp:Label></td></tr>

</table>

<asp:DataList ID="DataList1" runat="server" CellPadding="5" CellSpacing="5"
RepeatColumns="6">

<ItemStyle HorizontalAlign="Center" />

<ItemTemplate>

<asp:Image ID="Image1" runat="server" ImageUrl='<%# string.Format("~/balls/{0}.jpg", Container.DataItem) %>' />

</ItemTemplate>

</asp:DataList>

Thank You again.

Regards

Re: random number linked with images

You can use your own code:

    protected void Button1_Click(object sender, EventArgs e)
    {
        int[] num = new int[6];
        Random RandomClass = new Random();
        ArrayList nums = new ArrayList();
        for (int i = 1; i < 50; i++)
        {
            nums.Add(i);
        }
        for (int i = 0; i < 6; i++)
        {
            num[i] = (int)nums[RandomClass.Next(1, 49 - i)];
            nums.Remove(num[i]);
        }
        DataList1.DataSource = num;
        DataList1.DataBind();
        txt_b1.Text = Convert.ToString(num[0]);
        txt_b2.Text = Convert.ToString(num[1]);
        txt_b3.Text = Convert.ToString(num[2]);
        txt_b4.Text = Convert.ToString(num[3]);
        txt_b5.Text = Convert.ToString(num[4]);
        txt_b6.Text = Convert.ToString(num[5]);
    }

Re: random number linked with images

[:D] Thank You, your a legend! I now have one final question sorry...

I want to retrieve the winning lottery numbers from the national lottery website from the following RSS feed:-

http://www.schok.co.uk/lottery/lottery.xml

I have the following code so far:

        <asp:XmlDataSource ID="XmlDataSource1" runat="server"
            DataFile="http://www.schok.co.uk/lottery/lottery.xml"
            XPath="rss/channel/item[position()<=1]"></asp:XmlDataSource>

However what i want to do is ONLY select the winning numbers and not the other text. I want to use the first feed which will say something on the lines of:-

The Main UK Lottery Draw Numbers for 03-01-2009
05 January 2009 02:00
Draw date 03-01-2009 Draw numbers are 39 , 37 , 19 , 49 , 9 and 36 - The bonus ball is 10 , Ball set 6 , Draw machine is TOPAZ

I want to select JUST the numbers and then check them against a database of numbers which users have entered numbers into. I have done some research and the best way seems to be parse string using string.split..? but i really dont know where to begin.

Thank You

Sorry for all the questions

Kind Regards

Re: random number linked with images

You can try with this code (this example is done with LINQ, so you'll have to use ASP.NET 3.5):

            XElement xEl = XElement.Load("http://www.schok.co.uk/lottery/lottery.xml");
            CultureInfo info = new CultureInfo("en-US");
            var lastDraw = (from p in xEl.Descendants("item")
                            orderby DateTime.ParseExact(p.Element("pubDate").Value.Substring(5, 20), "dd MMM yyyy HH:mm:ss", info) descending
                            select p.Element("description").Value).FirstOrDefault();
            if (lastDraw != null)
            {
                string[] lastDrawLetters = lastDraw.Split(' ');
                ArrayList nums = new ArrayList();
                for (int i = 0; i < lastDrawLetters.Count(); i++)
                {
                    double j = 0;
                    if (double.TryParse(lastDrawLetters[i], out j))
                    {
                        nums.Add(j);
                        //This line is just for testing:
                        Response.Write(j + "<br/>");
                    }
                }
            }

Re: random number linked with images

Cheers, would i need to add a namespace at the top?

I am getting the following errors:-

Error 2 The type or namespace name 'CultureInfo' could not be found (are you missing a using directive or an assembly reference?)

Error 5 Argument '2': cannot convert from 'lambda expression' to 'System.Func<System.Xml.Linq.XElement,System.DateTime>

Error 4 'System.Collections.Generic.IEnumerable<System.Xml.Linq.XElement>' does not contain a definition for 'OrderByDescending' and the best extension method overload 'System.Linq.Enumerable.OrderByDescending<TSource,TKey>(System.Collections.Generic.IEnumerable<TSource>, System.Func<TSource,TKey>)' has some invalid arguments

Re: random number linked with images

Yes, you'll need the following:

using System.Linq;
using System.Xml.Linq;
using System.Globalization;
using System.Collections;

Re: random number linked with images

Hey,

It is working but it is getting the wrong RSS feed...

the one i need is

The Main UK Lottery Draw Numbers for 03-01-2009

however it is now showing

Daily play lottery Results for 03-01-2009

Also to test it instead of using response.write can i use the following?

Label1.Text = j; (or something on the same lines as this)

Again thank you, really appreciate your help.

Regards

Re: random number linked with images

That last code was pulling values from the top feed. This one will pull the values from the feed which title starts with "The Main UK Lottery". And I replaced the part responsible for showing the data on the screen with the Label:

            XElement xEl = XElement.Load("http://www.schok.co.uk/lottery/lottery.xml");
            var lastDraw = (from p in xEl.Descendants("item")
                            where p.Element("title").Value.StartsWith("The Main UK Lottery")
                            select p.Element("description").Value).FirstOrDefault();
            if (lastDraw != null)
            {
                string[] lastDrawLetters = lastDraw.Split(' ');
                ArrayList nums = new ArrayList();
                for (int i = 0; i < lastDrawLetters.Count(); i++)
                {
                    double j = 0;
                    if (double.TryParse(lastDrawLetters[i], out j))
                    {
                        nums.Add(j);
                        Label1.Text += j + "<br/>";
                    }
                }
            }

Re: random number linked with images

Thanks the feed is now showing the 6 winning numbers and the bonus ball, but it is also showing the ball set which i dont really need, can i take the ball set number out?

XElement xEl = XElement.Load("http://www.schok.co.uk/lottery/lottery.xml");
var lastDraw = (from p in xEl.Descendants("item")
where p.Element("title").Value.StartsWith("The Main UK Lottery")
select p.Element("description").Value).FirstOrDefault();
if (lastDraw != null)
{
string[] lastDrawLetters = lastDraw.Split(' ');
ArrayList nums = new ArrayList();
Label1.Text = "The winning numbers for this week are: ";for (int i = 0; i < lastDrawLetters.Count(); i++)
{

double j = 0;
if (double.TryParse(lastDrawLetters[i], out j))
{

nums.Add(j);
Label3.Text += j + ", ";
//Response.Write(j + ", ");

}

}

}

Regards

Re: random number linked with images

If the number of the winning numbers will always be the same, you can use this:

            XElement xEl = XElement.Load("http://www.schok.co.uk/lottery/lottery.xml");
            var lastDraw = (from p in xEl.Descendants("item")
                            where p.Element("title").Value.StartsWith("The Main UK Lottery")
                            select p.Element("description").Value).FirstOrDefault();
            if (lastDraw != null)
            {
                string[] lastDrawLetters = lastDraw.Split(' ');
                ArrayList nums = new ArrayList();
                for (int i = 0; i < lastDrawLetters.Count(); i++)
                {
                    double j = 0;
                    if (double.TryParse(lastDrawLetters[i], out j))
                    {
                        if (nums.Count < 7)
                        {
                            nums.Add(j);
                            Label1.Text += j + ", ";
                        }
                    }
                }
                Label1.Text = Label1.Text.Remove(Label1.Text.LastIndexOf(","));
            }

Re: random number linked with images

Thanks, would i be able to check the numbers against a database? Is it possible to do this with the example below..?

numbersTableAdapters.numbersTableAdapter num = new
numbersTableAdapters.numbersTableAdapter();
numbers.numbersDataTable numtable = num.GetNumbers();
Label2.Text = "";
foreach (DataRow row in numtable.Rows)
if (TextBox1.Text == System.Convert.ToString(row["number1"]))
{
Label2.Text = Label2.Text + " Mr " + System.Convert.ToString(row["name"])+ ", you have won<BR>";
}

Also the following code:-

for (int i = 0; i < lastDrawLetters.Count(); i++)
{
double j = 0;if (double.TryParse(lastDrawLetters[i], out j))
{
if (nums.Count < 7)
{

nums.Add(j);
Label1.Text += j + ", ";
}
if (nums.Count == 7)
{

nums.Add(j);
Label3.Text += ", and the bonus ball is " + j;
}

}
}

shows

The winning numbers for this week are: 39, 37, 19, 49, 9, 36, 10 , and the bonus ball is 10

Can i remove the first duplicate 10 by any chace?

Regards

Re: random number linked with images

For the first question, you will instead of this:

if (TextBox1.Text == System.Convert.ToString(row["number1"]))

use something like this:

if (nums[0].ToString() == row["number1"].ToString())

And this code will resolve your second question:

            XElement xEl = XElement.Load("http://www.schok.co.uk/lottery/lottery.xml");
            var lastDraw = (from p in xEl.Descendants("item")
                            where p.Element("title").Value.StartsWith("The Main UK Lottery")
                            select p.Element("description").Value).FirstOrDefault();
            if (lastDraw != null)
            {
                string[] lastDrawLetters = lastDraw.Split(' ');
                ArrayList nums = new ArrayList();
                for (int i = 0; i < lastDrawLetters.Count(); i++)
                {
                    double j = 0;
                    if (double.TryParse(lastDrawLetters[i], out j))
                    {
                        if (nums.Count < 6)
                        {
                            nums.Add(j);
                            Label1.Text += j + ", ";
                        }
                        else if (nums.Count == 6)
                        {
                            nums.Add(j);
                            Label1.Text = Label1.Text.Remove(Label1.Text.LastIndexOf(","));
                            Label1.Text += " and the bonus ball is " + j;
                        }
                    }
                }
            }

Re: random number linked with images

Hey,

Im trying to check the numbers with the database but it is not showing anything.. code is below

XElement xEl = XElement.Load("http://www.schok.co.uk/lottery/lottery.xml");
var lastDraw = (from p in xEl.Descendants("item")
where p.Element("title").Value.StartsWith("The Main UK Lottery")
select p.Element("description").Value).FirstOrDefault();
if (lastDraw != null)
{
string[] lastDrawLetters = lastDraw.Split(' ');
ArrayList nums = new ArrayList();

numbersTableAdapters.syndicate_membersTableAdapter num = new
numbersTableAdapters.syndicate_membersTableAdapter();
numbers.syndicate_membersDataTable numtable = num.GetNumbers();
Label1.Text = "";
Label1.Text = "The winning numbers for this week are: ";
for (int i = 0; i < lastDrawLetters.Count(); i++)
{
double j = 0;if (double.TryParse(lastDrawLetters[i], out j))
{
if (nums.Count < 6)
{

nums.Add(j);
Label1.Text += j + ", ";
}
else if (nums.Count == 6)
{

nums.Add(j);
Label1.Text = Label1.Text.Remove(Label1.Text.LastIndexOf(","));Label1.Text += " and the bonus ball is " + j;
}

foreach (DataRow row in numtable.Rows)
if (nums[0].ToString() == row["num1"])
{
Label3.Text = Label3.Text + "Congratulations " + System.Convert.ToString(row["mem_name"])+ ", you have won<BR>";
}

Label 3 is not showing anything, it is staying blank...

Regards

Re: random number linked with images

I am now trying to use the following:-

protected void Page_Load(object sender, EventArgs e)
{
XElement xEl = XElement.Load("http://www.schok.co.uk/lottery/lottery.xml");
var lastDraw = (from p in xEl.Descendants("item")
where p.Element("title").Value.StartsWith("The Main UK Lottery")
select p.Element("description").Value).FirstOrDefault();
if (lastDraw != null)
{
string[] lastDrawLetters = lastDraw.Split(' ');
ArrayList nums = new ArrayList();

numbersTableAdapters.syndicate_membersTableAdapter num = new
numbersTableAdapters.syndicate_membersTableAdapter();
numbers.syndicate_membersDataTable numtable = num.GetNumbers();
Label1.Text = "The winning numbers for this week are: ";for (int i = 0; i < lastDrawLetters.Count(); i++)
{

double j = 0;
if (double.TryParse(lastDrawLetters[i], out j))
{
if (nums.Count < 6)
{

nums.Add(j);
Label1.Text += j + ", ";
}
else if (nums.Count == 6)
{

nums.Add(j);
Label1.Text = Label1.Text.Remove(Label1.Text.LastIndexOf(","));Label1.Text += " and the bonus ball is " + j;
}

foreach (DataRow row in numtable.Rows)
if (nums[0] == row["num1"].ToString())
{
Label3.Text = Label3.Text + "Congratulations " + System.Convert.ToString(row["mem_name"])+ ", you have won<BR>";
}

else

{
Label3.Text = "<b style ='color:red'>Sorry, unfortunately you have no winners.</b>";GridView1.Visible = false;
}

}

}

}

But the label is still showing as blank, it does not show who has got a matching number..

Regards

Re: random number linked with images

You should check do you get any result in "numtable". Second, this line:

if(nums[0].ToString() == row["num1"].ToString())

will check is the first drawn number same as number in "num1" column. You should check if that is a logic you want.

Re: random number linked with images

Hey,

The logic should work but i think the following line:-

if (nums[0].ToString() == row["num1"].ToString())

is not checking the correct line, I have checked the Dataset that i have made and it does have a column called "num1". Eventually i will check for all 6 columns but i thought i could do the first one before doing this.

if (nums[0].ToString() == row["num1"].ToString())
{
Label3.Text = Label3.Text + "Congratulations " + System.Convert.ToString(row["mem_name"])+ ", you have won<BR>";
}

I think there is obviously something wrong with the If statement, because it should atleast say "Congratulations " even though it may not recognise row["num1"]..

Any ideas

Regards

Re: random number linked with images

If you didn't get the text "Sorry, unfortunately you have no winners.", that means that you don't have any data in "numtable". You can check that if you set breakpoint in Visual Studio, or, if you're not farmiliar with breakpoints, add Gridview to your page and add this code:

GridView1.DataSource = numtable;
GridView1.DataBind();

after this line

numbers.syndicate_membersDataTable numtable = num.GetNumbers();

Re: random number linked with images

Hey,

I do get the text "Sorry, unfortunately you have no winners.", so this means i have data in numtable.

However i have just tried the code you suggested and it gives the following error:-

Both DataSource and DataSourceID are defined on 'GridView1'. Remove one definition.