• 大小: 1.99MB
    文件类型: .zip
    金币: 1
    下载: 0 次
    发布日期: 2023-10-15
  • 语言: C#
  • 标签:

资源简介

C#,教务管理系统,里面包含了学生管理模块,教师管理模块,成绩管理模块等,附加数据库

资源截图

代码片段和文件信息

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace xyglxt
{
    public partial class Formdenglu : Form
    {
        public Formdenglu()
        {
            InitializeComponent();
        }

        private void buttonload_Click(object sender EventArgs e)
        {
            if (user.Text == “ “ || pwd.Text == “ “)
            {
                MessageBox.Show(“输入登录信息不完整,请重新输入!“ “信息提示“ MessageBoxButtons.OK MessageBoxIcon.Information);

            }
            else
            {
                string strconn = “server=(local);Integrated Security=SSPI;database=学院管理系统“;
                SqlConnection conn = new SqlConnection(strconn);
                conn.Open();
                string mysql = “ “;


                if (radioButstudent.Checked == true)
                {


                     mysql = “select 学号 from 学生表 where 学号=‘“ + user.Text + “ ‘ and  密码 =‘“ + pwd.Text + “ ‘“;
                    SqlDataAdapter myada1 = new SqlDataAdapter(mysql conn);
                    DataTable mydt1 = new DataTable();
                    myada1.Fill(mydt1);
                    int a = mydt1.Rows.Count;
                    if (a >= 1)
                    {
                        Formxuesheng form2 = new Formxuesheng();
                        form2.Show();

                    }
                    else
                    {
                        MessageBox.Show(“用户名或密码不正确,请你出新输入!“ “信息提示“ MessageBoxButtons.OK MessageBoxIcon.Information);

                    }
                }
                

                    if (radioButteacher.Checked == true)
                    {
                        mysql = “select 编号 from 教师表 where 编号=‘“ + user.Text + “ ‘ and 密码=‘“ + pwd.Text + “ ‘“;
                        SqlDataAdapter myada2 = new SqlDataAdapter(mysql conn);
                        DataTable mydt2 = new DataTable();
                        myada2.Fill(mydt2);
                        int b = mydt2.Rows.Count;
                        if (b >= 1)
                        {
                            Formjiaoshi form3 = new Formjiaoshi();
                            form3.Show();

                        }
                        else
                        {
                            MessageBox.Show(“用户名或密码不正确,请你出新输入!“ “信息提示“ MessageBoxButtons.OK MessageBoxIcon.Information);

                        }
                    }

                    if (radioButguanliyuan.Checked == true)
                    {
                        mysql = “select 用户名 from 管理员表 where 用户名=‘“ + user.Text + “ ‘ and 密码=‘“ + pwd.Text + “ ‘“;
                        SqlDataAdapter myada3 = new SqlDataAdapter(mysql conn);
                        DataTable mydt3 = new DataTable();
                        myada3.Fill(mydt3);
           

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2011-08-22 14:43  xyglxt(终结版)\
     目录           0  2010-04-20 17:07  xyglxt(终结版)\xyglxt\
     文件        5835  2010-04-21 17:08  xyglxt(终结版)\xyglxt\shujuku.txt
     目录           0  2010-04-20 17:07  xyglxt(终结版)\xyglxt\xyglxt\
     文件         907  2010-04-19 21:23  xyglxt(终结版)\xyglxt\xyglxt.sln
     文件       25088  2010-04-26 11:39  xyglxt(终结版)\xyglxt\xyglxt.suo
     目录           0  2010-04-20 17:07  xyglxt(终结版)\xyglxt\xyglxt\bin\
     目录           0  2010-04-20 17:07  xyglxt(终结版)\xyglxt\xyglxt\bin\Debug\
     文件        1466  2010-04-26 11:37  xyglxt(终结版)\xyglxt\xyglxt\bin\Debug\xyglxt.application
     文件       90112  2010-04-26 11:37  xyglxt(终结版)\xyglxt\xyglxt\bin\Debug\xyglxt.exe
     文件        2120  2010-04-26 11:37  xyglxt(终结版)\xyglxt\xyglxt\bin\Debug\xyglxt.exe.manifest
     文件       99840  2010-04-26 11:37  xyglxt(终结版)\xyglxt\xyglxt\bin\Debug\xyglxt.pdb
     目录           0  2010-04-23 13:30  xyglxt(终结版)\xyglxt\xyglxt\bin\Debug\xyglxt.publish\
     文件      423936  2010-04-23 13:30  xyglxt(终结版)\xyglxt\xyglxt\bin\Debug\xyglxt.publish\setup.exe
     文件        5255  2010-04-23 13:30  xyglxt(终结版)\xyglxt\xyglxt\bin\Debug\xyglxt.publish\xyglxt.application
     目录           0  2010-04-23 13:30  xyglxt(终结版)\xyglxt\xyglxt\bin\Debug\xyglxt.publish\xyglxt_1_0_0_0\
     文件       81920  2010-04-23 13:30  xyglxt(终结版)\xyglxt\xyglxt\bin\Debug\xyglxt.publish\xyglxt_1_0_0_0\xyglxt.exe.deploy
     文件        5858  2010-04-23 13:30  xyglxt(终结版)\xyglxt\xyglxt\bin\Debug\xyglxt.publish\xyglxt_1_0_0_0\xyglxt.exe.manifest
     文件        1466  2010-04-26 11:37  xyglxt(终结版)\xyglxt\xyglxt\bin\Debug\xyglxt.vshost.application
     文件        5632  2005-12-08 14:51  xyglxt(终结版)\xyglxt\xyglxt\bin\Debug\xyglxt.vshost.exe
     文件        2120  2010-04-26 11:37  xyglxt(终结版)\xyglxt\xyglxt\bin\Debug\xyglxt.vshost.exe.manifest
     文件        5888  2010-04-23 13:02  xyglxt(终结版)\xyglxt\xyglxt\Form1.cs
     文件        9875  2010-04-23 12:17  xyglxt(终结版)\xyglxt\xyglxt\Form1.Designer.cs
     文件        5814  2010-04-23 12:17  xyglxt(终结版)\xyglxt\xyglxt\Form1.resx
     文件        7430  2010-04-26 11:37  xyglxt(终结版)\xyglxt\xyglxt\Form2.cs
     文件       28571  2010-04-26 11:35  xyglxt(终结版)\xyglxt\xyglxt\Form2.Designer.cs
     文件        5814  2010-04-26 11:35  xyglxt(终结版)\xyglxt\xyglxt\Form2.resx
     文件       10059  2010-04-26 11:25  xyglxt(终结版)\xyglxt\xyglxt\Form3.cs
     文件       29683  2010-04-26 11:25  xyglxt(终结版)\xyglxt\xyglxt\Form3.Designer.cs
     文件        5814  2010-04-26 11:25  xyglxt(终结版)\xyglxt\xyglxt\Form3.resx
     文件       45825  2010-04-26 11:15  xyglxt(终结版)\xyglxt\xyglxt\Form4.cs
............此处省略33个文件信息

评论

共有 条评论

相关资源