用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();
  }

posted @ 2014-04-01 10:05  天羽星河落  阅读(1513)  评论(1编辑  收藏  举报