Primary key autoincrement not working

Hi ,

It looks like you’re trying to create a table with an auto-incrementing primary key in C#. I noticed a few things that might need adjustment. Here’s a revised version of your code:

string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FileBinPath;
using (OleDbConnection connection = new OleDbConnection(connectionString))
{
    Catalog catalog = new Catalog();
    catalog.Create(connectionString);

    Table table = new Table();
    table.Name = "Users";

    // Define the ID column
    Column columnId = new Column();
    columnId.Name = "ID";
    columnId.Type = ADOX.DataTypeEnum.adInteger;
    columnId.Properties["AutoIncrement"].Value = true;
    columnId.Properties["Seed"].Value = 1;
    columnId.Properties["Increment"].Value = 1;
    columnId.Properties["Nullable"].Value = false;

    // Define the Name column
    Column nameCol = new Column();
    nameCol.Name = "Name";
    nameCol.Type = ADOX.DataTypeEnum.adVarWChar;
    nameCol.DefinedSize = 60;

    // Append columns to the table
    table.Columns.Append(columnId);
    table.Columns.Append(nameCol);

    // Append the table to the catalog
    catalog.Tables.Append(table);
}

// Assuming you want to bind the table to a DataGridView
DataGridView1.DataSource = table;

Key changes:

1. Column Definition: Used ADOX.Column instead of DataColumn for defining the columns.
2. AutoIncrement Properties: Set the AutoIncrement, Seed, and Increment properties directly on the columnId.
3. Nullable Property: Set the Nullable property to false for the ID column.

Thanks