文件名称：随机点名器
文件大小：5.4MB
文件格式：GZ
更新时间：2017-04-09 16:31:17
C# c/s
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的随机点名器
【文件预览】：
随机点名器
----随机点名器()
--------DataSet1.xsd(8KB)
--------bin()
--------Form1.Designer.cs(7KB)
--------Form3.cs(1KB)
--------Form2.resx(682KB)
--------Form3.Designer.cs(5KB)
--------Program.cs(496B)
--------obj()
--------Form3.resx(681KB)
--------Form2.cs(6KB)
--------Form1.cs(1KB)
--------app.config(410B)
--------DataSet1.Designer.cs(75KB)
--------随机点名器.csproj(5KB)
--------Form2.Designer.cs(10KB)
--------Form1.resx(681KB)
--------DataSet1.xsc(3B)
--------Properties()
--------DataSet1.xss(3B)
----随机点名器.sln(887B)
----随机点名器.suo(24KB)