• 大小: 7.51MB
    文件类型: .rar
    金币: 1
    下载: 0 次
    发布日期: 2023-09-26
  • 语言: 数据库
  • 标签: SqlServer  

资源简介

该资源为数据库课程设计,内有存储过程,功能比较强大。。。

资源截图

代码片段和文件信息

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;
using System.Diagnostics;  //  任务管理程序处理引用

namespace studentsystem
{
    public partial class AcademicStatus : Form
    {
        private SqlConnection myconn;
        public AcademicStatus()
        {
            myconn = new SqlConnection(studentsystem.database.Sqlconnection.connection);
            InitializeComponent();
        }

        private void scno_TextChanged(object sender EventArgs e)
        {
            myconn.Open();
            SqlCommand cmd = new SqlCommand(““myconn);
            string sql=“select * from student“;
            cmd.CommandText = sql;          
            
            if (null!=cmd.ExecuteScalar())
            {
                sql = “select SUM(所得学分)from year1 where 学号=‘“ + scno.Text.Trim() + “‘group by 学号“;
                cmd.CommandText = sql;
                if (null!=cmd.ExecuteScalar())
                {
                    grade1.Text = cmd.ExecuteScalar().ToString()+“  分“;
                }
                else grade1.Text = “0   分“;

                sql = “select SUM(所得学分)from year2 where 学号=‘“ + scno.Text.Trim() + “‘group by 学号“;
                cmd.CommandText = sql;
                if (null != cmd.ExecuteScalar())
                {
                    grade2.Text = cmd.ExecuteScalar().ToString() + “  分“;
                }
                else grade2.Text = “0   分“;

                sql = “select SUM(所得学分)from year3 where 学号=‘“ + scno.Text.Trim() + “‘group by 学号“;
                cmd.CommandText = sql;
                if (null != cmd.ExecuteScalar())
                {
                    grade3.Text = cmd.ExecuteScalar().ToString() + “  分“;
                }
                else grade3.Text = “0   分“;

                sql = “select SUM(所得学分)from year4 where 学号=‘“ + scno.Text.Trim() + “‘group by 学号“;
                cmd.CommandText = sql;
                if (null != cmd.ExecuteScalar())
                {
                    grade4.Text = cmd.ExecuteScalar().ToString() + “  分“;
                }
                else grade4.Text = “0   分“;

                string s=null;
                sql = “select 姓名 from grade where 学号=‘“ + scno.Text.Trim() + “‘“;
                cmd.CommandText = sql;
                if (null != cmd.ExecuteScalar())
                {
                    s = “姓名: “ + cmd.ExecuteScalar().ToString() + “        “;
                }               

                sql = “select SUM(所得学分)from grade where 学号=‘“ + scno.Text.Trim() + “‘group by 学号“;
                cmd.CommandText = sql;
                if (null != cmd.ExecuteScalar())
                {
                    
                    cmd.CommandText = sql;
                    string bs = cmd.ExecuteScalar().ToString();
                    in

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件       5039  2010-01-11 21:38  数据库课程设计\studentsystem\Backup\studentsystem\AcademicStatus.cs

     文件       8418  2010-01-11 21:15  数据库课程设计\studentsystem\Backup\studentsystem\AcademicStatus.Designer.cs

     文件       5814  2010-01-11 21:15  数据库课程设计\studentsystem\Backup\studentsystem\AcademicStatus.resx

     文件       2314  2010-01-10 03:01  数据库课程设计\studentsystem\Backup\studentsystem\AddClass.cs

     文件       6333  2010-01-10 03:01  数据库课程设计\studentsystem\Backup\studentsystem\AddClass.Designer.cs

     文件       5814  2010-01-10 03:01  数据库课程设计\studentsystem\Backup\studentsystem\AddClass.resx

     文件       2099  2010-01-11 09:57  数据库课程设计\studentsystem\Backup\studentsystem\AddCourse.cs

     文件       8013  2010-01-11 09:43  数据库课程设计\studentsystem\Backup\studentsystem\AddCourse.Designer.cs

     文件       5814  2010-01-11 09:43  数据库课程设计\studentsystem\Backup\studentsystem\AddCourse.resx

     文件       2517  2010-01-11 09:25  数据库课程设计\studentsystem\Backup\studentsystem\AddCS.cs

     文件       8324  2010-01-11 09:23  数据库课程设计\studentsystem\Backup\studentsystem\AddCS.Designer.cs

     文件       5814  2010-01-11 09:23  数据库课程设计\studentsystem\Backup\studentsystem\AddCS.resx

     文件       2629  2010-01-13 02:48  数据库课程设计\studentsystem\Backup\studentsystem\AddGrade.cs

     文件       8167  2010-01-11 09:36  数据库课程设计\studentsystem\Backup\studentsystem\AddGrade.Designer.cs

     文件       5814  2010-01-11 09:36  数据库课程设计\studentsystem\Backup\studentsystem\AddGrade.resx

     文件       2535  2010-01-09 22:09  数据库课程设计\studentsystem\Backup\studentsystem\AddMajor.cs

     文件       8289  2010-01-09 15:55  数据库课程设计\studentsystem\Backup\studentsystem\AddMajor.Designer.cs

     文件       5814  2010-01-09 15:55  数据库课程设计\studentsystem\Backup\studentsystem\AddMajor.resx

     文件       1981  2010-01-09 15:17  数据库课程设计\studentsystem\Backup\studentsystem\AddRoles.cs

     文件       7847  2010-01-08 19:42  数据库课程设计\studentsystem\Backup\studentsystem\AddRoles.Designer.cs

     文件       5814  2010-01-08 19:37  数据库课程设计\studentsystem\Backup\studentsystem\AddRoles.resx

     文件       2011  2010-01-10 20:59  数据库课程设计\studentsystem\Backup\studentsystem\AddSchools.cs

     文件       6522  2010-01-09 11:19  数据库课程设计\studentsystem\Backup\studentsystem\AddSchools.Designer.cs

     文件       5814  2010-01-09 11:19  数据库课程设计\studentsystem\Backup\studentsystem\AddSchools.resx

     文件       3562  2010-01-09 02:07  数据库课程设计\studentsystem\Backup\studentsystem\AddUser.cs

     文件      10289  2010-01-09 02:07  数据库课程设计\studentsystem\Backup\studentsystem\AddUser.Designer.cs

     文件       5814  2010-01-09 02:07  数据库课程设计\studentsystem\Backup\studentsystem\AddUser.resx

     文件       1092  2010-01-12 20:34  数据库课程设计\studentsystem\Backup\studentsystem\app.config

     文件       1812  2010-09-22 22:31  数据库课程设计\studentsystem\Backup\studentsystem\bin\Debug\studentsystem.application

     文件     422912  2010-09-22 22:31  数据库课程设计\studentsystem\Backup\studentsystem\bin\Debug\studentsystem.exe

............此处省略429个文件信息

评论

共有 条评论