资源简介
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个文件信息
评论
共有 条评论