Example #1
0
        private void TestConnection_Click(object sender, RoutedEventArgs e)
        {
            var server   = ServerTextBox.Text;
            var database = DbTextBox.Text;
            var username = UsernameTextBox.Text;
            var password = PasswordTextBox.Password;

            var builder = new SqlConnectionStringBuilder();

            builder.DataSource     = server;
            builder.InitialCatalog = database;
            builder.UserID         = username;
            builder.Password       = password;

            var connectionString = builder.ConnectionString;

            //Thu connect voi db
            var db = new MyShopEntities(connectionString);

            var tc = db.TestConnection();

            if (tc == true)
            {
                MessageBox.Show("Connect is OK");
                //Chuyen toi man hinh chinh
            }
            else
            {
                MessageBox.Show("Connect was failed");
            }
        }