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

namespace?WF_0811PM
{
????public?partial?class?Form1?:?Form
????{
????????SqlConnection?con?;
????????SqlCommand?com;
????????SqlDataAdapter?da;
????????SqlDataReader?dr;
????????DataTable?dt;
????????string?xh;

????????public?Form1（）
????????{
????????????InitializeComponent（）;
????????}

????????private?void?Form1_Load（object?sender?EventArgs?e）
????????{
????????????//方法五
????????????//string?strCon?=?“server?=?.;database?=?stu;integrated?security?=?true“;

????????????string?strCon?=?File.ReadAllText（Application.StartupPath??+?@“..\..\..\conn.txt“）;

????????????string?sql?=?“select?sid?學號sname?姓名sex?性別sage?年齡?from?student?order?by?sid?desc“;

????????????con?=?new?SqlConnection（strCon）;
????????????//con.ConnectionString?=?strCon;
????????????con.Open（）;

????????????com?=?new?SqlCommand（sqlcon）;
????????????//設置連接
????????????//com.Connection?=?con;

????????????//設置將要執行的查找語句
????????????//com.CommandText?=?sql;

????????????//com.ExecuteNonQuery（）;????//常用于執行增刪改?????????????????????????
????????????//com.ExecuteScalar（）;??????//常用于執行查找，返回結果集中的第一個單元格

????????????//注意：dr之缺點:只讀，只進，不支持綁定
????????????dr?=?com.ExecuteReader（）;??????//常用于執行查找，返回SqlDataReader對象<只讀，只進>

????????????dt?=?new?DataTable（）;

????????????dt.Clear（）;

????????????//把dr裝載到dt
????????????dt.Load（dr）;

????????????//綁定
????????????this.dataGridView1.DataSource?=?dt;????????????

????????}

????????//增
????????private?void?button1_Click（object?sender?EventArgs?e）
????????{
????????????//設置連接
????????????//com.Connection?=?con;????????????
????????????//配置增加語句
????????????com.CommandText?=?“insert?student??values（‘“?+?this.textBox1.Text?+?“‘‘“?+?this.textBox2.Text?+?“‘‘“+?this.textBox3.Text?+“‘“+this.textBox4.Text+“）“;
????????????
????????????try
????????????{
????????????????//執行增加語句
????????????????com.ExecuteNonQuery（）;
????????????????MessageBox.Show（“增加成功！“?“增加“?MessageBoxButtons.OKMessageBoxIcon.Information）;

????????????????Form1_Load（sender?e）;
????????????}
????????????catch（Exception?ex）
????????????{
????????????????MessageBox.Show（ex.Message?“錯誤“?MessageBoxButtons.OK?MessageBoxIcon.Information）;
????????????}
????????????
????????????
????????}

????????//刪
????????private?void?button2_Click（object?sender?EventArgs?e）
????????{
????????????//CurrentRow?當前單擊的那一行

????????????//xh?=?this.dataGridView1.CurrentRow.Cells[0].Value.ToString（）;

????????????com.CommandText?=?“delete??student?where?sid?=?“?+?xh?+?““;

????????????DialogResult?dlg?=?MessageBox.Show（“真的要刪除?“?“刪除“?MessageBoxButtons.OKCancel?MessageBoxIcon.Question）;

????????????if?（dlg?==?DialogResult.OK）
????????????{
????????????????//執行刪除語句，從數據庫刪除?
????????????????com.Execu

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件?????????52??2008-08-11?10:05??WF_0811PM\代碼與實例\conn.txt

?????文件???????6091??2009-02-28?23:07??WF_0811PM\代碼與實例\Form1.cs

?????文件??????10467??2008-11-19?08:56??WF_0811PM\代碼與實例\Form1.Designer.cs

?????文件???????6010??2008-11-19?08:55??WF_0811PM\代碼與實例\Form1.resx

?????文件????????468??2008-08-11?08:29??WF_0811PM\代碼與實例\Program.cs

?????文件???????3509??2008-08-20?14:17??WF_0811PM\代碼與實例\UpgradeLog.xml

?????文件???????3433??2008-08-20?14:17??WF_0811PM\代碼與實例\WF_0811PM.csproj

?????文件??????24576??2008-11-19?08:56??WF_0811PM\代碼與實例\WF_0811PM.exe

?????文件????????906??2008-11-18?11:06??WF_0811PM\代碼與實例\WF_0811PM.sln

?????文件??????13312??2009-02-28?23:00??WF_0811PM\代碼與實例\WF_0811PM.suo

?????目錄??????????0??2009-02-28?23:25??WF_0811PM\代碼與實例

????..A.SH.??????5120??2009-02-28?23:25??WF_0811PM\圖\Thumbs.db

?????文件??????21637??2009-02-28?23:24??WF_0811PM\圖\tuxiang.JPG

?????目錄??????????0??2009-02-28?23:25??WF_0811PM\圖

?????文件????????186??2009-02-28?23:30??WF_0811PM\說明.txt

?????目錄??????????0??2009-02-28?23:26??WF_0811PM

-----------?---------??----------?-----??----

????????????????95767????????????????????16