C#访问SQL/Accsee数据库实例

 public DataSet FillDataSet()

        {

            SqlConnection conn = new SqlConnection("server=(local);Integrated Security=true;Initial Catalog=master;");

            SqlCommand cmd = new SqlCommand("SELECT [name], [filename] FROM dbo.sysdatabases", conn);

            SqlDataAdapter da = new SqlDataAdapter(cmd);



            DataSet ds = new DataSet();



            try

            {

                conn.Open();



                try

                {

                    da.Fill(ds);    // fill DataSet with data

                }

                catch (Exception)

                {

                    return null;

                }

                finally

                {

                    conn.Close();

                    conn.Dispose();

                }

            }

            catch (Exception)

            {

                return null;

            }



            return ds;

        }        private DataTable FillDataTableByAccess()

        {

            string connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=/"" + System.IO.Path.GetFullPath("db1.mdb") + "/"";



            System.Data.OleDb.OleDbConnection oledbConn = new System.Data.OleDb.OleDbConnection(connString);

            System.Data.OleDb.OleDbCommand oledbCom = new System.Data.OleDb.OleDbCommand("SELECT * FROM 客户表",oledbConn);

            System.Data.OleDb.OleDbDataAdapter oledbDr = new System.Data.OleDb.OleDbDataAdapter(oledbCom);



            DataTable dt = new DataTable();

            try

            {

                oledbConn.Open();



                try

                {

                    oledbDr.Fill(dt);

                }

                catch (Exception exc)

                {

                    MessageBox.Show(exc.Message);

                }

                finally

                {

                    oledbConn.Close();

                    oledbConn.Dispose();

                }

            }

            catch (Exception exc)

            {

                MessageBox.Show(exc.Message);

            }            



            return dt;

        }