aaa.aspx.cs页面怎么接受 @@identity的返回值求帮助！！！

Question

后台代码
 #region==添加并返回 主见==
        public static void Add_return_id(string hotel_name, string hotel_star, double hotel_price_low, double hotel_price_high, string hotel_phone, string hotel_info, string hotel_image, string hotel_res, string hotel_address, int hotel_type, int hotel_linkman_id)
        {
            string sql = "insert into [erp_hotel](hotel_name,hotel_star,hotel_price_low,hotel_price_high,hotel_phone,hotel_info,hotel_image,hotel_res,hotel_address,hotel_type,hotel_linkman_id) values(";
            sql += "'" + hotel_name + "'";
            sql += ",'" + hotel_star + "'";
            sql += ",'" + hotel_price_low + "'";
            sql += ",'" + hotel_price_high + "'";
            sql += ",'" + hotel_phone + "'";
            sql += ",'" + hotel_info + "'";
            sql += ",'" + hotel_image + "'";
            sql += ",'" + hotel_res + "'";
            sql += ",'" + hotel_address + "'";
            sql += "," + hotel_type + "";
            sql += "," + hotel_linkman_id + "";
            sql += ")";
            sql += "select @@identity;";            DAL.sqlH.ExecuteNonQuery(sql);
        }
        #endregion
前台页面里怎么去接收 select @@identity 返回的id; 不用存储过程，，求代码。 要是我这个方法有问题谢谢 各位给我指出怎么改！！

Answer 1

sql += ");";
  sql += "select @@identity;";

Answer 2

不用ExecuteNonQuery方法，用ExecuteScalar返回第一行第一列的数据