简单的基于C#的教材管理系统

该系统是简单的基于C#的教材管理系统，连接SQL2000数据库。

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 jiaocaiguanli
{
    public partial class bjgl : Form
    {
        public bjgl（）
        {
            InitializeComponent（）;
            skinEngine1.SkinFile = “111.ssk“;
        }

        private void listView1_SelectedIndexChanged（object sender EventArgs e）
        {

        }

        
        private void button4_Click（object sender EventArgs e）
        {
            this.Close（）;
        }

        private void button3_Click（object sender EventArgs e）
        {
            SqlConnection conn = new SqlConnection（）;
            conn.ConnectionString = “server=.;uid=sa;pwd=;database=教材管理系统“;
            conn.Open（）;


            SqlCommand comm = new SqlCommand（）;
            comm.Connection = conn;
            comm.CommandType = CommandType.Text;
            comm.CommandText = “insert into 班级管理 values（‘“+textBox1.Text+“‘“+textBox4.Text+“‘“+textBox5.Text+“‘‘“+textBox6 .Text+“‘‘“+textBox2 .Text+“‘‘“+textBox3.Text+“‘‘“+textBox7.Text+“‘）“;

            if （textBox1.Text == ““）
            {
                MessageBox.Show（“请输入班级名“）;
            }
             else if （textBox4.Text == ““）
            {
                MessageBox.Show（“请输入人数“）;
            }
            else
            {
                try
                {

                    int i = comm.ExecuteNonQuery（）;
                    if （i == 1）
                    {

                        MessageBox.Show（“添加成功“）;
                        comm.CommandText = “insert into 缴纳书费 values（‘“ + textBox1.Text + “‘“ + textBox4.Text + “nullnull‘‘‘‘）“;
                        comm.ExecuteNonQuery（）;
                        comm.CommandText = “insert into 退回书费 values（‘“ + textBox1.Text + “‘“ + textBox4.Text + “nullnullnull‘‘‘‘）“;
                        comm.ExecuteNonQuery（）;
                        comm.CommandText = “insert into 学生领书 values（‘“ + textBox1.Text + “‘“ + textBox4.Text + “null‘“ + textBox6.Text + “‘ ‘‘nullnullnullnullnull）“;
                        comm.ExecuteNonQuery（）;
                    }

                    textBox1.Clear（）;
                    textBox2.Clear（）;
                    textBox3.Clear（）;
                    textBox4.Clear（）;
                    textBox5.Clear（）;
                    textBox6.Clear（）;
                    textBox7.Clear（）;
                }

                catch （SqlException）
                {
                    MessageBox.Show（“班级名重复“）;
                }
            }
        }

        private void bjgl_Load（object sender EventArgs e）
        {

        }

        private void button1_Click_1（object sender EventArgs e）
        {
                        SqlConnection conn = new SqlConnection（）;
            conn.Connec

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

     文件      35959  2006-03-22 10:33  jiaocaiguanli\jiaocaiguanli\bin\Debug\111.gif

     文件      12360  2006-03-22 06:07  jiaocaiguanli\jiaocaiguanli\bin\Debug\111.ssk

     文件      17920  2006-03-22 12:23  jiaocaiguanli\jiaocaiguanli\bin\Debug\222.gif

     文件       5032  2006-04-04 15:20  jiaocaiguanli\jiaocaiguanli\bin\Debug\222.ssk

     文件      41715  2006-03-22 10:30  jiaocaiguanli\jiaocaiguanli\bin\Debug\333.gif

     文件      12666  2006-03-22 06:06  jiaocaiguanli\jiaocaiguanli\bin\Debug\333.ssk

     文件      48642  2006-03-22 10:33  jiaocaiguanli\jiaocaiguanli\bin\Debug\444.gif

     文件      11422  2006-03-22 06:08  jiaocaiguanli\jiaocaiguanli\bin\Debug\444.ssk

     文件      20271  2006-03-22 10:16  jiaocaiguanli\jiaocaiguanli\bin\Debug\555.ssk

     文件     516096  2006-08-18 11:50  jiaocaiguanli\jiaocaiguanli\bin\Debug\IrisSkin2.dll

     文件      16262  2006-03-22 12:32  jiaocaiguanli\jiaocaiguanli\bin\Debug\jcglxt.ssk

     文件     811008  2009-06-24 14:44  jiaocaiguanli\jiaocaiguanli\bin\Debug\jiaocaiguanli.exe

     文件     146944  2009-06-24 14:44  jiaocaiguanli\jiaocaiguanli\bin\Debug\jiaocaiguanli.pdb

     文件       5632  2005-11-11 22:25  jiaocaiguanli\jiaocaiguanli\bin\Debug\jiaocaiguanli.vshost.exe

     文件      16097  2006-03-22 05:55  jiaocaiguanli\jiaocaiguanli\bin\Debug\yhdl.ssk

     文件    1310720  2009-06-24 14:49  jiaocaiguanli\jiaocaiguanli\bin\Debug\教材管理系统_Data.MDF

     文件    1048576  2009-06-24 14:49  jiaocaiguanli\jiaocaiguanli\bin\Debug\教材管理系统_Log.LDF

     目录          0  2009-09-24 19:14  jiaocaiguanli\jiaocaiguanli\bin\Debug

     目录          0  2009-09-24 19:14  jiaocaiguanli\jiaocaiguanli\bin

     文件       3509  2000-01-31 16:39  jiaocaiguanli\jiaocaiguanli\bjgl.cs

     文件      12551  2000-01-31 16:39  jiaocaiguanli\jiaocaiguanli\bjgl.Designer.cs

     文件       7929  2000-01-31 16:39  jiaocaiguanli\jiaocaiguanli\bjgl.resx

     文件        498  2009-06-15 10:45  jiaocaiguanli\jiaocaiguanli\bzgy.cs

     文件       3756  2009-06-15 10:45  jiaocaiguanli\jiaocaiguanli\bzgy.Designer.cs

     文件       9083  2009-06-15 10:45  jiaocaiguanli\jiaocaiguanli\bzgy.resx

     文件       3998  2000-01-31 16:39  jiaocaiguanli\jiaocaiguanli\czygl.cs

     文件      14156  2000-01-31 16:39  jiaocaiguanli\jiaocaiguanli\czygl.Designer.cs

     文件       7929  2000-01-31 16:39  jiaocaiguanli\jiaocaiguanli\czygl.resx

     文件        840  2009-06-08 17:46  jiaocaiguanli\jiaocaiguanli\Form1.cs

     文件      12871  2009-06-08 17:46  jiaocaiguanli\jiaocaiguanli\Form1.Designer.cs

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