Asp.net + sql 存储过程 并获取刚插入的那条数据的ID返回值

try
        {
            myconn.Open();
            SqlCommand cmd = new SqlCommand("add_product", myconn);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("g_c_title",titles.Text);

            SqlParameter i = new SqlParameter("@ids", SqlDbType.Int);
            i.Direction = ParameterDirection.Output;
            cmd.Parameters.Add(i);
            
            if (cmd.ExecuteNonQuery().ToString() == "1")
            {
                string num = cmd.Parameters["@ids"].Value.ToString();
                Response.Write("<script>alert('操作成功" + num + "');location.href='shop_catalog.aspx';</script>");
                Response.End();
            }
            else
            {
                Response.Write("<script>alert('操作失败');location.href='shop_catalog_add.aspx';</script>");
                Response.End();
            }
        }
        catch (SqlException ex)
        {
            Response.Write(ex.Message);
        }
        finally
        {
            myconn.Close();
        }

　　

存储过程代码

create add_product
@g_c_title nvarchar(150),
@ids nvarchar(50) output
as
begin
	insert into goldea_product(g_c_title) values(@g_c_title)
	set @ids=@@IDENTITY
	
end