private void select() { ConnNode t_node = (ConnNode)mainTabControlHT[tabControl1.SelectedTab.Name]; EditorNode e_node = (EditorNode)t_node.subTabControlHT[t_node.sub_tabctl.SelectedTab.Name]; AltibaseConnection a_conn = e_node.s_editor.conn; DataSet a_dataset = e_node.s_editor.dataSet1; DataGridView a_dataGV = e_node.s_editor.dataGridView1; //AltibaseDataAdapter a_dataAdapter = e_node.s_editor.dataAdapter1; //AltibaseCommand a_cmd = e_node.s_editor.cmd; String query = e_node.s_editor.syntaxRichTextBox1.Text; AltibaseDataAdapter da = new AltibaseDataAdapter(a_conn.CreateCommand()); da.SelectCommand = new AltibaseCommand(query, a_conn); a_dataset.Clear(); try { int result = da.Fill(a_dataset); a_dataGV.DataSource = a_dataset.Tables[0]; setMsg("select", result); setHistory(); } catch (Exception ex) { setErrMsg(ex); } }
private void nonSelect() { ConnNode t_node = (ConnNode)mainTabControlHT[tabControl1.SelectedTab.Name]; EditorNode e_node = (EditorNode)t_node.subTabControlHT[t_node.sub_tabctl.SelectedTab.Name]; AltibaseConnection a_conn = e_node.s_editor.conn; DataSet a_dataset = e_node.s_editor.dataSet1; String query = e_node.s_editor.syntaxRichTextBox1.Text; AltibaseCommand cmd = new AltibaseCommand(query, a_conn); String split = " "; a_dataset.Clear(); try { int result = cmd.ExecuteNonQuery(); string[] query_split = query.Split(split.ToCharArray()); foreach (string s in query_split) { if (s.Trim() != "") { setMsg((String)s, result); break; } } setHistory(); } catch (Exception ex) { setErrMsg(ex); } }
public override DbConnection XDbConnection(string connStr_ = null) { if (Connection != null) { // TODO: 임시코드, 종료처리할지, 오류낼지. Connection.Close(); Connection = null; } string connStr = null; if (connStr_ == null) { connStr = ConnStr; } else { connStr = connStr_; } if (ConnType == XDbConnType.ORACLE) { Connection = new OracleConnection(connStr); } else if (ConnType == XDbConnType.ALTIBASE) { Connection = new AltibaseConnection(connStr); } else if (ConnType == XDbConnType.MSSQL) { Connection = new SqlConnection(connStr); } else if (ConnType == XDbConnType.TIBERO) { Connection = new OleDbConnectionTbr(connStr); } else if (ConnType == XDbConnType.OLEDB) { Connection = new OleDbConnection(connStr); } return(Connection); }
private void SetDataTable_(string selectedText, AltibaseConnection conn) { return; }