using?System;
using?System.Windows.Forms;
using?MySql.Data.MySqlClient;
using?System.Data;
using?System.Data.SqlClient;

namespace?MysqlApp
{
????public?partial?class?Form1?:?Form
????{
????????private?static?string?DB_CON_STR?=?“server=localhost;uid=root;pwd=991446;database=jhsc“;
????????string?sql;
????????MySqlCommand?cmd;

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

????????private?void?button1_Click（object?sender?EventArgs?e）
????????{
????????????MySqlConnection?con?=?new?MySqlConnection（DB_CON_STR）;
?
????????????try{

????????????con.Open（）;

????????????if?（this.textBox1.Text?==?““）
????????????{
????????????????MessageBox.Show（“請輸入id值“）;
????????????}
????????????else
????????????{
????????????????textBox5.Text?=?“連接成功！“;
????????????}
????????????sql?=?“select?*?from?dcsdata?where?id?=?‘“+textBox1.Text?+“‘;“;

????????????cmd?=?con.CreateCommand（）;

????????????//?定義需要執行的SQL語句.
????????????cmd.CommandText?=?sql;

????????????//?執行SQL命令，結果存儲到Reader中.
????????????MySqlDataReader?testReader?=?cmd.ExecuteReader（）;

????????????//?處理檢索出來的每一條數據.
????????????while?（testReader.Read（））
????????????{??????????????
????????????????this.textBox2.Text?=?testReader.GetString（1）;
????????????????this.textBox3.Text?=?testReader.GetString（2）;
????????????????this.textBox4.Text?=?testReader.GetString（3）;
????????????}
???????????
????????????}
????????????catch?（Exception?ex）
????????????{
????????????????MessageBox.Show（ex.Message）;
????????????}
????????????finally
????????????{?????????????
????????????????con.Close（）;
????????????}???
????????}

????????private?void?button2_Click（object?sender?EventArgs?e）
????????{
?????????????MySqlConnection?con?=?new?MySqlConnection（DB_CON_STR）;?

????????????con.Open（）;?

?

????????????MySqlCommand?cmd?=?new?MySqlCommand（“INSERT?INTO?dcsdata??values?（‘“?+?textBox1.Text?+“‘‘“
?????????????????????????????????????????????????????????????????????????????????+?textBox2.Text?+“‘‘“
?????????????????????????????????????????????????????????????????????????????????+?textBox3.Text?+“‘‘“
?????????????????????????????????????????????????????????????????????????????????+?textBox4.Text+“‘）;“）;?

????????????cmd.Connection?=?con;?

????????????cmd.Prepare（）;?

????????????//cmd.Parameters.AddWithValue（“@name“?textBox1.Text）;?
????????????try
????????????{
????????????????int?i?=?cmd.ExecuteNonQuery（）;

????????????????if?（i?>?0）
????????????????{

????????????????????MessageBox.Show（“插入記錄成功“）;
????????????????}
????????????}
????????????catch?（Exception?ex）
????????????{
????????????????MessageBox.Show（“id?不能重復“）;
????????????}
????????}
????}
}

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

?????文件?????294912??2013-04-30?09:38??MysqlApp\MysqlApp\bin\Debug\MySql.Data.dll

?????文件??????11776??2013-04-30?20:03??MysqlApp\MysqlApp\bin\Debug\MysqlApp.exe

?????文件??????26112??2013-04-30?20:03??MysqlApp\MysqlApp\bin\Debug\MysqlApp.pdb

?????文件??????11600??2013-04-30?20:04??MysqlApp\MysqlApp\bin\Debug\MysqlApp.vshost.exe

?????文件????????490??2010-03-17?22:39??MysqlApp\MysqlApp\bin\Debug\MysqlApp.vshost.exe.manifest

?????文件???????2860??2013-04-30?20:02??MysqlApp\MysqlApp\Form1.cs

?????文件???????7998??2013-04-30?19:55??MysqlApp\MysqlApp\Form1.Designer.cs

?????文件???????5817??2013-04-30?19:55??MysqlApp\MysqlApp\Form1.resx

?????文件???????3787??2013-04-30?09:33??MysqlApp\MysqlApp\MysqlApp.csproj

?????文件???????4440??2013-04-30?15:57??MysqlApp\MysqlApp\obj\x86\Debug\DesignTimeResolveAssemblyReferences.cache

?????文件???????6214??2013-04-30?20:03??MysqlApp\MysqlApp\obj\x86\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件????????200??2013-04-30?19:55??MysqlApp\MysqlApp\obj\x86\Debug\GenerateResource.read.1.tlog

?????文件????????502??2013-04-30?19:55??MysqlApp\MysqlApp\obj\x86\Debug\GenerateResource.write.1.tlog

?????文件????????650??2013-04-30?20:04??MysqlApp\MysqlApp\obj\x86\Debug\MysqlApp.csproj.FileListAbsolute.txt

?????文件??????11776??2013-04-30?20:03??MysqlApp\MysqlApp\obj\x86\Debug\MysqlApp.exe

?????文件????????180??2013-04-30?19:55??MysqlApp\MysqlApp\obj\x86\Debug\MysqlApp.Form1.resources

?????文件??????26112??2013-04-30?20:03??MysqlApp\MysqlApp\obj\x86\Debug\MysqlApp.pdb

?????文件????????180??2013-04-30?09:33??MysqlApp\MysqlApp\obj\x86\Debug\MysqlApp.Properties.Resources.resources

?????文件??????14275??2013-04-30?09:33??MysqlApp\MysqlApp\obj\x86\Debug\ResolveAssemblyReference.cache

?????文件????????489??2013-04-30?09:08??MysqlApp\MysqlApp\Program.cs

?????文件???????1348??2013-04-30?09:08??MysqlApp\MysqlApp\Properties\AssemblyInfo.cs

?????文件???????2866??2013-04-30?09:08??MysqlApp\MysqlApp\Properties\Resources.Designer.cs

?????文件???????5612??2013-04-30?09:08??MysqlApp\MysqlApp\Properties\Resources.resx

?????文件???????1093??2013-04-30?09:08??MysqlApp\MysqlApp\Properties\Settings.Designer.cs

?????文件????????249??2013-04-30?09:08??MysqlApp\MysqlApp\Properties\Settings.settings

?????文件????????866??2013-04-30?09:08??MysqlApp\MysqlApp.sln

????..A..H.?????21504??2013-04-30?20:04??MysqlApp\MysqlApp.suo

?????目錄??????????0??2013-04-30?09:08??MysqlApp\MysqlApp\obj\x86\Debug\TempPE

?????目錄??????????0??2013-04-30?20:06??MysqlApp\MysqlApp\obj\x86\Debug

?????目錄??????????0??2013-04-30?20:06??MysqlApp\MysqlApp\bin\Debug

............此處省略9個文件信息