Creating an Autoincrementing Primary Key : DataColumn « ADO.Net « C# / CSharp Tutorial

1. C# / CSharp Tutorial
2. ADO.Net
3. DataColumn

using System;
using System.Data;

    class Program
    {
        static void Main(string[] args)
        {
            DataTable dt = new DataTable();
            DataColumn pkCol = dt.Columns.Add("Id", typeof(int));
            dt.Columns.Add("Field1", typeof(string)).MaxLength = 50;

            dt.PrimaryKey = new DataColumn[] {dt.Columns["Id"]};

            pkCol.AutoIncrement = true;
            pkCol.AutoIncrementSeed = 100;
            pkCol.AutoIncrementStep = 10;

            for (int i = 1; i <= 5; i++)
                dt.Rows.Add(new object[] {null, "Value " + i });

            foreach (DataRow row in dt.Rows)
                Console.WriteLine("Id = {0}\tField1 = {1}",row["Id"], row["Field1"]);
        }
    }