.NET執行insert語句返回自動增長列ID的值

using   System; 
using   System.Data; 
using   System.Data.SqlClient; 

namespace   DbConsoleDemo 
{ 

public   class   InsertDemo 
{ 

public   InsertDemo()   {} 

public   static   void   Test1()   

{ 

SqlConnection   conn   =   new   SqlConnection(Config.RChenConnection); 

using   (conn)   

{ 

SqlCommand   cmd   =   new   SqlCommand(@ "insert   into   IdStore(nextid)   values   (@nextid) 

select   SCOPE_IDENTITY() ",   conn); 

cmd.Parameters.Add( "@nextid ",   123); 

conn.Open(); 

object   o   =   cmd.ExecuteScalar(); 

int   newId   =   Convert.ToInt32(o); 

Console.WriteLine( "新的   id   是：{0} ",   newId); 

conn.Close(); 

} 

Console.ReadLine(); 

} 

} 

}