random number linked with images RSS

• • Reply
  

  billy_111

  Member

  333 Points

  878 Posts

  random number linked with images

  Jan 03, 2009 05:02 AM|LINK

  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 [:)]

• • Reply
  

  kipo

  All-Star

  16475 Points

  2811 Posts

  Re: random number linked with images

  Jan 03, 2009 10:42 AM|LINK

  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();
      }

  • Edited by kipo on Jan 03, 2009 10:44 AM
  • Edited by kipo on Jan 03, 2009 10:47 AM
  • Marked as answer by billy_111 on Jan 05, 2009 12:04 AM
• • Reply
  

  billy_111

  Member

  333 Points

  878 Posts

  Re: random number linked with images

  Jan 05, 2009 12:39 AM|LINK

  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

• • Reply
  

  kipo

  All-Star

  16475 Points

  2811 Posts

  Re: random number linked with images

  Jan 05, 2009 06:46 AM|LINK

  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]);
      }

  • Marked as answer by billy_111 on Jan 05, 2009 12:08 PM
• • Reply
  

  billy_111

  Member

  333 Points

  878 Posts

  Re: random number linked with images

  Jan 05, 2009 12:05 PM|LINK

  [: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()&lt;=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
  

   

• • Reply
  

  kipo

  All-Star

  16475 Points

  2811 Posts

  Re: random number linked with images

  Jan 05, 2009 02:40 PM|LINK

  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/>");
                      }
                  }
              }

• • Reply
  

  billy_111

  Member

  333 Points

  878 Posts

  Re: random number linked with images

  Jan 05, 2009 02:48 PM|LINK

  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
  
  

• • Reply
  

  kipo

  All-Star

  16475 Points

  2811 Posts

  Re: random number linked with images

  Jan 05, 2009 03:02 PM|LINK

  Yes, you'll need the following:

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

• • Reply
  

  billy_111

  Member

  333 Points

  878 Posts

  Re: random number linked with images

  Jan 06, 2009 12:29 AM|LINK

  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

• • Reply
  

  kipo

  All-Star

  16475 Points

  2811 Posts

  Re: random number linked with images

  Jan 06, 2009 10:35 AM|LINK

  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/>";
                      }
                  }
              }

  • Edited by kipo on Jan 06, 2009 10:37 AM