Форум программистов [Powered by Invision Power Board]

Код


            System.Data.OracleClient.OracleConnection connection = new System.Data.OracleClient.OracleConnection();
            System.Data.OracleClient.OracleCommand command = new System.Data.OracleClient.OracleCommand();

            connection.ConnectionString = connectionString;
            connection.Open();
            command.CommandType = CommandType.StoredProcedure;
            command.Connection = connection;
            command.Parameters.AddWithValue("parameter Name", "Параметр с формы");
            command.ExecuteNonQuery();
            connection.Close();

Код



      this.FormConnect = new OracleConnection (MainConnectionString);

 // Открыть коннект
        this.FormConnect.Open();

OracleCommand command = this.FormConnect.CreateCommand();
        command.CommandType = CommandType.StoredProcedure;
        command.CommandText = "get_sum_prod";

        //параметры 
        OracleParameter ParamSub = new OracleParameter();
        ParamSub.DbType = DbType.Decimal;
            ParamSub.Value="203";
            ParamSub.ParameterName="a_sub";
            ParamSub.Direction = ParameterDirection.Input;
            command.Parameters.Add(ParamSub);
        OracleParameter ParamDatDdoc = new OracleParameter();
        ParamDatDdoc.DbType = DbType.Date;
            ParamDatDdoc.Value = "03.11.2007";
            ParamDatDdoc.ParameterName = "a_dat_v";
            ParamDatDdoc.Direction = ParameterDirection.Input;
            command.Parameters.Add(ParamDatDdoc);
        OracleParameter ParamDat = new OracleParameter();
        ParamDat.DbType = DbType.Date;
            ParamDat.Value = "29.01.2009";
            ParamDat.ParameterName = "a_dat_s";
            ParamDat.Direction = ParameterDirection.Input;
            command.Parameters.Add(ParamDat);

    
      
        MessageBox.Show(command.ExecuteScalar().ToString());

        // Закрыть коннект
        this.FormConnect.Close();

Код


 // Запросом вытащить функцию
        OracleCommand func = this.FormConnect.CreateCommand();
        func.CommandText = "select get_sum_prod(sub,'03.11.2007','28.01.2009') from Table"+
                            " where sub=203";
        // Выборка из функции
        OracleDataReader func_o = func.ExecuteReader();
        while (func_o.Read())
        {
            sum =Convert.ToInt32(func_o[0].ToString());

        }
        func_o.Close();