我想得到刚插入的数据的主键值，如果由于“并发”造成取得的不是最新的主键值怎么办？

Question

有什么办法，代码如下：
 
   protected void Button1_Click(object sender, EventArgs e)
    {
        string messageID = "";        conn.Open();
        SqlCommand cmd = new SqlCommand("insert into message(Content,sendTime,sendid) values ('" + TextArea1.Value + "',getdate() ,'1')", conn);
        cmd.ExecuteNonQuery();        SqlCommand cmd2 = new SqlCommand("select ident_current('message')", conn);
        SqlDataReader sdr2 = cmd2.ExecuteReader();
        if (sdr2.Read())
        {
            messageID = sdr2[0].ToString();
        }
        conn.Close();        string s = HiddenField1.Value;
        string[] sArray = s.Split(',');
        foreach (string i in sArray)
        {
            if (i.ToString() != "")
            {
                conn.Open();
                SqlCommand cmd3 = new SqlCommand("insert into receiveID(receiveID,messageID) values ('" + i.ToString() + "','" + messageID + "')", conn);
                cmd3.ExecuteNonQuery();
                conn.Close();               
            }
        }
        Response.Write("<script>window.opener.location.reload();window.close();</script>");
    }

Answer 1

eg:
insert into Position(Title,Level,Description) values('aaaa',5,'dfjk'); select @@IDENTITY AS 'identity';这么写

Answer 2

insert ...;select SCOPE_IDENTITY();
SqlCommand cmd = new SqlCommand(Sql, connection);
result = (int)cmd.ExecuteScalar();

Answer 3

插入数据后返回刚刚插入的记录的主键执行messageID = Convert.ToInt32(cmd.ExecuteScalar());

Answer 4

SqlCommand cmd = new SqlCommand("insert into message(Content,sendTime,sendid) values ('" + TextArea1.Value + "',getdate() ,'1'); select @@IDENTITY", conn);conn.Open();
//执行查询并取出执行结果messageID 
messageID  = (Int32)cmd .ExecuteScalar();
//关闭数据库连接
con.Close();

Answer 5

 StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into gendan(");
            strSql.Append("yixiang,isXianxiahuodong,yuJiShouRu,yuJiSRDate,addTime,modifyTime,genDanRen,danwei,linkMan,lkmZhiwu,lkmTel,fristLkTime,daiLiShang,dlsLinkMan,hyType)");
            strSql.Append(" values (");
            strSql.Append("@yixiang,@isXianxiahuodong,@yuJiShouRu,@yuJiSRDate,@addTime,@modifyTime,@genDanRen,@danwei,@linkMan,@lkmZhiwu,@lkmTel,@fristLkTime,@daiLiShang,@dlsLinkMan,@hyType)");
            strSql.Append(";set @ReturnValue= @@IDENTITY");