static void Run() { OracleConnection conn = DBOracleUtils.GetDBConnection(); Console.WriteLine("Get Connection: " + conn); try { conn.Open(); GetUsers(conn); Console.WriteLine(conn.ConnectionString, "Successful Connection"); } catch (Exception ex) { Console.WriteLine("## ERROR: " + ex.Message); Console.Read(); return; } finally { conn.Close(); conn.Dispose(); } Console.Read(); }
private void button3_Click(object sender, EventArgs e) { if (comboBox2.Text.Equals("")) { MessageBox.Show("VUI LÒNG CHỌN USER DEMO"); return; } if (richTextBox2.Text.Equals("")) { MessageBox.Show("VUI LÒNG NHẬP CÂU TRUY VẤN DEMO"); return; } Globals.curr_session_id = comboBox2.Text.Substring(0, comboBox2.Text.IndexOf(' ')); Globals.curr_session_pw = "1"; _ = new DBOracleUtils(); DBUtils dbu = new DBUtils(); string query = richTextBox2.Text; MessageBox.Show(query); dataGridView3.DataSource = dbu.ExecuteQuery(query); for (int i = 1; i <= dataGridView3.Columns.Count - 1; i++) { //store autosized widths //remove autosizing dataGridView3.Columns[i - 1].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; dataGridView3.Columns[i].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; } Globals.curr_session_id = "DBA_BV01"; Globals.curr_session_pw = "1"; }
public static OracleConnection GetDBConnection() { return(DBOracleUtils.GetDBConnection()); }