Guest User

Untitled

a guest
Dec 1st, 2017
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.24 KB | None | 0 0
  1. private void button1_Click(object sender, EventArgs e)
  2. {
  3. aidentification.Text = rand.Next(1, 5).ToString();
  4. string exist = string.Empty;
  5. exist = "Select * from fruit_stock " + "where identification=@id";
  6.  
  7. SqlConnection conn = new SqlConnection("server=WIN10;database=fruit_storage;user=fruit_admin;password=admin;");
  8. SqlCommand cmd = new SqlCommand()
  9. {
  10. Connection = conn,
  11. CommandType = CommandType.Text,
  12. CommandText = exist
  13.  
  14. };
  15. cmd.Parameters.AddWithValue("@id", aidentification.Text);
  16. try
  17. {
  18. conn.Open();
  19. SqlDataReader reader;
  20. reader = cmd.ExecuteReader();
  21. if (reader.HasRows){
  22. // PUT THE CODE HERE TO PERFORM ANOTHER RANDOM NUMBERS
  23. }
  24. conn.Close();
  25. }
  26. catch (Exception ex) {
  27. MessageBox.Show(ex.Message);
  28. }
  29.  
  30. }
  31.  
  32. CREATE TABLE fruitInStock
  33. (
  34. id int IDENTITY(1,1),
  35. fruitname varchar (20), -- this should be a FK into a fruits table
  36. amountOf int NOT NULL
  37. -- more fields
  38. );
  39.  
  40. INSERT fruitInStock
  41. (fruitname , amountOf )
  42. VALUES
  43. ('Apple', 20),
  44. ('Pear', 10),
  45. ('Kiwi', 2000)
  46. ;
  47.  
  48. SELECT * from fruitInStock
  49.  
  50. id fruitname amountOf
  51. 1 Apple 20
  52. 2 Pear 10
  53. 3 Kiwi 2000
Add Comment
Please, Sign In to add comment