Ejecutar un SP con parametro

juliancab · 1 Febrero, 2019 01:35

jajajajajaja disculpen mis ratos…me vuelvo a contestar yo mismo…

HanaConnection oData = new HanaConnection(CadenaCon);
oData.Open();


    
                HanaCommand cmd = new HanaCommand("", oData);
                cmd.CommandText = @"""JC1_NATIVO_Select""";
                cmd.CommandType = CommandType.StoredProcedure;

                HanaParameter param = new HanaParameter();
                param = cmd.CreateParameter();
                param.HanaDbType = HanaDbType.Integer;
                param.Direction = ParameterDirection.Input;
                param.Value = AntiguedadDias;
                cmd.Parameters.Add(param);
                cmd.ExecuteReader();