示例#1
0
        private void Btn_TestConnection_Click(object sender, EventArgs e)
        {
            Btn_TestConnection.Enabled = false;
            if (PingTest(TextBox_Server.Text))
            {
                string        msg     = "";
                SybaseQueryer queryer = new SybaseQueryer(TextBox_Server.Text, TextBox_Username.Text, TextBox_Password.Text);
                if (queryer.TestConnection(out msg))
                {
                    Lbl_TestResult.Text      = "连接成功。";
                    Lbl_TestResult.ForeColor = Color.Green;
                }
                else
                {
                    Lbl_TestResult.Text      = "连接失败!" + msg;
                    Lbl_TestResult.ForeColor = Color.Red;
                }
            }
            else
            {
                Lbl_TestResult.Text      = "连接失败!";
                Lbl_TestResult.ForeColor = Color.Red;
            }

            Btn_TestConnection.Enabled = true;
        }
示例#2
0
        private void Btn_Query_Click(object sender, EventArgs e)
        {
            listView1.Items.Clear();
            listView1.Columns.Clear();
            if (Panel_Home.Visible == false)
            {
                Btn_Home.PerformClick();
            }

            try
            {
                sybaseQueryer = new SybaseQueryer(_hostName, _userName, _password, _port, _database, _charset);
                sybaseQueryer.Connect();
                _dataTable = sybaseQueryer.Query(Util.EncodingString(TextBox_QueryString.Text, sybaseQueryer.Charset, Encoding.Default.HeaderName));
                FillListView();
                sybaseQueryer.Dispose();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }