/// <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); }