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?班級(jí)考勤
{
????public?partial?class?add?:?Form
????{
????????public?add（）
????????{
????????????InitializeComponent（）;
????????}

????????private?void?button1_Click（object?sender?EventArgs?e）
????????{
????????????string?connString?=?@“Data?Source=.;Initial?Catalog=Table1;Integrated?Security=True“;
????????????SqlConnection?conn?=?null;
????????????SqlCommand?cmd?=?null;
????????????try{
??????????
????????????conn?=?new?SqlConnection（connString）;
????????????conn.Open（）;
????????????cmd?=?conn.CreateCommand（）;
????????????cmd.CommandText?=?“insert?into?Table1（snopasswordgradesexdeptname）?values（@sno@password@grade@sex@dept@name）“;
????????????cmd.Parameters.AddWithValue（“@name“?textBox1.Text.Trim（））;
????????????cmd.Parameters.AddWithValue（“@sno“?textBox2.Text.Trim（））;
????????????cmd.Parameters.AddWithValue（“@password“?textBox3.Text.Trim（））;
????????????cmd.Parameters.AddWithValue（“@sex“?textBox4.Text.Trim（））;
????????????cmd.Parameters.AddWithValue（“@grade“?textBox5.Text.Trim（））;
????????????cmd.Parameters.AddWithValue（“@dept“?textBox6.Text.Trim（））;
??????/*????String?sql?=?“insert?into?Table1（snopasswordgradesexdeptname）values（‘“?+?textBox1.Text?+?“‘‘“?+?textBox2.Text?+?“‘，‘“?+?textBox3.Text?+?“‘，‘“?+?textBox4.Text?+?“‘，‘“?+?textBox5.Text?+?“‘，‘“?+?textBox6.Text?+?“‘）“;
????????????SqlCommand?comm?=?new?SqlCommand（sql?conn）;?*/????????
???????????

????????????int?n?=?cmd.ExecuteNonQuery（）;
????????????if?（n>0）
????????????{
????????????????MessageBox.Show（“保存成功“?“ok“）;
????????????????this.Dispose（）;?
????????????????
????????????}
????????????else{MessageBox.Show（“保存失敗“）;}
????????}
????????????catch（Exception?ex）
????????????{
????????????????MessageBox.Show（“保存失敗“ex.MessageMessageBoxButtons.OK）;
????????????}
????????????finally
????????????{
??????????????
????????????????if?（conn.State?==?ConnectionState.Open）?conn.Close（）;

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


????????private?void?label2_Click（object?sender?EventArgs?e）
????????{

????????}

????????private?void?button2_Click（object?sender?EventArgs?e）
????????{
????????????this.Dispose（）;
????????????
????????}

????}
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件????????2512??2020-12-18?17:15??班級(jí)考勤\add.cs
?????文件????????8694??2020-12-17?20:37??班級(jí)考勤\add.Designer.cs
?????文件????????5817??2020-12-17?19:40??班級(jí)考勤\add.resx
?????文件?????????454??2020-12-11?23:45??班級(jí)考勤\app.config
?????目錄???????????0??2020-12-11?23:34??班級(jí)考勤\bin\
?????目錄???????????0??2020-12-12?09:20??班級(jí)考勤\bin\Debug\
?????文件?????2359296??2020-12-18?16:49??班級(jí)考勤\bin\Debug\Database1.mdf
?????文件??????589824??2020-12-18?16:49??班級(jí)考勤\bin\Debug\Database1_log.ldf
?????文件???????29696??2020-12-18?17:31??班級(jí)考勤\bin\Debug\班級(jí)考勤.exe
?????文件?????????454??2020-12-11?23:45??班級(jí)考勤\bin\Debug\班級(jí)考勤.exe.config
?????文件???????75264??2020-12-18?17:31??班級(jí)考勤\bin\Debug\班級(jí)考勤.pdb
?????文件???????11600??2020-12-18?19:08??班級(jí)考勤\bin\Debug\班級(jí)考勤.vshost.exe
?????文件?????????454??2020-12-11?23:45??班級(jí)考勤\bin\Debug\班級(jí)考勤.vshost.exe.config
?????文件?????????490??2019-03-19?12:47??班級(jí)考勤\bin\Debug\班級(jí)考勤.vshost.exe.manifest
?????文件?????2359296??2020-12-18?19:19??班級(jí)考勤\Database1.mdf
?????文件??????589824??2020-12-18?19:19??班級(jí)考勤\Database1_log.LDF
?????文件???????13269??2020-12-11?23:45??班級(jí)考勤\Database1DataSet.Designer.cs
?????文件???????????3??2020-12-11?23:45??班級(jí)考勤\Database1DataSet.xsc
?????文件????????1685??2020-12-11?23:45??班級(jí)考勤\Database1DataSet.xsd
?????文件???????????3??2020-12-11?23:45??班級(jí)考勤\Database1DataSet.xss
?????文件????????2431??2020-12-18?17:21??班級(jí)考勤\Form1.cs
?????文件????????4155??2020-12-16?21:41??班級(jí)考勤\Form1.Designer.cs
?????文件????????5817??2020-12-16?21:41??班級(jí)考勤\Form1.resx
?????文件?????????744??2020-12-16?22:03??班級(jí)考勤\Form2.cs
?????文件????????2680??2020-12-16?22:03??班級(jí)考勤\Form2.Designer.cs
?????文件????????5817??2020-12-16?22:03??班級(jí)考勤\Form2.resx
?????文件????????3072??2020-12-18?17:31??班級(jí)考勤\Form3.cs
?????文件????????6104??2020-12-17?19:40??班級(jí)考勤\Form3.Designer.cs
?????文件????????5817??2020-12-17?19:40??班級(jí)考勤\Form3.resx
?????文件????????2660??2020-12-18?17:05??班級(jí)考勤\Form4.cs
?????文件????????6991??2020-12-18?11:13??班級(jí)考勤\Form4.Designer.cs
............此處省略34個(gè)文件信息