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[tmp].Cells["WorkerID"].Value.ToString() +
dataGridView11.Rows[tmp].Cells["Name"].Value.ToString() + "/n";
}
MessageBox.Show("恭喜/n"+s+"/n獲得"+prize);
myconn.Close();
}
}
}