using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.SqlClient;

namespace?StudentIfoMag
{
????public?partial?class?CourseEnter?:?Form
????{
????????public?CourseEnter（）
????????{
????????????InitializeComponent（）;
????????}

????????private?void?CourseEnter_Load（object?sender?EventArgs?e）
????????{
????????????//?TODO:?這行代碼將數據加載到表“studentIfoMagDataSet18.course”中。您可以根據需要移動或移除它。
????????????this.courseTableAdapter.Fill（this.studentIfoMagDataSet18.course）;
????????????comboBox1.SelectedIndex?=?0;
????????}

????????private?void?button2_Click（object?sender?EventArgs?e）
????????{
????????????textBox1.Text?=?““;
????????????comboBox1.SelectedIndex?=?0;
????????}

????????private?void?button1_Click（object?sender?EventArgs?e）
????????{
????????????if?（textBox1.Text?==““）
????????????{
????????????????MessageBox.Show（“請輸入課程名！““提示“MessageBoxButtons.OK?MessageBoxIcon.Exclamation?）;
????????????}
????????????else
????????????{
????????????????string?connString?=?@“Data?Source=.\SQL2005;Initial?Catalog=StudentIfoMag;uid=sa;pwd=sasasa“;
????????????????SqlConnection?connection?=?new?SqlConnection（connString）;
????????????????string?sql?=?String.Format（“INSERT?INTO?course（courseNamecourseClass）?VALUES?（‘{0}‘‘{1}‘）“?textBox1.Text?comboBox1.SelectedItem.ToString?（））;?//SQL語句
????????????????try
????????????????{
????????????????????connection.Open（）;//?打開數據庫連接???????????
????????????????????SqlCommand?command?=?new?SqlCommand（sql?connection）;?//創建?Command?對象
????????????????????int?count?=?command.ExecuteNonQuery（）;//?執行添加命令返回值為更新的行數
????????????????????if?（count?>?0）
????????????????????{
????????????????????????courseTableAdapter.Fill（studentIfoMagDataSet18.course?）;
????????????????????????MessageBox.Show（“添加課程成功“?“錄入成功“?MessageBoxButtons.OK?MessageBoxIcon.Information）;
????????????????????}
????????????????????else
????????????????????{
????????????????????????MessageBox.Show（“添加課程失敗“?“錄入失敗“?MessageBoxButtons.OK?MessageBoxIcon.Information）;
????????????????????}
????????????????}
????????????????catch?（Exception?ex）
????????????????{
????????????????????MessageBox.Show（ex.Message?“操作數據庫出錯！“?MessageBoxButtons.OK?MessageBoxIcon.Exclamation）;
????????????????}
????????????????finally
????????????????{
????????????????????connection.Close（）;//?關閉數據庫連接
????????????????}

????????????}
????????}
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????11526??2010-12-05?14:18??CourseEnter.Designer.cs
?????文件????????2774??2016-06-29?18:29??CourseEnter.cs
?????文件??????436628??2010-12-05?14:18??CourseEnter.resx
?????文件???????22078??2010-12-05?15:21??CurChoice.Designer.cs
?????文件????????3757??2010-12-05?15:21??CurChoice.cs
?????文件??????270682??2010-12-05?15:21??CurChoice.resx
?????目錄???????????0??2016-06-29?17:49??DB\
?????文件?????2293760??2016-06-30?14:04??DB\StudentIfoMag.mdf
?????文件??????573440??2016-06-30?14:04??DB\StudentIfoMag_log.LDF
?????文件????????6176??2010-12-05?16:21??Login.Designer.cs
?????文件????????2327??2016-06-29?18:29??Login.cs
?????文件??????290331??2010-12-05?16:21??Login.resx
?????文件???????26585??2010-12-05?19:24??MainFrm.Designer.cs
?????文件????????3044??2010-12-05?19:24??MainFrm.cs
?????文件??????163735??2010-12-05?19:24??MainFrm.resx
?????文件???????21375??2010-12-05?16:08??Other.Designer.cs
?????文件???????11061??2016-06-29?18:29??Other.cs
?????文件????????9579??2010-12-05?16:08??Other.resx
?????文件????????9418??2010-12-05?17:23??Other2.Designer.cs
?????文件????????3656??2016-06-29?18:29??Other2.cs
?????文件??????624584??2010-12-05?17:23??Other2.resx
?????文件?????????494??2010-12-20?13:20??Program.cs
?????目錄???????????0??2016-06-29?17:49??Properties\
?????文件????????1358??2010-11-24?19:05??Properties\AssemblyInfo.cs
?????文件????????2866??2016-06-29?17:50??Properties\Resources.Designer.cs
?????文件????????5612??2010-11-24?19:05??Properties\Resources.resx
?????文件????????1744??2016-06-29?18:28??Properties\Settings.Designer.cs
?????文件????????1021??2016-06-29?18:28??Properties\Settings.settings
?????文件???????11902??2010-12-05?15:01??Rank.Designer.cs
?????文件????????2151??2016-06-29?18:28??Rank.cs
?????文件??????269882??2010-12-05?15:01??Rank.resx
............此處省略184個文件信息