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