string conStr = string.Format("Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST={0})(PORT={1})))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME={2})));User Id={3};Password={4}; ", conHostName, conPort, conDatabase, _dbUserName, _dbPwd); //OracleConnection con = new OracleConnection(conStr); //con.Open(); // define Command using (var conn = new OracleConnection(conStr)) { DataSet dataset = new DataSet(); // create & define the command var cmd = new OracleCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "REPORTS.GET_DAILY_STATUS"; cmd.Connection = conn; // Declare parameter for FROM DATE - INPUT OracleParameter param1 = new OracleParameter("PID_FROM_DATE", OracleType.DateTime, 10); param1.Value = Convert.ToDateTime(dateTimePicker1.Value.Date); param1.Direction = ParameterDirection.Input; // add to cmd object cmd.Parameters.Add(param1); // Declare parameter for To DATE - INPUT OracleParameter param2 = new OracleParameter("PID_TO_DATE", OracleType.DateTime, 10); param2.Value = Convert.ToDateTime(dateTimePicker2.Value.Date); param2.Direction = ParameterDirection.Input; // add to cmd object cmd.Parameters.Add(param2); // Declare parameter for spvsr DATE - INPUT OracleParameter param3 = new OracleParameter("PIN_SPVSR_ID", OracleType.Number, 10); param3.Value = 410; param3.Direction = ParameterDirection.Input; // add to cmd object cmd.Parameters.Add(param3); //PORC_DATA 410 // Declare parameter for FROM procreport - OUTPUT OracleParameter param4 = new OracleParameter("PORC_REPORT", OracleType.Cursor); param4.Direction = ParameterDirection.Output; // add to cmd object cmd.Parameters.Add(param4); //OracleParameter[] oprms = new OracleParameter[3]; //oprms[0] = new OracleParameter("PIC_FROM_DATE", OracleType.VarChar, 10, dateTimePicker1.Value, ParameterDirection.Input); //oprms[1] = new OracleParameter("PIC_TO_DATE", OracleType.VarChar, 10, dateTimePicker1.Value, ParameterDirection.Input); //oprms[2] = new OracleParameter("PORC_DATA", OracleType.RefCursor, ParameterDirection.Output); //foreach (OracleParameter oprm in oprms) //{ // cmd.Parameters.Add(oprm); //} OracleDataAdapter oDap = new OracleDataAdapter(cmd); oDap.Fill(table); if (table != null) { dataGridView1.AutoGenerateColumns = true; dataGridView1.DataSource = table.DefaultView; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)