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