ADO.net 里面获取返回值的方法为(c#):

        public   int  InsertFileContent( string  filename, string  filebrief, byte [] content, string  filetype, int  sort )
         ... {
            int id = 0;
            using (SqlConnection con = new SqlConnection(this.sqlConString))
            ...{
                con.Open();
                SqlCommand cmd = new SqlCommand();
                cmd.CommandText = "insFilecontent";
                cmd.Connection = con;
                cmd.CommandType = CommandType.StoredProcedure;
                SqlParameter parm = new SqlParameter("@filename", SqlDbType.NChar, 200);
                parm.Value = filename;
                cmd.Parameters.Add(parm);
                parm = new SqlParameter("@filebrief", SqlDbType.NChar, 500);
                parm.Value = filebrief;
                cmd.Parameters.Add(parm);
                parm = new SqlParameter("@filecontent", SqlDbType.VarBinary);
                parm.Value = content;
                cmd.Parameters.Add(parm);
                parm = new SqlParameter("@filetype", SqlDbType.NChar, 50);
                parm.Value = filetype;
                cmd.Parameters.Add(parm);
                parm = new SqlParameter("@filesort", SqlDbType.Int);
                parm.Value = filetype;
                cmd.Parameters.Add(parm);
                SqlParameter parmoutid = new SqlParameter("@id", SqlDbType.Int);//输出值
                parmoutid.Direction = ParameterDirection.Output;
                cmd.Parameters.Add(parmoutid);
                cmd.ExecuteNonQuery();
                id = (int)parmoutid.Value;
                result = true;
                con.Close();
            }
            return id;
        }