【Linux~C基础】编写函数实现随机点名

在这里插入图片描述

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
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、付费专栏及课程。

余额充值