rx800102的部落格

  using System.Data.OleDb;

  public static OleDbConnection OleDbOpenConn(string Database)
        {
            string cnstr = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Database);
            OleDbConnection icn = new OleDbConnection();
            icn.ConnectionString = cnstr;
            if (icn.State == ConnectionState.Open) icn.Close();
            icn.Open();
            return icn;
        }

        public static DataTable GetOleDbDataTable(string Database, string OleDbString)
        {
            DataTable myDataTable = new DataTable();
            OleDbConnection icn = OleDbOpenConn(Database); //連接資料庫
            OleDbDataAdapter da = new OleDbDataAdapter(OleDbString, icn);
            DataSet ds = new DataSet(); //新增DataSet
            ds.Clear();
            da.Fill(ds);   // 加入的資料列 
            myDataTable = ds.Tables[0]; //
            if (icn.State == ConnectionState.Open) icn.Close();
            return myDataTable;
        }

        public static void OleDbInsertUpdateDelete(string Database, string OleDbSelectString)  //新增查詢修改專用
        {
            string cnstr = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Database);
            OleDbConnection icn = OleDbOpenConn(cnstr); //連接資料庫
            OleDbCommand cmd = new OleDbCommand(OleDbSelectString, icn);
            cmd.ExecuteNonQuery();
            if (icn.State == ConnectionState.Open) icn.Close();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string sql = "select * from tbFTP" ;
            DataTable dt = GetOleDbDataTable(@"C:\Users\8044\Desktop\FrontBackMerge.mdb", sql);
            dataGridView1.DataSource = dt;
        }