//插入一条记录后,马上得到新插入记录ID值的方法。
SqlConnection myconn1;
string sql1;
myconn1 = new SqlConnection(ConfigurationManager.ConnectionStrings["BaseConnectionString"].ConnectionString);
myconn1.Open();
sql1 = "insert into biaozhunpin_LQ (LQR,LQRQ,CZY,TXRQ,BZ) values ('" + LQRTextBox.Text.ToString() + "','" + LQRQTextBox.Text.ToString() + "','" + CZYTextBox.Text.ToString() + "','" + TXRQTextBox.Text.ToString() + "','" + strbz +"') select @@identity";
SqlCommand mycommand = new SqlCommand(sql1, myconn1);
Int32 newid;
newid = Int32.Parse(mycommand.ExecuteScalar().ToString()); //取得新插入记录的ID值
myconn1.Close();
myconn1.Open();
Response.Redirect("BiaozhunpinLQMXAdd.aspx?BiaozhunpinLQID=" + newid.ToString()); //取得新插入记录的ID,即可引用之。