using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Threading.Tasks;
using?System.Windows.Forms;
using?System.Data.SqlClient;
using?System.Configuration;
using?System.Collections;
namespace?UniversityGamesManage
{
????public?partial?class?addAthlete?:?Form
????{
????????public?Bitmap?m_Bitmap?=?null;
????????public?string?path;
????????public?addAthlete（）
????????{
????????????InitializeComponent（）;
????????}

????????

????????private?void?addAthlete_Load（object?sender?EventArgs?e）?
????????{
????????????string?ico?=?Application.StartupPath?+?“\\..\\..\\img\\logo.ico“;??//應(yīng)用圖標(biāo)地址
????????????this.Icon?=?new?Icon（ico）;????//設(shè)置?本課設(shè)的圖標(biāo)
????????????textBox2.ImeMode?=?System.Windows.Forms.ImeMode.On;
????????????college（）;
????????????game（）;
????????????pictureBox1.Image?=?Image.FromFile（Application.StartupPath?+?“\\..\\..\\img\\initHead.jpg“）;


????????}

????????private?void?button1_Click（object?sender?EventArgs?e）?//添加
????????{
????????????string?sno?=?textBox1.Text;
????????????string?name?=?textBox2.Text;
????????????string?college?=?comboBox1.Text;
????????????string?game?=?comboBox2.Text;
????????????string?headUrl?=?path;
????????????SqlConnection?conVerify?=?new?SqlConnection（ConfigurationManager.ConnectionStrings[“conn“].ConnectionString）;
????????????conVerify.Open（）;
????????????SqlCommand?cmdconVerify?=?conVerify.CreateCommand（）;
????????????//把輸入的數(shù)據(jù)拼接成sql語(yǔ)句，并交給cmd對(duì)象
????????????cmdconVerify.CommandText?=?“select?*?from?[Athlete]?where?sno=‘“?+?sno?+?“‘“;
????????????//用cmd的函數(shù)執(zhí)行語(yǔ)句，返回SqlDataReader對(duì)象drdr就是返回的結(jié)果集（也就是數(shù)據(jù)庫(kù)中查詢到的表數(shù)據(jù)）
????????????SqlDataReader?dr?=?cmdconVerify.ExecuteReader（）;
????????????//用dr的read函數(shù)，每執(zhí)行一次，返回一個(gè)包含下一行數(shù)據(jù)的集合dr，在執(zhí)行read函數(shù)之前，dr并不是集合
????????????if?（dr.Read（））
????????????{
????????????????MessageBox.Show（“該名運(yùn)動(dòng)員已經(jīng)存在，請(qǐng)不要重復(fù)添加“）;
????????????????//用完后關(guān)閉連接，以免影響其他程序訪問
????????????????conVerify.Close（）;

????????????}
????????????else
????????????{
????????????????SqlConnection?con?=?new?SqlConnection（ConfigurationManager.ConnectionStrings[“conn“].ConnectionString）;
????????????????//將連接打開
????????????????con.Open（）;
????????????????//執(zhí)行con對(duì)象的函數(shù)，返回一個(gè)SqlCommand類型的對(duì)象
????????????????SqlCommand?cmd?=?con.CreateCommand（）;
????????????????//拼寫語(yǔ)句

????????????????cmd.CommandText?=?“insert?into?[Athlete]?values（‘“?+?sno?+?“‘‘“?+?name?+?“‘‘“??+?college?+?“‘‘“?+?game?+?“‘‘“+headUrl+?“‘）“;
????????????????//增刪改用ExecuteNonQuery，會(huì)返回一個(gè)整型數(shù)字
????????????????int?count?=?cmd.ExecuteNonQuery（）;
????????????????if?（count?>?0）
????????????????{
????????????????????MessageBox.Show（“添加成功“）;
????????????????}
????????????????else
????????????????{
????????????????????MessageBox.Show（“添加失敗“）;
????????????????}

????????????????con.Close（）;

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

????????private?void?button2_Click（object?sender?EventArgs?e）?//關(guān)閉
????????

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2019-06-20?05:40??大學(xué)生運(yùn)動(dòng)會(huì)管理系統(tǒng)\
?????目錄???????????0??2019-06-19?21:54??大學(xué)生運(yùn)動(dòng)會(huì)管理系統(tǒng)\UniversityGamesManage\
?????目錄???????????0??2019-06-19?21:54??大學(xué)生運(yùn)動(dòng)會(huì)管理系統(tǒng)\UniversityGamesManage\.vs\
?????目錄???????????0??2019-06-19?21:54??大學(xué)生運(yùn)動(dòng)會(huì)管理系統(tǒng)\UniversityGamesManage\.vs\UniversityGamesManage\
?????目錄???????????0??2019-06-19?21:54??大學(xué)生運(yùn)動(dòng)會(huì)管理系統(tǒng)\UniversityGamesManage\.vs\UniversityGamesManage\v15\
?????文件???????81920??2019-06-20?17:01??大學(xué)生運(yùn)動(dòng)會(huì)管理系統(tǒng)\UniversityGamesManage\.vs\UniversityGamesManage\v15\.suo
?????目錄???????????0??2019-06-19?21:54??大學(xué)生運(yùn)動(dòng)會(huì)管理系統(tǒng)\UniversityGamesManage\.vs\UniversityGamesManage\v15\Server\
?????目錄???????????0??2019-06-20?17:01??大學(xué)生運(yùn)動(dòng)會(huì)管理系統(tǒng)\UniversityGamesManage\.vs\UniversityGamesManage\v15\Server\sqlite3\
?????文件???????????0??2019-06-19?21:54??大學(xué)生運(yùn)動(dòng)會(huì)管理系統(tǒng)\UniversityGamesManage\.vs\UniversityGamesManage\v15\Server\sqlite3\db.lock
?????文件??????720896??2019-06-20?17:01??大學(xué)生運(yùn)動(dòng)會(huì)管理系統(tǒng)\UniversityGamesManage\.vs\UniversityGamesManage\v15\Server\sqlite3\storage.ide
?????目錄???????????0??2019-06-20?16:58??大學(xué)生運(yùn)動(dòng)會(huì)管理系統(tǒng)\UniversityGamesManage\UniversityGamesManage\
?????文件?????????372??2019-06-19?22:31??大學(xué)生運(yùn)動(dòng)會(huì)管理系統(tǒng)\UniversityGamesManage\UniversityGamesManage\App.config
?????文件????????6990??2019-06-20?15:49??大學(xué)生運(yùn)動(dòng)會(huì)管理系統(tǒng)\UniversityGamesManage\UniversityGamesManage\AthleteInfo.Designer.cs
?????文件????????4937??2019-06-20?15:49??大學(xué)生運(yùn)動(dòng)會(huì)管理系統(tǒng)\UniversityGamesManage\UniversityGamesManage\AthleteInfo.cs
?????文件????????6022??2019-06-20?15:49??大學(xué)生運(yùn)動(dòng)會(huì)管理系統(tǒng)\UniversityGamesManage\UniversityGamesManage\AthleteInfo.resx
?????文件?????????542??2019-06-20?14:13??大學(xué)生運(yùn)動(dòng)會(huì)管理系統(tǒng)\UniversityGamesManage\UniversityGamesManage\Program.cs
?????目錄???????????0??2019-06-20?00:23??大學(xué)生運(yùn)動(dòng)會(huì)管理系統(tǒng)\UniversityGamesManage\UniversityGamesManage\Properties\
?????文件????????1358??2019-06-19?21:54??大學(xué)生運(yùn)動(dòng)會(huì)管理系統(tǒng)\UniversityGamesManage\UniversityGamesManage\Properties\AssemblyInfo.cs
?????文件????????8722??2019-06-20?00:23??大學(xué)生運(yùn)動(dòng)會(huì)管理系統(tǒng)\UniversityGamesManage\UniversityGamesManage\Properties\Resources.Designer.cs
?????文件????????9802??2019-06-20?00:23??大學(xué)生運(yùn)動(dòng)會(huì)管理系統(tǒng)\UniversityGamesManage\UniversityGamesManage\Properties\Resources.resx
?????文件????????1108??2019-06-19?21:54??大學(xué)生運(yùn)動(dòng)會(huì)管理系統(tǒng)\UniversityGamesManage\UniversityGamesManage\Properties\Settings.Designer.cs
?????文件?????????249??2019-06-19?21:54??大學(xué)生運(yùn)動(dòng)會(huì)管理系統(tǒng)\UniversityGamesManage\UniversityGamesManage\Properties\Settings.settings
?????文件????????7453??2019-06-20?14:13??大學(xué)生運(yùn)動(dòng)會(huì)管理系統(tǒng)\UniversityGamesManage\UniversityGamesManage\UniversityGamesManage.csproj
?????文件?????????228??2019-06-19?22:53??大學(xué)生運(yùn)動(dòng)會(huì)管理系統(tǒng)\UniversityGamesManage\UniversityGamesManage\UniversityGamesManage.csproj.user
?????文件????????9921??2019-06-20?14:13??大學(xué)生運(yùn)動(dòng)會(huì)管理系統(tǒng)\UniversityGamesManage\UniversityGamesManage\addAthlete.Designer.cs
?????文件????????5853??2019-06-20?15:49??大學(xué)生運(yùn)動(dòng)會(huì)管理系統(tǒng)\UniversityGamesManage\UniversityGamesManage\addAthlete.cs
?????文件??????111718??2019-06-20?15:49??大學(xué)生運(yùn)動(dòng)會(huì)管理系統(tǒng)\UniversityGamesManage\UniversityGamesManage\addAthlete.resx
?????文件????????4244??2019-06-20?14:13??大學(xué)生運(yùn)動(dòng)會(huì)管理系統(tǒng)\UniversityGamesManage\UniversityGamesManage\addCollege.Designer.cs
?????文件????????2945??2019-06-20?14:13??大學(xué)生運(yùn)動(dòng)會(huì)管理系統(tǒng)\UniversityGamesManage\UniversityGamesManage\addCollege.cs
?????文件????????5817??2019-06-20?14:13??大學(xué)生運(yùn)動(dòng)會(huì)管理系統(tǒng)\UniversityGamesManage\UniversityGamesManage\addCollege.resx
?????文件????????4143??2019-06-20?12:57??大學(xué)生運(yùn)動(dòng)會(huì)管理系統(tǒng)\UniversityGamesManage\UniversityGamesManage\addGame.Designer.cs
............此處省略102個(gè)文件信息