废话不多说了,直接给大家贴代码了。具体代码如下所示:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
|
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();
}
}
}
|
以上代码就是实现抽奖小程序的全部代码,代码简单易懂,写的不好还请见谅,有好的意见欢迎留言,谢谢大家一直以来对服务器之家网站的支持。