[C#]修改ACCESS密碼

//mode=12 獨佔模式開啟
string sConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
                           "Data Source=" + Application.StartupPath + @"/位置OOXX.mdb;mode=12;" +
                           "Persist Security Info=False;" +
                           "Jet OLEDB:Database Password=密碼";
//連線
OleDbConnection MyConnection = new OleDbConnection(sConn);
MyConnection.Open();
//修改密碼
string sCmd = "ALTER DATABASE PASSWORD 456 123 ";
            OleDbCommand MyCommand = new OleDbCommand(sCmd, MyConnection);
MyCommand.ExecuteNonQuery();

[C#]TcpClient斷線例外

TcpClient如果直接斷開連線…

之後再連線就會出現通訊埠已開啟無法連線

 

解決方法就

if (!tcpClient.Connected)//沒連線
{
           tcpClient.Client.Close();
           tcpClient.Close();
           tcpClient = new TcpClient();
           System.GC.Collect();
}