如何操作access数据库，创建一个表？

Question

现在在做一个winfrom程序，通过access数据库保存数据，有个想法是可以读入用户输入的字符串，然后在数据库文件中建立一个以此字符串为名的表。但小弟不才，一直未弄懂实现方法。请高手赐教

Answer 1

    public abstract class DBase
    {
        protected OleDbConnection conn;
        private void openConnection()
        {
            if (conn.State == ConnectionState.Closed)
            {
                conn.Open();
            }
        }        private void closeConnection()
        {
            if (conn.State == ConnectionState.Open)
            {
                conn.Close();
            }
        }        public int Query(string sql)
        {
            try
            {
                OleDbCommand cmd = new OleDbCommand(sql, conn);
                openConnection();
                return cmd.ExecuteNonQuery();
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message);
            }
            return -1;
        }        public void openConnection(string connectionString)
        {
            conn = new OleDbConnection(connectionString);
        }        public OleDbConnection getConnection()
        {
            return conn;
        }
    }
    
    class AxsDatabase : DBase
    {
        public AxsDatabase(string dbName)
        {
            string connectionString =
                "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +dbName;
            openConnection(connectionString);
        }
    }    static class Program
    {
        static void Main()
        {
            AxsDatabase dbase = new AxsDatabase("test.mdb");
            string sql = "create table test3444 ( id int,name text)";
            dbase.Query(sql);
        }
    }

Answer 2

呵呵，其实也想到这层了~主要是建表的sql语句的没弄对。学艺不精啊~结贴了