C# (CSharp) SGCL.DAO dbConnectionMySql.Output_String_SP Examples

Example #1

        public string ObtenerNombreByIdentificador(string num_iden_come, int come_oid_come_aten)
        {
            dbConnectionMySql oDB = new dbConnectionMySql();

            MySqlParameter[] sqlParameters = new MySqlParameter[3];
            sqlParameters[0] = new MySqlParameter("?p_num_iden_come", num_iden_come);
            sqlParameters[1] = new MySqlParameter("?p_come_oid_come_aten", come_oid_come_aten);
            sqlParameters[2] = new MySqlParameter("?p_val_resu", MySqlDbType.VarChar, 500, ParameterDirection.Output, true, 0, 0, null, DataRowVersion.Current, null);

            string result;

            result = oDB.Output_String_SP("sp_Comensal_NombreByIdentificador", sqlParameters);

            return(result);
        }