using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?MySql.Data.MySqlClient;

namespace?Connect
{
????class?Program
????{
????????static?void?Main（string[]?args）
????????{
????????????#region?連接數(shù)據(jù)庫(kù)
????????????//創(chuàng)建MySqlConnection對(duì)象
????????????MySqlConnection?conn?=?null;
????????????//連接數(shù)據(jù)庫(kù)，依次是主機(jī)名或IP地址（這里是本地）、數(shù)據(jù)庫(kù)名稱、用戶名、密碼、字符集說明（不加字符集說明，中文會(huì)出現(xiàn)亂碼）
????????????conn?=?new?MySqlConnection（“Data?Source?=?localhost;Database?=?test;?User?ID?=?root;?Password?=?abc123;Charset=utf8“）;
????????????//打開對(duì)象
????????????conn.Open（）;???
????????????//判斷conn狀態(tài)
????????????if?（conn.State.ToString（）?==?“Open“）?
????????????{
????????????????Console.WriteLine（“連接成功“）;
????????????}
????????????else
????????????{
????????????????Console.WriteLine（“連接失敗“）;
????????????}
????????????
????????????#endregion

????????????#region?操作數(shù)據(jù)庫(kù)
????????????//第一種創(chuàng)建sql語句方式
????????????MySqlCommand?com?=?new?MySqlCommand（“UPDATE?website?SET?url?=?‘www.baidu.com‘?WHERE?name?=?‘百度‘“?conn）;

????????????//第二種創(chuàng)建sql語句方式
????????????//MySqlCommand?com?=?new?MySqlCommand（）;
????????????//com.Connection?=?conn;
????????????//com.CommandText?=?“UPDATE?website?SET?url?=?‘www.taobao.com‘?WHERE?name?=?‘淘寶‘?“;
????????????
????????????//返回影響表的行數(shù)
????????????int?rows?=?com.ExecuteNonQuery（）;
????????????if?（rows?>?0）
????????????{
????????????????Console.WriteLine（“修改行數(shù)為“?+?rows）;
????????????}
????????????else
????????????{
????????????????Console.WriteLine（“執(zhí)行失敗“）;
????????????}
????????????Console.ReadKey（）;
????????????#endregion
????????}
????}
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-09-11?19:25??Connect\
?????目錄???????????0??2017-09-09?10:22??Connect\Connect\
?????文件????????2570??2017-09-09?10:27??Connect\Connect\Connect.csproj
?????文件????????1879??2017-09-09?11:50??Connect\Connect\Program.cs
?????目錄???????????0??2017-09-09?10:22??Connect\Connect\Properties\
?????文件????????1346??2017-09-09?10:22??Connect\Connect\Properties\AssemblyInfo.cs
?????目錄???????????0??2017-09-09?10:22??Connect\Connect\bin\
?????目錄???????????0??2017-09-09?10:27??Connect\Connect\bin\Debug\
?????文件????????5632??2017-09-09?11:44??Connect\Connect\bin\Debug\Connect.exe
?????文件???????13824??2017-09-09?11:44??Connect\Connect\bin\Debug\Connect.pdb
?????文件???????11600??2017-09-11?19:10??Connect\Connect\bin\Debug\Connect.vshost.exe
?????文件?????????490??2010-03-17?22:39??Connect\Connect\bin\Debug\Connect.vshost.exe.manifest
?????目錄???????????0??2017-09-09?10:22??Connect\Connect\obj\
?????目錄???????????0??2017-09-09?10:22??Connect\Connect\obj\x86\
?????目錄???????????0??2017-09-09?11:44??Connect\Connect\obj\x86\Debug\
?????文件?????????456??2017-09-11?19:10??Connect\Connect\obj\x86\Debug\Connect.csproj.FileListAbsolute.txt
?????文件????????5632??2017-09-09?11:44??Connect\Connect\obj\x86\Debug\Connect.exe
?????文件???????13824??2017-09-09?11:44??Connect\Connect\obj\x86\Debug\Connect.pdb
?????文件????????5982??2017-09-09?11:44??Connect\Connect\obj\x86\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????目錄???????????0??2017-09-11?19:26??Connect\Connect\obj\x86\Debug\TempPE\
?????文件?????????863??2017-09-09?10:22??Connect\Connect.sln
?????文件???????16384??2017-09-11?09:10??Connect\Connect.suo
?????文件?????????167??2017-09-11?19:25??Connect\使用說明.txt