using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace ChouJiang
{
 public partial class Form1 : Form
 {
 public Form1()
 {
 InitializeComponent();
 }
private void button1_Click(object sender, EventArgs e)
 {
 int number = Convert.ToInt32(textBox1.Text.ToString());
 string prize=comboBox1.Text.ToString();
 string conn = "";
 string sql = "";
 string s = "";
 conn = "server=XTFLZ-PC;database=Xtf;uid=sa;pwd=123456";
 sql = "select *from Ticket";
 SqlConnection myconn = new SqlConnection(conn);
 myconn.Open();
 SqlDataAdapter sda = new SqlDataAdapter(sql,myconn);
 DataSet ds=new DataSet();
 sda.Fill(ds,"Ticket");
 dataGridView11.DataSource = ds;
 dataGridView11.DataMember = "Ticket";
 Random rd = new Random();
 for (int i = 0; i < number; i++)
 {
 int tmp = rd.Next(1, 5);
 s += dataGridView11.Rows[i].Cells["WorkerID"].Value.ToString() +
 dataGridView11.Rows[i].Cells["Name"].Value.ToString() + "\n";
 }
 MessageBox.Show("恭喜\n"+s+"\n獲得"+prize);
 myconn.Close();
 }
 }
}