手動插入自增列

[csharp] 
//測試插入自增列 
               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(); 
           } 
       } 

注意:自增列沒有主鍵 手動插入可能發生ID號重復的情況