用c#在Access数据库中创建新表

生成表NewTable，该表有文本字段Field1和整型字段Field2

   private void CreateNewTable()
  { 
   OleDbConnection conn = new OleDbConnection("Provider= Microsoft.JET.OLEDB.4.0;" +
    @"data source = ..//..//db/CodeTableManager.mdb");
   conn.Open();    
   
   string dbstr = "CREATE TABLE NewTable(Field1 TEXT(30), Field2 INTEGER)";
   OleDbCommand oleDbCom = new OleDbCommand(dbstr,conn);    
   oleDbCom.ExecuteNonQuery();
   conn.Close();
  }

转载于:https://www.cnblogs.com/SamllBaby/p/3637658.html