資源簡介
我的數據庫課程設計,里面源碼、數據庫導出文件、任務書、課程設計報告一應俱全。直接可以使用

代碼片段和文件信息
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.xm
?????文件???????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個文件信息
- 上一篇:C#開發影院售票系統
- 下一篇:ASP.NET網站通用后臺管理系統
評論
共有 條評論