server/DerivedScore.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.Net;
using System.Data.SqlClient;

using Microsoft.Office.Interop.Excel;
//using Interop.Excel;
using System.Reflection;
namespace server
{
    public partial class DerivedScore : Form
    {
        SqlConnection conn = null;
        DataSet ds = null;
        SqlDataAdapter da = null;
        public DerivedScore(ComboBox cbo)//导出成绩
        {
            InitializeComponent();
            for (int i = 0; i < cbo.Items.Count; i++)
            {
                comboBox1.Items.Add(cbo.Items[i]);
            }
        }

        private void DerivedScore_Load(object sender, EventArgs e)
        {
            button1.Enabled = false;

            string s = "server = localhost; User Id = sa; Pwd = 51Aspx; Database = StudentDB";
            conn = new SqlConnection(s);
            conn.Open();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            ExportToExcel();
        }
        public void ExportToExcel()//导出
        {
            ApplicationClass MyExcel;
            Workbooks MyWorkBooks;
            Workbook MyWorkBook;
            Worksheet MyWorkSheet;
            char MyColumns;
            Range MyRange;
            Object[,] MyData = new Object[5000, 30];
            SqlDataReader MyReader;
            //DataColumn MyColumn;
            int Count, i, j;
            MyExcel = new ApplicationClass();
            MyExcel.Visible = true;
            if (MyExcel == null)
            {