Manually insert auto-incrementing Column

[Csharp]
// Test the inserted auto-increment Column
String sqlstr = "SET IDENTITY_INSERT t1 ON ;";
Lists. Add (sqlstr );
Sqlstr = "insert into t1 (id, name) VALUES (" + I. ToString () + ", '" + I. ToString () + "');";
Lists. Add (sqlstr );
Sqlstr = "set identity_insert t1 off ;";
Lists. Add (sqlstr );
 
Da. SqlCeExecuteNonQuery (lists );

[Csharp]
Public void SqlCeExecuteNonQuery (List <string> lists)
{
SqlCeConnection conn = new SqlCeConnection ();
SqlCeCommand comm = null;
Try
{
Conn. ConnectionString = PDAConnectionLocStr;
Conn. Open ();
Comm = new SqlCeCommand ("", conn );
For (int I = 0; I <lists. Count; I ++)
{
Comm. CommandText = lists [I];
Comm. ExecuteNonQuery ();
}
 
 
 
}
Catch (SqlCeException ex)
{
 
}
Finally
{
Conn. Close ();
Conn. Dispose ();
Comm. Dispose ();
}
}

 

Note: duplicate ID numbers may occur when the auto-incrementing column does not have a primary key.