Ks Notes

using System.Data.SqlClient;

#region  建立Sql資料庫連接
/// <summary>
/// 建立Sql資料庫連接.
/// </summary>
/// <returns>傳回SqlConnection對象</returns>
public SqlConnection getcon()
{                                               //來源資料庫位址              sql帳號            sql密碼                    資料庫名稱
 string str = "Data Source=\"User-PC\\SQL\"; User id=\"test\"; PWD=\"1234\"; Database=\"db_GTRS\";";
 SqlConnection myCon = new SqlConnection(str);
return myCon;
}
#endregion

        #region  執行SqlCommand命令
        /// <summary>
        /// 執行SqlCommand
        /// </summary>
        /// <param name="sqlStr">SQL語句</param>
        public void getcom(string sqlStr)
        {
            SqlConnection sqlcon = this.getcon();  //this.getcon  使用上面getcon method ↑
            sqlcon.Open();
            SqlCommand sqlcom = new SqlCommand(sqlStr, sqlcon);
            sqlcom.ExecuteNonQuery();
            sqlcom.Dispose();
            sqlcon.Close();
            sqlcon.Dispose();
        }
        #endregion