//Calls Procedure and loads data to dataset. protected void CallProcedure() { DB_Toolbox environment_Tools_db = new DB_Toolbox(); DB_Toolbox.DBParameters[] dbParameters = new DB_Toolbox.DBParameters[3]; List<DB_Toolbox.DBParameters> infoList = new List<DB_Toolbox.DBParameters>(); dbParameters[0] = new DB_Toolbox.DBParameters(); dbParameters[0].ParamName = "PARAM1"; dbParameters[0].ParamDBType = OracleDbType.Varchar2; dbParameters[0].ParamDirection = ParameterDirection.Input; dbParameters[0].ParamValue = "123"; dbParameters[0].ParamSize = 100; dbParameters[0].ParamReturn = false; infoList.Add(dbParameters[0]); dbParameters[1] = new DB_Toolbox.DBParameters(); dbParameters[1].ParamName = "PARAM2"; dbParameters[1].ParamDBType = OracleDbType.Varchar2; dbParameters[1].ParamDirection = ParameterDirection.Output; dbParameters[1].ParamSize = 100; dbParameters[1].ParamReturn = true; infoList.Add(dbParameters[1]); dbParameters[2] = new DB_Toolbox.DBParameters(); dbParameters[2].ParamName = "PARAM3"; dbParameters[2].ParamDBType = OracleDbType.Varchar2; dbParameters[2].ParamDirection = ParameterDirection.Output; dbParameters[2].ParamSize = 100; dbParameters[2].ParamReturn = true; infoList.Add(dbParameters[2]); DataTable dt = new DataTable(); dt = environment_Tools_db.SQL_PROCEDURE("Oracle", constr1, "TEST123", infoList); dg.DataSource = dt; dg.DataBind(); InstallerHolder.Controls.Add(dg); InstallerHolder.Visible = true; submitCmsName.Enabled = false; }
public DataTable SQL_PROCEDURE_PARAMS(string DB_Platform, string ConnAuth, string ProcedureName, List<DBParameters> _dbParameters) { DBParameters[] dbParameters = new DBParameters[_dbParameters.Count]; List<DBParameters> infoList = new List<DBParameters>(); int iNumber = 0; switch(DB_Platform) { case "Oracle": case "ORACLE": foreach (DBParameters i in _dbParameters) { dbParameters[iNumber] = new DB_Toolbox.DBParameters(); dbParameters[iNumber].ParamName = i.ParamName; dbParameters[iNumber].OracleParamDataType = i.OracleParamDataType; dbParameters[iNumber].ParamDirection = i.ParamDirection; dbParameters[iNumber].ParamValue = i.ParamValue; dbParameters[iNumber].ParamSize = i.ParamSize; dbParameters[iNumber].ParamReturn = i.ParamReturn; infoList.Add(dbParameters[iNumber]); iNumber++; //++ Increments by 1. } break; case "Microsoft": case "MICROSOFT": foreach (DBParameters i in _dbParameters) { dbParameters[iNumber] = new DB_Toolbox.DBParameters(); dbParameters[iNumber].ParamName = i.ParamName; dbParameters[iNumber].MSSqlParamDataType = i.MSSqlParamDataType; dbParameters[iNumber].ParamDirection = i.ParamDirection; //Not used by MSSQL dbParameters[iNumber].ParamValue = i.ParamValue; //Not used by MSSQL dbParameters[iNumber].ParamSize = i.ParamSize; dbParameters[iNumber].ParamReturn = i.ParamReturn; infoList.Add(dbParameters[iNumber]); iNumber++; //++ Increments by 1. } break; } return SQL_PROCEDURE(DB_Platform, ConnAuth, ProcedureName, infoList); }
public DataTable SQL_PROCEDURE_PARAMS(string DB_Platform, string ConnAuth, string ProcedureName, List<DBParameters> _dbParameters) { DBParameters[] dbParameters = new DBParameters[_dbParameters.Count]; List<DBParameters> infoList = new List<DBParameters>(); int iNumber = 0; foreach (DBParameters i in _dbParameters) { dbParameters[iNumber] = new DB_Toolbox.DBParameters(); dbParameters[iNumber].ParamName = i.ParamName; dbParameters[iNumber].ParamDBType = i.ParamDBType; dbParameters[iNumber].ParamDirection = i.ParamDirection; dbParameters[iNumber].ParamValue = i.ParamValue; dbParameters[iNumber].ParamSize = i.ParamSize; dbParameters[iNumber].ParamReturn = i.ParamReturn; infoList.Add(dbParameters[iNumber]); iNumber++; //++ Increments by 1. } return SQL_PROCEDURE(DB_Platform, ConnAuth, ProcedureName, infoList); }