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;
        }

转载于:https://www.cnblogs.com/EasyData/archive/2007/10/04/913789.html