Beispiel #1
0
        private void btnGetAllTableName_Click(object sender, EventArgs e)
        {
            dbHelper = new DBHelperOracle(txtOracleAddress.Text, txtName.Text, txtPassword.Text);
            List <string> tableName = GetTableNamesOracle();

            this.comBoxAllTableName.DataSource = tableName;
        }
Beispiel #2
0
        private void btnDelSelectTable_Click(object sender, EventArgs e)
        {
            string tableName   = this.comBoxAllTableName.Text.Split('(')[0];
            string commandText = "drop table " + tableName;
            int    delTable    = DBHelperOracle.ExecuteNonQuery(commandText);

//           TxtLogHelper.m_CreateErrorLogTxt("1", commandText);

            dbHelper = new DBHelperOracle(txtOracleAddress.Text, txtName.Text, txtPassword.Text);
            List <string> allTableName = GetTableNamesOracle();

            this.comBoxAllTableName.DataSource = allTableName;
        }
Beispiel #3
0
        /// <summary>
        /// 测试数据库连接
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnTestConnectSQL_Click(object sender, EventArgs e)
        {
            try
            {
                dbHelper = new DBHelperOracle(txtOracleAddress.Text, txtName.Text, txtPassword.Text);
                DBHelperOracle.init();
                MessageBox.Show("数据库连接成功!", "测试结果", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            catch (Exception ex)
            {
                MessageBox.Show("连接失败: " + ex.Message, "测试结果", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }

            /*
             * Try
             *
             * 'get the selected connection
             * Dim strFullConn As String = Me.cboConnections.SelectedItem.ToString
             * Dim arrayFullConn() As String = strFullConn.Split("|")
             * Dim strDBType As String = arrayFullConn(0).ToUpper
             * Dim strDBConnOrig As String = arrayFullConn(1)
             * Dim strDBConn As String = arrayFullConn(1)
             *
             * 'check password
             * If Not CheckPassword(strDBConn) Then Exit Sub
             *
             * 'open the connection based on the connection type
             * Dim connSQLServer As SqlConnection = Nothing
             * Dim connOracle As OracleConnection = Nothing
             * If strDBType = "SQLSERVER" Then
             *  connSQLServer = New SqlConnection(strDBConn)
             *  connSQLServer.Open()
             *  connSQLServer.Close()
             * ElseIf strDBType = "ORACLE" Then
             *  connOracle = New OracleConnection(strDBConn)
             *  connOracle.Open()
             *  connOracle.Close()
             * End If
             *
             * 'connection worked - store password
             * If Not m_hashPasswords.Contains(strDBConnOrig) Then
             *  m_hashPasswords.Add(strDBConnOrig, m_strPassword)
             * End If
             *
             * MessageBox.Show("Connection succeeded", "Test Result", MessageBoxButtons.OK, MessageBoxIcon.Information)
             *
             * Catch ex As Exception
             * MessageBox.Show("Connection Failed: " + ex.Message, "Test Result", MessageBoxButtons.OK, MessageBoxIcon.Warning)
             * End Try*/
        }
Beispiel #4
0
        /// <summary>
        /// 获取Oracle数据库中所有的表名称
        /// </summary>
        /// <returns></returns>
        public List <string> GetTableNamesOracle()
        {
            List <string> tblist = new List <string>();

            try
            {
                string selectTables = @" select t.tbname,b.comments from ( 
                                        select View_Name as tbname from  user_views
                                        union
                                        select Table_Name as tbname from  user_tables) t
                                        left join USER_TAB_COMMENTS b on b.TABLE_NAME=t.tbname order by t.tbname asc";

                /*OleDbDataAdapter da = new OleDbDataAdapter(selectTables, tempmyConn);
                 * DataTable dt = new DataTable();
                 * da.Fill(dt);*/

                DataSet ds = DBHelperOracle.GetDataSet(selectTables);
                if (ds.Tables.Count > 0)
                {
                    DataTable dt = ds.Tables[0];
                    foreach (DataRow dr in dt.Rows)
                    {
                        string tname   = dr["tbname"].ToString();
                        string comment = dr["comments"] == null ? "" : dr["comments"].ToString();
                        if (string.IsNullOrWhiteSpace(comment))
                        {
                            tblist.Add(tname);
                        }
                        else
                        {
                            tblist.Add(tname + "(" + comment + ")");
                        }
                    }
                }
            }
            catch (Exception exp)
            {
                //               TxtLogHelper.m_CreateErrorLogTxt("0", exp.Message);
            }
            finally
            {
            }

            return(tblist);
        }