Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void button1_Click(object sender, EventArgs e)
- {
- aidentification.Text = rand.Next(1, 5).ToString();
- string exist = string.Empty;
- exist = "Select * from fruit_stock " +
- "where identification=@id";
- SqlConnection conn = new SqlConnection("server=WIN10;database=fruit_storage;user=fruit_admin;password=admin;");
- SqlCommand cmd = new SqlCommand()
- {
- Connection = conn,
- CommandType = CommandType.Text,
- CommandText = exist
- };
- cmd.Parameters.AddWithValue("@id", aidentification.Text);
- try
- {
- conn.Open();
- SqlDataReader reader;
- reader = cmd.ExecuteReader();
- if (reader.HasRows){
- // PUT THE CODE HERE TO PERFORM ANOTHER RANDOM NUMBERS
- }
- conn.Close();
- }
- catch (Exception ex) {
- MessageBox.Show(ex.Message);
- }
- }
- }
Add Comment
Please, Sign In to add comment