asp.netÈçºÎÈ¡µÃÐÂÔö¼Ç¼µÄ×Ô¶¯±àºÅID°ï°ïÎÒ°É

private   void   Button1_Click(object   sender,   System.EventArgs   e)
{
string   ACconnStr= "server=XCH;uid=sa;pwd=;database=aaa ";//¶¨ÒåÊý¾Ý¿âÁ¬½Ó×Ö·û´®
SqlConnection   ACconn=new   SqlConnection(ACconnStr);   //´´½¨Á¬½Ó¶ÔÏñ
try
{
string   ACsql   =   "Insert   into   Table1(id,notices)   values   ( ' "+txtTitle.Text+ " ', ' "+txtContent.Text+ " ') ";
SqlCommand   ACcomm=new   SqlCommand(ACsql,ACconn);//´´½¨Command¶ÔÏñ
ACconn.Open();//´ò¿ªÁ¬½Ó
ACcomm.ExecuteNonQuery();//Ö´ÐÐsql
lblSuccess.Text   =   "Ìá½»³É¹¦£¡ ";
Response.Write( " <script       language=javascript> alert( '²Ù×÷³É¹¦ ');window.location.href=window.location.href; </script> ");      
}
catch
{
lblSuccess.Text   =   "Ìύʧ°Ü£¡ ";
}
//¹Ø±ÕÊý¾Ý¿â
ACconn.Close();
}

---

È¡µÄеÄÊý¾ÝµÄÖ÷¼ü? insertÖ®ºóÓÃselect @@identity

---

up Â¥ÉÏÕý½â

---

¿É²»¿ÉÒÔд¸ö ÍêÕûµÄ´úÂë ÎÒÊDzËÄñ лл

---

Insert  into  Table1(id,notices) values  ( 'xxx ', 'xxx') select @@identity
Õâ¾ä»° ·µ»ØÒ»¸ödatatable £¬Ìí¼ÓµÄÖ÷¼üID ¾ÍÊÇÕâ¸ödatatableµÄµÚÒ»ÐÐ µÚÒ»ÁÐ µÄÖµ¡£

---

stri