获取最后一次插入标识列的值

 

 string con = ConfigurationManager.ConnectionStrings["ApplicationServices"].ToString();

       
            StringBuilder sb = new StringBuilder();
            sb.Append(" insert into a(name) values('ss') ");
            sb.Append("declare @ident int");
            sb.Append(" select @ident=@@identity");
            sb.Append(" select @ident");
            SqlDataAdapter da = new SqlDataAdapter(sb.ToString(), con);

            DataSet ds = new DataSet();
            da.Fill(ds);
            Response.Write(ds.Tables[0].Rows[0][0].ToString());