学步园

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