/// <summary>
///
/// </summary>
/// <param name="commandType"></param>
/// <param name="commandText"></param>
/// <param name="commandParameters"></param>
/// <param name="ds"></param>
/// <param name="tableName"></param>
/// <returns></returns>
public override DataSet ExecuteDataset(CommandType commandType, string commandText,
QueryParameterCollection commandParameters, DataSet ds, string tableName)
{
try
{
var cmd = new OracleCommand();
PrepareCommand(cmd, commandType, commandText, commandParameters);
var adapter = new OracleDataAdapter(cmd);
if (Equals(tableName, null) || (tableName.Length < 1))
{
adapter.Fill(ds);
}
else
{
adapter.Fill(ds, tableName);
}
base.SyncParameter(commandParameters);
cmd.Parameters.Clear();
return ds;
}
catch
{
if (trans != null)
{
RollbackTransaction();
}
throw;
}
finally
{
Close();
}
}
public static bool DeckIsRefD(int Deck_id)
{
try
{
OracleConnection OraCon = new OracleConnection("Data Source=oids;User ID=plm;Password=123!feed;Unicode=True");
OraCon.Open();
OracleDataAdapter OrclPrjAdapter = new OracleDataAdapter();
OracleCommand OrclPrjCmd = OraCon.CreateCommand();
OrclPrjAdapter.SelectCommand = OrclPrjCmd;
OrclPrjCmd.CommandText = @"SELECT T.TABLE_NAME,T.COLUMN_NAME FROM use_deckid_tables_view T";
DataSet Mydata = new DataSet();
OrclPrjAdapter.Fill(Mydata);
DataSet tmpData = new DataSet();
string QueryPrjIdCmdStr = string.Empty;
for (int i = 0; i < Mydata.Tables[0].Rows.Count; i++)
{
QueryPrjIdCmdStr = @"SELECT T." + Mydata.Tables[0].Rows[i][1] + " FROM " + Mydata.Tables[0].Rows[i][0] + " T WHERE TO_CHAR(T." + Mydata.Tables[0].Rows[i][1] + ")=TO_CHAR(" + Deck_id + ")";
OrclPrjCmd.CommandText = QueryPrjIdCmdStr;
OrclPrjAdapter.Fill(tmpData);
if (tmpData.Tables[0].Rows.Count > 0)
return true;
}
return false;
}
catch (Exception err)
{
System.Console.WriteLine(err.Message);
return true;
}
}
public static void BuscaDGV(DataGridView dgv)
{
OracleDataAdapter da = new OracleDataAdapter("SELECT bairroid, nome, valor FROM bairros order by bairroid", ConexaoOracle.ObterConexao());
DataTable dt = new DataTable();
da.Fill(dt);
dgv.DataSource = dt;
}
public static DataTable ExecuteDataTable(string connectionString, CommandType cmdType, string cmdText, params OracleParameter[] commandParameters)
{
using (OracleConnection connection = new OracleConnection(connectionString))
{
OracleCommand cmd = new OracleCommand();
try
{
PrepareCommand(cmd, connection, null, cmdType, cmdText, commandParameters);
OracleDataAdapter MyAdapter = new OracleDataAdapter();
MyAdapter.SelectCommand = cmd;
DataSet ds = new DataSet();
MyAdapter.Fill(ds);
cmd.Parameters.Clear();
DataTable table = ds.Tables[0];
ds.Dispose();
connection.Close();
return table;
}
catch
{
connection.Close();
throw;
}
}
}
protected void ddlAmphur_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
using (OracleConnection sqlConn = new OracleConnection(DatabaseManager.CONNECTION_STRING))
{
using (OracleCommand sqlCmd = new OracleCommand())
{
sqlCmd.CommandText = "select * from TB_DISTRICT where AMPHUR_ID=:DISTRICT_ID";
sqlCmd.Parameters.Add(":DISTRICT_ID", ddlAddressAmphurCondition.SelectedValue);
sqlCmd.Connection = sqlConn;
sqlConn.Open();
OracleDataAdapter da = new OracleDataAdapter(sqlCmd);
DataTable dt = new DataTable();
da.Fill(dt);
ddlAddressDistrictCondition.DataSource = dt;
ddlAddressDistrictCondition.DataValueField = "DISTRICT_ID";
ddlAddressDistrictCondition.DataTextField = "DISTRICT_TH";
ddlAddressDistrictCondition.DataBind();
sqlConn.Close();
ddlAddressDistrictCondition.Items.Insert(0, new ListItem("--กรุณาเลือก ตำบล--", "0"));
}
}
}
catch { }
}
public static void BuscaDGV(DataGridView dgv)
{
OracleDataAdapter da = new OracleDataAdapter("SELECT usuarioid, funcionarioid, nome, ativo FROM usuarios order by usuarioid", ConexaoOracle.ObterConexao());
DataTable dt = new DataTable();
da.Fill(dt);
dgv.DataSource = dt;
}
public AddTicket()
{
InitializeComponent();
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
OracleDataAdapter da = new OracleDataAdapter();
da.SelectCommand = new OracleCommand();
DataTable dt = new DataTable();
da.SelectCommand.Connection = conn;
string SQLquery = "select ReservationNumber from Reservation";
da.SelectCommand.CommandText = SQLquery;
da.Fill(dt);
resNum_comboBox.DataSource = dt;
resNum_comboBox.DisplayMember = "ReservationNumber";
OracleDataAdapter da2 = new OracleDataAdapter();
da2.SelectCommand = new OracleCommand();
DataTable dt2 = new DataTable();
da2.SelectCommand.Connection = conn;
SQLquery = "select screendate, roomnumber from Screen";
da2.SelectCommand.CommandText = SQLquery;
da2.Fill(dt2);
dataGridView1.DataSource = dt2;
}
public static void BuscaDGV(DataGridView dgv, String nome)
{
OracleDataAdapter da = new OracleDataAdapter("SELECT ingredienteid, nome, preco, estoque, descricao FROM ingredientes WHERE nome LIKE '" + nome + "%'", ConexaoOracle.ObterConexao());
DataTable dt = new DataTable();
da.Fill(dt);
dgv.DataSource = dt;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
try
{
ora2.Open();
System.Data.OracleClient.OracleCommand comando = new System.Data.OracleClient.OracleCommand("listar_flujo_aprobado");
comando.Connection = ora2;
comando.Connection = ora2;
comando.CommandType = System.Data.CommandType.StoredProcedure;
comando.Parameters.Add("p_recordset", OracleType.Cursor).Direction = ParameterDirection.Output;
System.Data.OracleClient.OracleDataAdapter adaptador = new System.Data.OracleClient.OracleDataAdapter();
adaptador.SelectCommand = comando;
DataTable dt = new DataTable();
adaptador.Fill(dt);
tblFlujo.DataSource = dt;
tblFlujo.DataBind();
ora2.Close();
}
catch (Exception ex)
{
lblError.Text = ex.ToString();
}
}
}
private void button1_Click( object sender, EventArgs e )
{
try
{
OracleConnection conn = ConnectionOracle.creaConnection();
conn.Open();
string str = "select reader.rname,book.bname,jie.date2 from reader jie book where book.bno=jie.bno and reader.rno = jie.rno and reader.rno='"+textBox1.Text+"'";
DataSet ds = new DataSet();
OracleDataAdapter da = new OracleDataAdapter(str,conn);
da.Fill(ds);
string str1 = "select book.bname from reader jie book where book.bno=jie.bno and reader.rno = jie.rno and reader.rno='" + textBox1.Text + "'";
da = new OracleDataAdapter(str1,conn);
DataSet ds1 = new DataSet();
da.Fill(ds1);
// if(ds.)
comboBox1.DataSource = ds1.Tables[0];
comboBox1.DisplayMember = "bno";
comboBox1.ValueMember = "bno";
dataGridView1.DataSource = ds.Tables[0];
conn.Close();
}
catch (Exception e1)
{
MessageBox.Show(e1.Message);
throw;
}
}
public static void BuscaDGV(DataGridView dgv, String nome)
{
OracleDataAdapter da = new OracleDataAdapter("SELECT bairroid, nome, valor FROM bairros WHERE nome LIKE '" + nome + "%'", ConexaoOracle.ObterConexao());
DataTable dt = new DataTable();
da.Fill(dt);
dgv.DataSource = dt;
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
string strConn = "Data Source=orcl;User Id=chatroom;Password=chatroom;Integrated Security=no;";
OracleConnection oleDbConnection = new OracleConnection(strConn);
oleDbConnection.Open();
string strSql;
if (this.name.Text.ToString() == "")
{
strSql = "select * from scott.ChatRoomLog order by id desc";
}
else
{
strSql = "select * from scott.chatroomlog where name='" + this.name.Text.ToString() + "' order by id";
}
System.Data.OracleClient.OracleCommand oleDbCommand = new System.Data.OracleClient.OracleCommand();
oleDbCommand.CommandText = strSql;
oleDbCommand.Connection = oleDbConnection;
System.Data.OracleClient.OracleDataAdapter oleDbDataAdapter = new System.Data.OracleClient.OracleDataAdapter(oleDbCommand);
DataTable table = new DataTable();
oleDbDataAdapter.Fill(table);
oleDbConnection.Close();
this.GridView1.DataSource = table.DefaultView;
this.GridView1.DataBind();
}
catch
{
}
}
protected void showDonVi()
{
try
{
string user = "******";
string dataSource = showSiteName();
if (dataSource.ToUpper() == "BACGIANG")
user = "******";
string txt_cmd = string.Format("Data Source={0}; User ID={1}; Password={1}; Unicode=True", dataSource, user);
if (dataSource.ToUpper() == "NGHEAN")
txt_cmd = string.Format("Data Source={0}; User ID={1}; Password={2}; Unicode=True", dataSource, "CMIS01PC1", "PC1CMIS01");
if (dataSource.ToUpper() == "NINHBINH")
txt_cmd = string.Format("Data Source={0}; User ID={1}; Password={2}; Unicode=True", dataSource, "CMIS01PC1", "pc1cmis01");
OracleConnection ora_con = new OracleConnection(txt_cmd);
txt_cmd = "select MA_DVIQLY, TEN_DVIQLY from cmis01.d_dvi_qly where CAP_DVI=3 order by MA_DVIQLY";
OracleDataAdapter ora_da = new OracleDataAdapter(txt_cmd, ora_con);
DataSet ds = new DataSet();
ora_con.Open();
ora_da.Fill(ds);
ora_con.Close();
ddDonViQL.DataSource = ds;
ddDonViQL.DataBind();
}
catch (Exception ex) { lbError.Text = ex.Message; }
}
/// <summary>
/// ִ�в�ѯ��䣬����DataSet
/// </summary>
/// <param name="SQLString">��ѯ���</param>
/// <returns>DataSet</returns>
public static DataSet Query(string SQLString)
{
if (SQLString != null && SQLString.Trim() != "")
{
using (OracleConnection connection = new OracleConnection(connectionString))
{
DataSet ds = new DataSet();
try
{
connection.Open();
OracleDataAdapter command = new OracleDataAdapter(SQLString, connection);
command.Fill(ds, "ds");
}
catch (System.Data.OracleClient.OracleException ex)
{
throw new Exception(ex.Message);
}
finally
{
connection.Close();
}
return ds;
}
}
else
{
return null;
}
}
//Filling the booking details into the return cars datagridview
public void bookingsDetails(DataGridView grd_Bookings)
{
var tomorrow = DateTime.Today.AddDays(1).ToString("dd-MMM-yyyy");
var dueDate = DateTime.Today.AddDays(-5).ToString("dd-MMM-yyyy");
string query_String = string.Format("SELECT DISTINCT B.Customer_Id ,Forename, Surname ,B.Car_Reg ,Cost ,Customer_Type,Return_Date FROM Cars CA, " +
"Customers C JOIN Bookings B ON C.Customer_Id = B.Customer_Id " +
"WHERE Car_Status = 'U' AND CA.Car_Reg = B.Car_Reg AND Return_Date BETWEEN '{0}' AND '{1}'", dueDate, tomorrow );
// MessageBox.Show(query_String);
try
{
connection.Open();
cmd = connection.CreateCommand();
cmd.CommandText = query_String;
data_Adapter = new OracleDataAdapter(cmd);
data_Set = new DataSet();
data_Adapter.Fill(data_Set, "Bookings");
grd_Bookings.DataSource = data_Set.Tables["Bookings"];
data_reader = cmd.ExecuteReader();//the reader is used to read in the required record
data_reader.Read();
connection.Close();
}
catch (Exception ex) {MessageBox.Show("" + ex);}
}
public static void BuscaDGV(DataGridView dgv)
{
OracleDataAdapter da = new OracleDataAdapter("select p.pedidoid, c.nome, f.nome, p.valortotal, p.valorpago, p.formapagamento, p.data, p.desconto, p.status, p.cancelado, p.entregaid from funcionarios f join pedidos p using (funcionarioid) join clientes c using (clienteid) order by pedidoid; ", ConexaoOracle.ObterConexao());
DataTable dt = new DataTable();
da.Fill(dt);
dgv.DataSource = dt;
}
private void EditStudentFrm_Load(object sender, EventArgs e)
{
//Author: Niall Stack - t00174406
string CloudDB = "Data Source=cp3dbinstance.c4pxnpz4ojk8.us-east-1.rds.amazonaws.com:1521/cp3db;User Id=sw4;Password=sw4;";
try
{
OracleConnection conn = new OracleConnection(CloudDB);
OracleCommand cmd = new OracleCommand("SELECT * FROM Students", conn);
cmd.CommandType = CommandType.Text;
OracleDataAdapter da = new OracleDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds, "ss");
studGrd.DataSource = ds.Tables["ss"];
conn.Close();
}
catch (OracleException ex)
{
MessageBox.Show(ex.Message);
}
}
public DataSet ReadDataToDataSet(OracleConnection conn, String SQL, string diff)
{
OracleDataAdapter adapter = new OracleDataAdapter(SQL, conn);
DataSet testDataSet = new DataSet();
adapter.Fill(testDataSet);
return testDataSet;
}
/// <summary>
/// execute a query£¬return DataSet
/// </summary>
/// <param name="SQLString"></param>
/// <returns>DataSet</returns>
public static DataSet Query(string connectionString, string SQLString)
{
using (OracleConnection connection = new OracleConnection(connectionString))
{
DataSet ds = new DataSet();
try
{
connection.Open();
OracleDataAdapter command = new OracleDataAdapter(SQLString, connection);
command.Fill(ds, "ds");
}
catch (OracleException ex)
{
throw new Exception(ex.Message);
}
finally
{
if (connection.State != ConnectionState.Closed)
{
connection.Close();
}
}
return ds;
}
}
public static void BuscaDGV(DataGridView dgv)
{
OracleDataAdapter da = new OracleDataAdapter("SELECT f.funcionarioid, f.nome, c.nome Cargo, f.numero, f.ativo FROM funcionarios f JOIN cargos c USING (cargoid) WHERE funcionarioid<>0 order by f.nome", ConexaoOracle.ObterConexao());
DataTable dt = new DataTable();
da.Fill(dt);
dgv.DataSource = dt;
}
public DataSet GetDateSet(string sqlstring)
{
OracleDataAdapter sda = new OracleDataAdapter(sqlstring, conn);
DataSet ds = new DataSet();
sda.Fill(ds, "ds");
return ds;
}
public static DataTable getTable(string strSql)
{
if (MsgBox != null) MsgBox.Text = strSql + System.Environment.NewLine + MsgBox.Text;
DataTable dt = new DataTable();
try
{
Connect();
OracleCommand orcCmd = myConnection.CreateCommand();//触发条件表
orcCmd.CommandText = strSql;//根据公司ID查询触发条件表
OracleDataAdapter orcDap = new OracleDataAdapter(orcCmd);//主表
orcDap.Fill(dt);
}
catch (Exception ex)
{
Console.Write(ex.Message);
if (MsgBox != null) MsgBox.Text = "执行sql异常：" + ex.ToString() + System.Environment.NewLine + MsgBox.Text;
throw ex;
}
finally
{
close();
}
return dt;
}
public Member AuthenticateUser(String username, String password)
{
conn.Open();
try
{
cmd = conn.CreateCommand();
string sql = "Select * from members where username = '******' AND account_password = '******'" ;
cmd = new OracleCommand(sql);
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
da = new OracleDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds, "ss");
if (ds.Tables["ss"].Rows[0].ItemArray[0].Equals(username) && ds.Tables["ss"].Rows[0].ItemArray[2].Equals(password))
{
member = createMember(ds);
}
return member;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return null;
}
finally
{
conn.Close();
}
}
public DataTable executeDataTable(IDbTransaction transaction, CommandType commandType, string commandText, params IDbDataParameter[] commandParameters)
{
try
{
//create a command and prepare it for execution
OracleCommand cmd = new OracleCommand();
PrepareCommand(cmd, transaction.Connection, transaction, commandType, commandText, commandParameters);
//create the DataAdapter & DataTable
OracleDataAdapter da = new OracleDataAdapter(cmd);
DataTable dt = new DataTable();
//fill the DataTable using default values for DataTable names, etc.
da.Fill(dt);
// detach the SqlParameters from the command object, so they can be used again.
cmd.Parameters.Clear();
//return the datatable
return dt;
}
catch (Exception ex)
{
throw (new Exception(string.Concat(ex.Message.ToString(), "\r\nExecuted SQL Statement:\r\n", commandText.ToString()), ex));
}
}
protected void ddlCampus_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
using (OracleConnection sqlConn = new OracleConnection(DatabaseManager.CONNECTION_STRING))
{
using (OracleCommand sqlCmd = new OracleCommand())
{
sqlCmd.CommandText = "select * from TB_FACULTY where CAMPUS_ID = " + ddlCampus.SelectedValue;
sqlCmd.Connection = sqlConn;
sqlConn.Open();
OracleDataAdapter da = new OracleDataAdapter(sqlCmd);
DataTable dt = new DataTable();
da.Fill(dt);
ddlFaculty.DataSource = dt;
ddlFaculty.DataValueField = "FACULTY_ID";
ddlFaculty.DataTextField = "FACULTY_NAME";
ddlFaculty.DataBind();
sqlConn.Close();
ddlFaculty.Items.Insert(0, new ListItem("--กรุณาเลือกสำนัก / สถาบัน / คณะ--", "0"));
ddlDivision.Items.Clear();
ddlDivision.Items.Insert(0, new ListItem("--กรุณาเลือกกอง / สำนักงานเลขา / ภาควิชา--", "0"));
ddlWorkDivision.Items.Clear();
ddlWorkDivision.Items.Insert(0, new ListItem("--กรุณาเลือกงาน / ฝ่าย--", "0"));
}
}
}
catch { }
}
protected DataSet cmis_search(string ma_khang, string so_cto, out string txt_err)
{
DataSet ds = new DataSet();
try
{
string txt_cmd = string.Format("Data Source={0}; User ID={1}; Password={1}; Unicode=True", "THAINGUYEN", "CMIS01PC1");
OracleConnection ora_con = new OracleConnection(txt_cmd);
txt_cmd = @"select TEN_KHANG, DCHI_KHANG, DCHI_TTOAN, KY, THANG, NAM, NGAY_DKY, NGAY_CKY, LOAI_HDON, TONG_TIEN, DIEN_TTHU, NGAY_PHANH
from cmis01.hdn_hdon
where MA_KHANG=:ma_khang or SO_CTO=:so_cto
order by NGAY_CKY desc";
OracleParameter[] pa = new OracleParameter[2];
pa[0] = new OracleParameter("ma_khang", ma_khang.ToUpper());
pa[1] = new OracleParameter("so_cto", so_cto);
OracleDataAdapter ora_da = new OracleDataAdapter(txt_cmd, ora_con);
ora_da.SelectCommand.CommandType = CommandType.Text;
ora_da.SelectCommand.Parameters.Add(pa[0]);
ora_da.SelectCommand.Parameters.Add(pa[1]);
ora_con.Open();
ora_da.Fill(ds);
ora_con.Close();
txt_err = "";
}
catch (Exception ex) { txt_err = ex.Message; }
return ds;
}
private void frmMain_Load(object sender, EventArgs e)
{
my_rpt objRpt;
// Creating object of our report.
objRpt = new my_rpt();
String ConnStr = "SERVER=myDb;USER ID=user1;PWD=user1";
OracleConnection myConnection = new OracleConnection(ConnStr);
String Query1 = "select a.PROJECT_ID,a.PROJECT_NAME,b.GROUP_NAME from tbl_project a,tbl_project_group b where a.group_code= b.group_code";
OracleDataAdapter adapter = new OracleDataAdapter(Query1, ConnStr);
DataSet Ds = new DataSet();
// here my_dt is the name of the DataTable which we created in the designer view.
adapter.Fill(Ds, "my_dt");
if (Ds.Tables[0].Rows.Count == 0)
{
MessageBox.Show("No data Found", "CrystalReportWithOracle");
return;
}
// Setting data source of our report object
objRpt.SetDataSource(Ds);
CrystalDecisions.CrystalReports.Engine.TextObject root;
root = (CrystalDecisions.CrystalReports.Engine.TextObject)objRpt.ReportDefinition.ReportObjects["txt_header"];
root.Text = "Sample Report By Using Data Table!!";
// Binding the crystalReportViewer with our report object.
crystalReportViewer1.ReportSource = objRpt;
}
private void button2_Click(object sender, EventArgs e)
{
oracle.LinkToOracle("orcl", "hui", "oracle");
OracleCommand cmd = oracle.getConnection().CreateCommand();
if (radioButton1.Checked)
{
OracleDataAdapter sda = new OracleDataAdapter("select * from department", oracle.getConnection());
DataTable query = new DataTable();
query = (DataTable)dataGridView1.DataSource;
OracleCommandBuilder sb = new OracleCommandBuilder(sda);
sda.Update(query);
query.Clear();
sda.Fill(query);
}
if (radioButton2.Checked)
{
OracleDataAdapter sda = new OracleDataAdapter("select * from teacher", oracle.getConnection());
DataTable query = new DataTable();
query = (DataTable)dataGridView1.DataSource;
OracleCommandBuilder sb = new OracleCommandBuilder(sda);
sda.Update(query);
query.Clear();
sda.Fill(query);
}
oracle.LinkClose();
cmd.Dispose();
}
private void button1_Click( object sender, EventArgs e )
{
try
{
OracleConnection conn = ConnectionOracle.creaConnection();
string str ="";
if (radioButton1.Checked)
{
str = "select * from book where bname='" + textBox1.Text + "'";
}
if (radioButton2.Checked)
{
str = "select * from book where auther = '" + textBox1.Text + "'";
}
if (radioButton3.Checked)
{
str = "select * from book where pkey='"+textBox1.Text+"' or pkey1='"+textBox1.Text+"' or pkey2='"+textBox1.Text+"'";
}
OracleCommand cmd = conn.CreateCommand();
OracleDataAdapter da = new OracleDataAdapter(str,conn);
DataSet ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource =
ds.Tables[0];
conn.Open();
}
catch (Exception e1)
{
MessageBox.Show(e1.Message);
throw;
}
}
private void stdnt_payment_info_btn_Click(object sender, EventArgs e)
{
dbConnect conObj = new dbConnect();
OracleConnection conn = conObj.connFunc();
OracleParameter parOut = new OracleParameter();
parOut.ParameterName = "res_cur";
parOut.OracleType = OracleType.Cursor;
parOut.Size = 32;
parOut.Direction = System.Data.ParameterDirection.Output;
OracleCommand cmd = conn.CreateCommand();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "student_payment_procedure";
cmd.Parameters.Add(parOut);
conn.Open();
OracleDataAdapter adapter = new OracleDataAdapter(cmd);
DataSet myset = new DataSet("res_cur");
adapter.Fill(myset);
stdnt_payment_dataGridView.DataSource = myset;
stdnt_payment_dataGridView.DataSource = myset.Tables[0];
conn.Close();
}
/// <summary>
/// 执行查询语句，返回DataSet
/// </summary>
/// <param name="SQLString">查询语句</param>
/// <returns>DataSet</returns>
public override DataSet ExecuteDataSet(string SQLString, params IDataParameter[] cmdParms)
{
using (OracleConnection connection = new OracleConnection(connectionString))
{
OracleCommand cmd = new OracleCommand();
PrepareCommand(cmd, connection, null, SQLString, cmdParms);
using (OracleDataAdapter da = new OracleDataAdapter(cmd))
{
DataSet ds = new DataSet();
try
{
da.Fill(ds, "ds");
cmd.Parameters.Clear();
}
catch (OracleException e)
{
//LogManage.OutputErrLog(e, new Object[] { SQLString, cmdParms });
throw;
}
finally
{
cmd.Dispose();
connection.Close();
}
return ds;
}
}
}
public DataSet GetDataSet1(string sql, ref System.Data.OracleClient.OracleDataAdapter sda)
{
try
{
DataSet ds = new DataSet();
this.Open();
IDbCommand com = DBF.getDBCommand();
com.CommandText = sql;
com.Connection = DBF.getDBConnection();
sda = (System.Data.OracleClient.OracleDataAdapter)DBF.getDataAdapter(com);
sda.Fill(ds);
this.Close();
return(ds);
}
catch (Exception ex)
{
MessageBox.Show("Error:" + sql + ex.Message);
return(null);
}
}
public Sdt ExecuteProcedure(String procedureName)
{
Sdt dt = new Sdt();
if (dbType == DbType.Oracle)
{
cmdOra.CommandText = procedureName;
cmdOra.CommandType = CommandType.StoredProcedure;
System.Data.OracleClient.OracleDataAdapter da = new System.Data.OracleClient.OracleDataAdapter(cmdOra);
da.Fill(dt);
dt.SecoundConstructor();
}
if (dbType == DbType.MySQL)
{
cmd.CommandText = procedureName;
cmd.CommandType = CommandType.StoredProcedure;
MySqlDataAdapter da = new MySqlDataAdapter((MySqlCommand)cmd);
da.Fill(dt);
dt.SecoundConstructor();
}
return(dt);
}
public static System.Data.DataTable ExecuteDataTable(ref System.Data.OracleClient.OracleCommand command, System.Data.OracleClient.OracleConnection connection, System.Data.CommandType commandType, string commandText)
{
System.Data.OracleClient.OracleDataAdapter oracleDataAdapter = new System.Data.OracleClient.OracleDataAdapter();
System.Data.DataSet dataSet = new System.Data.DataSet();
System.Data.DataTable dataTable = new System.Data.DataTable();
try
{
prepareCommand(ref command, connection, commandType, commandText);
oracleDataAdapter.SelectCommand = command;
oracleDataAdapter.Fill(dataSet);
if (dataSet != null && dataSet.Tables.Count > 0)
{
dataTable = dataSet.Tables[0];
}
}
catch (Exception ex)
{
// Handle the exception in UI level only
throw ex;
}
return(dataTable);
}
