Example #1
0
        private void ButtonConnect_Click(object sender, EventArgs e)
        {
            ButtonConnect.BackColor = Color.Red;
            try
            {
                ConnectionStringManager.Create
                    (TextBoxDataSource.Text, TextBoxInitialCatalog.Text,
                    TextBoxDBUsername.Text, TextBoxDBPassword.Text);

                if (IsServerConnected())
                {
                    ButtonConnect.BackColor = Color.Green;
                    MessageBox.Show("Connection Successful.");
                }
                else
                {
                    MessageBox.Show("Connection Unsuccessful.");
                }
            }
            catch (Exception exception)
            {
                MessageBox.Show(exception.Message);
                return;
            }
            System.Threading.Thread.Sleep(3000);
        }