csharp: using OleDb Getting the identity of the most recently added record

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59

/// <summary>         /// 执行SQL语句，返回影响的记录数         /// </summary>         /// <param name="SQLString">SQL语句</param>         /// <returns>影响的记录数</returns>         public static int ExecuteSql(string SQLString, params OleDbParameter[] cmdParms)         {             using (OleDbConnection connection = new OleDbConnection(connectionString))             {                 using (OleDbCommand cmd = new OleDbCommand())                 {                     try                     {                         PrepareCommand(cmd, connection, null, SQLString, cmdParms);                         int rows = cmd.ExecuteNonQuery();                         cmd.Parameters.Clear();                         return rows;                     }                     catch (System.Data.OleDb.OleDbException E)                     {                         throw new Exception(E.Message);                     }                 }             }         }         /// <summary>         ///  添加返迴ID值         ///  涂聚文 2014-12-29         ///  Geovin Du         /// 參考：  http://www.mikesdotnetting.com/article/54/getting-the-identity-of-the-most-recently-added-record         /// http://stackoverflow.com/questions/186544/identity-after-insert-statement-always-returns-0         /// </summary>         /// <param name="SQLString"></param>         /// <param name="identity"></param>         /// <param name="cmdParms"></param>         /// <returns></returns>         public static int ExecuteSql(string SQLString, out int identity, params OleDbParameter[] cmdParms)         {                          using (OleDbConnection connection = new OleDbConnection(connectionString))             {                 using (OleDbCommand cmd = new OleDbCommand())                 {                     try                     {                         PrepareCommand(cmd, connection, null, SQLString, cmdParms);                         int rows = cmd.ExecuteNonQuery();                         cmd.CommandText = "Select @@Identity";                         identity = (int)cmd.ExecuteScalar();                         cmd.Parameters.Clear();                         return rows;                     }                     catch (System.Data.OleDb.OleDbException E)                     {                         throw new Exception(E.Message);                     }                 }             }         }