Beispiel #1
0
        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);
            }
        }
Beispiel #2
0
        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);
            }
        }
Beispiel #3
0
        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);
        }
Beispiel #4
0
 private void SetDataTable_(string selectedText, AltibaseConnection conn)
 {
     return;
 }