WPF Enabling a button with SQL condition

Question

I want to make button enabled, depending on what data is in SQL table. I made table with boolean type column and now I want WPF to read it and make button enabled or disabled. I made class for connection:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

using System.Data;
using System.Windows;
using System.Data.SqlClient;
using System.Configuration;

namespace WpfCalendar.Classes
{
    class SQLconnection
    {
        public static string GetConnectionStrings()
        {
            string strConString = ConfigurationManager.ConnectionStrings["conString"].ToString();
            return strConString;
        }

        public static string sql;
        public static SqlConnection con = new SqlConnection();
        public static SqlCommand cmd = new SqlCommand("",con);
        public static SqlDataReader rd;
        public static DataTable dt;
        public static SqlDataAdapter da;

        public static void openConnection()
        {
            try
            {
                if (con.State == ConnectionState.Closed)
                {
                    con.ConnectionString = GetConnectionStrings();
                    con.Open();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Brak połaczenia" + Environment.NewLine + ex.Message.ToString(), "C# WPF connect to SQL server", MessageBoxButton.OK, MessageBoxImage.Error);

            }
        }

        public static void closeConnection()
        {
            try
            {
                if(con.State == ConnectionState.Open)
                {
                    con.Close();
                }
            }
            catch(Exception)
            {
                
            }
        }

    }
}

And my window xaml.cs

public partial class Kalendarz : Window
    {
        public Kalendarz()
        {
            InitializeComponent();
           

        }



        private void Sprawdzanko1(object sender, RoutedEventArgs e)
        {
            DateTime dt = DateTime.Now;
            bool klikniente;
            SQLconnection.openConnection();
            SQLconnection.cmd.CommandText = SQLconnection.sql;
            SQLconnection.sql = "Select [Otwarte] FROM Okienka WHERE Dzien LIKE '1';";
            SQLconnection.cmd.CommandType = CommandType.Text;
            SQLconnection.da = new SqlDataAdapter(SQLconnection.cmd);
            klikniente = (bool)SQLconnection.cmd.ExecuteScalar();
            

            if (klikniente == true && dt.Day == 1 && dt.Month == 12)
            {
                b1.IsEnabled = true;
            }
            else
            {
                b1.IsEnabled = false;
            }



            SQLconnection.closeConnection();
        }

I'm making a WPF advent calendar so the idea is to check if the button was clicked before and if date is correct. But the buttons don't react an I'm pretty sure the code isn't even executed...

I dont call it anywhere, when I watched tutorials it executed for them anyhow. Should I call for it somewhere? — Szopen, Feb 07 '21 at 01:07
Separately, see also [C# Data Connections Best Practice?](https://stackoverflow.com/questions/17552829/c-sharp-data-connections-best-practice) — Charlieface, Feb 07 '21 at 02:28
Yes You need to call it, otherwise it never happens! Check your tutorials again! — Jonathan Willcock, Feb 07 '21 at 03:20

score 0 · Answer 1 · answered Feb 07 '21 at 04:52

Ok so I think I got it. It works so I'm fine with it :D

private void Sprawdzanko1()
        {
            bool klikniente;
            using (SQLconnection.con)
            {
                SQLconnection.openConnection();

                SqlCommand cmd = new SqlCommand("Select [Otwarte] FROM Okienka WHERE Dzien LIKE '1';", SQLconnection.con);

                klikniente = (bool)cmd.ExecuteScalar();
                SQLconnection.closeConnection();
            }

            if (klikniente == false && dt.Day == 1 && dt.Month == 12)
            {
                b1.IsEnabled = true;
            }
            else
            {
                b1.IsEnabled = false;
            }
        }

And then you call Sprawdzanko1();

WPF Enabling a button with SQL condition

1 Answers1