C#关于一个随机点名的代码

这是一个使用C#编写的Windows应用程序,通过按钮触发一个线程来实现随机点名功能。程序创建了一个线程`t1`,在点击按钮时启动,随机从预设的名字数组中选择一个显示在标签`label2`上。每点击一次按钮,点名列表会滚动,直到用户点击停止按钮,此时被点中的名字将显示在另一个标签中。此外,程序还包含退出应用和锁定工作站的功能。
摘要由CSDN通过智能技术生成

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Threading;


namespace WindowsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
            Control.CheckForIllegalCrossThreadCalls = false;
        }

        private void Form1_Load(object sender, EventArgs e)
        {
           
        }

        int i = 1;
        //声名线程
        Thread t1;
        private void button1_Click(object sender, EventArgs e)
        {
            t1 = new Thread(new Mylabel(this.label2).setLabel);
            t1.Start();
            //主线程等待时间
            t1.Join(10);<

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace 随机点名器 { public partial class Form2 : Form { public Form2() { InitializeComponent(); } string a = ""; private void Form2_Load(object sender, EventArgs e) { // TODO: 这行代码将数据加载到表“dataSet1.学生信息”中。您可以根据需要移动或删除它。 // this.学生信息TableAdapter.Fill(this.dataSet1.学生信息); } private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { } private void button1_Click(object sender, EventArgs e) { String constr = "Server = 10.100.102.3;user id = dotnet;pwd = 123;database = wgz"; //String constr = @"data source = .;user id = ;pwd = ;database = TEST"; SqlConnection con = new SqlConnection(); con.ConnectionString = constr; con.Open(); // string dianming = "SELECT top 1 [学号] FROM [学生信息] ORDER BY NEWID()"; string sql = "SELECT top 1 * FROM [学生信息] ORDER BY NEWID()"; SqlDataAdapter da = new SqlDataAdapter(sql, con); DataSet ds = new DataSet(); da.Fill(ds, "cs"); dataGridView1.DataSource = ds.Tables["cs"]; a = ds.Tables[0].Rows[0][1].ToString(); con.Close(); } private void button2_Click(object sender, EventArgs e) { string b = a; String constr = "Server = 10.100.102.3;user id = dotnet;pwd = 123;database = wgz"; SqlConnection con = new SqlConnection(); con.ConnectionString = constr; con.Open(); string chuqin = "update [学生信息] set [出勤]=[出勤]+1 where [学号]='"+b+"'"; SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = chuqin; int i1 = cmd.ExecuteNonQuery(); string chuli = "update [学生信息] set [平时成绩] = [平时成绩] + 3 where [学号]='" + b + "'"; SqlCommand com = new SqlCommand(); com.Connection = con; com.CommandText = chuli; int i2 = com.ExecuteNonQuery(); string sql = "SELECT * FROM [学生信息] where [学号]='" + b + "'"; SqlDataAdapter da = new SqlDataAdapter(sql, con); DataSet ds = new DataSet(); da.Fill(ds, "cs"); dataGridView1.DataSource = ds.Tables["cs"]; con.Close(); } private void button3_Click(object sender, EventArgs e) { string b = a; String constr = "Server = 10.100.102.3;user id = dotnet;pwd = 123;database = wgz"; SqlConnection con = new SqlConnection(); con.ConnectionString = constr; con.Open(); string kuangke = "update [学生信息] set [旷课]=[旷课]+1 where [学号]='" + b + "'"; SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = kuangke; int i1 = cmd.ExecuteNonQuery(); string chuli = "update [学生信息] set [平时成绩] = [平时成绩] - 5 where [学号]='" + b + "'"; SqlCommand com = new SqlCommand(); com.Connection = con; com.CommandText = chuli; int i2 = com.ExecuteNonQuery(); string sql = "SELECT * FROM [学生信息] where [学号]='" + b + "'"; SqlDataAdapter da = new SqlDataAdapter(sql, con); DataSet ds = new DataSet(); da.Fill(ds, "cs"); dataGridView1.DataSource = ds.Tables["cs"]; con.Close(); } private void button4_Click(object sender, EventArgs e) { string b = a; String constr = "Server = 10.100.102.3;user id = dotnet;pwd = 123;database = wgz"; SqlConnection con = new SqlConnection(); con.ConnectionString = constr; con.Open(); string qingjia = "update [学生信息] set [请假]=[请假]+1 where [学号]='" + b + "'"; SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = qingjia; int i1 = cmd.ExecuteNonQuery(); string chuli = "update [学生信息] set [平时成绩] = [平时成绩] - 1 where [学号]='" + b + "'"; SqlCommand com = new SqlCommand(); com.Connection = con; com.CommandText = chuli; int i2 = com.ExecuteNonQuery(); string sql = "SELECT * FROM [学生信息] where [学号]='" + b + "'"; SqlDataAdapter da = new SqlDataAdapter(sql, con); DataSet ds = new DataSet(); da.Fill(ds, "cs"); dataGridView1.DataSource = ds.Tables["cs"]; con.Close(); } private void button5_Click(object sender, EventArgs e) { String constr = "Server = 10.100.102.3;user id = dotnet;pwd = 123;database = wgz"; SqlConnection con = new SqlConnection(); con.ConnectionString = constr; con.Open(); string sql = "SELECT * FROM [学生信息] ORDER BY [学号]"; SqlDataAdapter da = new SqlDataAdapter(sql, con); DataSet ds = new DataSet(); da.Fill(ds, "cs"); dataGridView1.DataSource = ds.Tables["cs"]; con.Close(); } private void button7_Click(object sender, EventArgs e) { Form1 form = new Form1(); form.Show(); this.Hide(); } } } 基于C# C/S的随机点名
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值