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/4873