C#和MS Access -用于在应用程序开始时创建表、列和添加值的SQL

using System;
using System.Data.OleDb;

class Program
{
    static void Main()
    {
        string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\path\\to\\database.accdb";
        
        using (OleDbConnection connection = new OleDbConnection(connectionString))
        {
            connection.Open();
            
            // 创建表
            string createTableQuery = "CREATE TABLE TableName (Column1 INT, Column2 VARCHAR(255))";
            OleDbCommand createTableCommand = new OleDbCommand(createTableQuery, connection);
            createTableCommand.ExecuteNonQuery();
            
            // 添加值
            string insertQuery = "INSERT INTO TableName (Column1, Column2) VALUES (1, 'Value')";
            OleDbCommand insertCommand = new OleDbCommand(insertQuery, connection);
            insertCommand.ExecuteNonQuery();
        }
    }
}