How to connect windows form label to Sql Server Table ?

Question

Hi, I'm actually creating a pool hockey league database application. I wonder if it is possible to connect my application label with table in Sql server. For example, a player's points are shown in a label text. This label text is connected to a Sql Server Table With all players's stats, but to a specific column for a specific lign (player). When I update the players's stats in the Sql Server, I want that it also update in all the person that have installed my application. Thanks for your help

Answer 1

@zachary marcotte , you could try the following code to show the label text from sql serer table.

 private void button1_Click(object sender, EventArgs e)  
        {  
            string connstr = @"connstr";  
            SqlConnection connection=new SqlConnection(connstr);  
            string sql = string.Format("select Score from Hockey where Name='{0}'",textBox1.Text);  
            connection.Open();  
            SqlCommand cmd = new SqlCommand(sql, connection);  
            SqlDataReader reader = cmd.ExecuteReader();  
            while(reader.Read())  
            {  
                label1.Text = reader["Score"].ToString();  
            }  
             
  
        }  

Database:

Result in the winform:

You can change your code appropriately according to my code.

Hope this could help you.

Best Regards,
Jack

---

If the answer is the right solution, please click "Accept Answer" and upvote it.If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Look at using SqlDependency object to detect changes and react to them, in this case to your label.

https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql/detecting-changes-with-sqldependency