c#連接MDB,SQL數(shù)據(jù)庫代碼

c#數(shù)據(jù)庫連接代碼
    ///系統(tǒng)引用
    using System.Data;
    using System.Data.OleDb;
    using System.Data.SqlClient;
    ///

    /// 必需的設(shè)計(jì)器變量。
    ///

    private System.ComponentModel.Container components = null;
    private System.Data.DataSet myDataSet;
    c#本地MDB數(shù)據(jù)庫連接
    private void menuItem2_Click(object sender, System.EventArgs e)
     {
     try
     {
     //創(chuàng)建一個 OleDbConnection對象
     string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = ../../database/MDB數(shù)據(jù)庫名稱.mdb" ;
     OleDbConnection myConn = new OleDbConnection ( strCon ) ;
     string strCom = " SELECT * FROM 數(shù)據(jù)表名稱" ;
     //創(chuàng)建一個 DataSet對象
     myDataSet = new DataSet ( ) ;
     myConn.Open ( ) ;
     OleDbDataAdapter myCommand = new OleDbDataAdapter ( strCom , myConn ) ;
     myCommand.Fill ( myDataSet , "數(shù)據(jù)表名稱" ) ;
     myConn.Close ( ) ;
     //關(guān)閉連接
     statusBar1.Text="本地MDB數(shù)據(jù)庫連接成功";
     }
     catch ( Exception ex )
     {
     statusBar1.Text="本地MDB數(shù)據(jù)庫連接失敗";
     MessageBox.Show ( "連接本地MDB數(shù)據(jù)庫發(fā)生錯誤：" + ex.ToString ( ) , "錯誤！" ) ;
     }
     }
    c#遠(yuǎn)程MDB數(shù)據(jù)庫連接
    c#本地SQL數(shù)據(jù)庫連接
    private void menuItem3_Click(object sender, System.EventArgs e)
     {
     try
     {
     //創(chuàng)建一個 SqlConnection對象
     string strCon = "Integrated Security=SSPI;Initial Catalog='數(shù)據(jù)庫名稱';Data Source='本地計(jì)算機(jī)名';User ID='登錄用戶名';Password='登錄用戶密碼';Connect Timeout=30";
     SqlConnection myConn = new SqlConnection ( strCon ) ;
     string strCom = " SELECT * FROM 數(shù)據(jù)表名稱" ;
     //創(chuàng)建一個 DataSet對象
     myDataSet = new DataSet ( ) ;
     myConn.Open ( ) ;
     SqlDataAdapter myCommand = new SqlDataAdapter ( strCom , myConn ) ;
     myCommand.Fill ( myDataSet , "數(shù)據(jù)表名稱" ) ;
     myConn.Close ( ) ;
     //關(guān)閉連接
     statusBar1.Text="本地SQL數(shù)據(jù)庫連接成功";
     }
     catch ( Exception ex1 )
     {
     statusBar1.Text="本地SQL數(shù)據(jù)庫連接失敗";
     MessageBox.Show ( "連接本地SQL數(shù)據(jù)庫發(fā)生錯誤：" + ex1.ToString ( ) , "錯誤！" ) ;