• 大小: 6.58MB
    文件类型: .rar
    金币: 1
    下载: 0 次
    发布日期: 2023-11-06
  • 语言: 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 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

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

     文件        933  2011-01-05 17:36  黄辉\教材管理\jiaocaiguanli.sln

    ..A..H.    118272  2011-01-07 16:51  黄辉\教材管理\jiaocaiguanli.suo

     文件       1093  2011-01-05 17:36  黄辉\教材管理\UpgradeLog.xml

     文件       3348  2011-01-05 17:36  黄辉\教材管理\_UpgradeReport_Files\UpgradeReport.css

     文件         69  2011-01-05 17:36  黄辉\教材管理\_UpgradeReport_Files\UpgradeReport_Minus.gif

     文件         71  2011-01-05 17:36  黄辉\教材管理\_UpgradeReport_Files\UpgradeReport_Plus.gif

     文件      12505  2008-07-31 08:51  黄辉\教材管理\_UpgradeReport_Files\UpgradeReport.xslt

    ..A.SH.      4096  2011-01-06 16:15  黄辉\教材管理\_UpgradeReport_Files\Thumbs.db

     文件      50684  2009-06-16 17:35  黄辉\教材管理\Visual Studio 2005\Visualizers\attribcache80.bin

     文件       9932  2011-01-06 23:06  黄辉\教材管理\Visual Studio 2005\Visualizers\autoexp.cs

     文件      15872  2005-11-11 22:50  黄辉\教材管理\Visual Studio 2005\Visualizers\autoexp.dll

     文件       8278  2011-01-06 23:06  黄辉\教材管理\Visual Studio 2005\Visualizers\autoexpce.cs

     文件      12288  2005-11-11 22:50  黄辉\教材管理\Visual Studio 2005\Visualizers\autoexpce.dll

     文件     130519  2005-11-11 22:23  黄辉\教材管理\Visual Studio 2005\Settings\CurrentSettings.vssettings

     文件       3509  2000-01-31 16:39  黄辉\教材管理\jiaocaiguanli\bjgl.cs

     文件      12551  2000-01-31 16:39  黄辉\教材管理\jiaocaiguanli\bjgl.Designer.cs

     文件       7929  2000-01-31 16:39  黄辉\教材管理\jiaocaiguanli\bjgl.resx

     文件        498  2009-06-15 10:45  黄辉\教材管理\jiaocaiguanli\bzgy.cs

     文件       3756  2009-06-15 10:45  黄辉\教材管理\jiaocaiguanli\bzgy.Designer.cs

     文件       9083  2009-06-15 10:45  黄辉\教材管理\jiaocaiguanli\bzgy.resx

     文件       4085  2011-01-07 16:51  黄辉\教材管理\jiaocaiguanli\czygl.cs

     文件      14224  2011-01-07 16:51  黄辉\教材管理\jiaocaiguanli\czygl.Designer.cs

     文件       7929  2011-01-07 16:51  黄辉\教材管理\jiaocaiguanli\czygl.resx

     文件        841  2011-01-06 23:03  黄辉\教材管理\jiaocaiguanli\Form1.cs

     文件      12872  2011-01-06 23:03  黄辉\教材管理\jiaocaiguanli\Form1.Designer.cs

     文件       6211  2009-06-08 17:46  黄辉\教材管理\jiaocaiguanli\Form1.resx

     文件        339  2011-01-06 23:04  黄辉\教材管理\jiaocaiguanli\Form2.cs

     文件      11836  2011-01-06 23:04  黄辉\教材管理\jiaocaiguanli\Form2.Designer.cs

     文件       5814  2009-06-08 18:03  黄辉\教材管理\jiaocaiguanli\Form2.resx

     文件       3336  2011-01-06 09:39  黄辉\教材管理\jiaocaiguanli\jcglxt.cs

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

评论

共有 条评论

相关资源