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

来源：互联网发布：linux 查看用户所在组编辑：程序博客网时间：2024/06/05 02:00
 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;        }