server/Gaijuan.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Net;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace server
{
    public partial class Gaijuan : Form
    {
        SqlConnection conn = null;
        DataSet ds1 = null;//考试结果
        DataSet ds = null;//学生信息          
                          // List<Score> sc = new List<Score>();
        string sqlStudentCode;
        public Gaijuan(string str)
        {
            InitializeComponent();
            this.sqlStudentCode = str;
        }

        private void Gaijuan_Load(object sender, EventArgs e)
        {
            conn = new SqlConnection(sqlStudentCode);
            conn.Open();
            string sql = "select * from StudentDB";
            SqlDataAdapter da = new SqlDataAdapter(sql, conn);
            ds = new DataSet();
            da.Fill(ds);
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                studentExamNumber.Items.Add(ds.Tables[0].Rows[i]["admissionTicket"]);//准考证  
                if (comboBox1.Items.IndexOf(ds.Tables[0].Rows[i]["classAndGrade"].ToString().Trim()) == -1)//班级
                {
                    comboBox1.Items.Add(ds.Tables[0].Rows[i]["classAndGrade"].ToString().Trim());//班级
                }
            }
        }
        string Encall(string str, string key)
        {
            str = encryptionAndDecryption.Authcode.DiscuzAuthcodeEncode(str, key);
            return str;
        } //加密
        string Decall(string str, string key)
        {
            str = encryptionAndDecryption.Authcode.DiscuzAuthcodeDecode(str, key);
            return str;
        }  //解密
        private void button1_Click(object sender, EventArgs e)
        {
            try
            { 
                string sql1 = "insert into grade(admissionTicket,classAndGrade) select admissionTicket,classAndGrade from StudentDB";
                SqlCommand dacj = new SqlCommand(sql1, conn);