addgrade.cs

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

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

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;

// edit by gjh 
namespace LoginFrame
{
    public partial class addgrade : Form
    {
        public addgrade()
        {
            InitializeComponent();
            // 初始化姓名选择框
            string sql1 = string.Format("select name from stuinfo");    // 选择所有姓名
            SqlCommand command1 = new SqlCommand(sql1, DbHelper.connection);
            DbHelper.connection.Open();
            SqlDataReader mydr;
            mydr = command1.ExecuteReader();
            object[] myobj = new object[mydr.FieldCount];  //SqlDataReader的FieldCount属性返回字段数量作为数组大小

            while (mydr.Read())
            {
                mydr.GetSqlValues(myobj);           //  SqlDataReader的GetSqlValues()方法用于获取字段全部内容
                foreach (object myname in myobj)
                    this.allname.Items.Add(myname); // 将数据逐个添加到姓名选择框中
            }
            //string myname = Convert.ToString(command1.ExecuteScalar());
            DbHelper.connection.Close();
        }

        private void addgrade_Load(object sender, EventArgs e)
        {

        }

        private void cbxUserStyle_SelectedIndexChanged(object sender, EventArgs e)
        {

        }

        private void btnregedit_Click(object sender, EventArgs e)
        {
            try
            {
                // 更新各项成绩
                string sql = string.Format("UPDATE stuinfo set 数学='{0}',语文='{1}',英语='{2}',物理='{3}',化学='{4}',生物='{5}' where name='{6}';", math.Text,yuwen.Text,english.Text,wuli.Text,huaxue.Text,shengwu.Text, allname.Text);
                // 更新总成绩
                string sql1 = "update stuinfo set 总分 = CONVERT(int, 语文) + CONVERT(int, 语文) + CONVERT(int, 数学) + CONVERT(int, 英语) + CONVERT(int, 物理) + CONVERT(int, 化学) + CONVERT(int, 生物)";
                SqlCommand command = new SqlCommand(sql, DbHelper.connection);
                SqlCommand command1 = new SqlCommand(sql1, DbHelper.connection);
                DbHelper.connection.Open();

                int i = command.ExecuteNonQuery();