Dynamically assigned a Label Value and display a messages when values changes
<p>I have some code for C# that gets the second highest number from a table in the database:
The value or result-set is displayed in a text-box. This number changes every time a new record is inserted into the database.</p>

<p>I created another Label on the form and would like to display a message every time the value or text in the textbox is changed, which is dynamically.</p>

<p>In a nutshell, every time a record is inserted, this code runs and inserts the number in the textbox, I would like to display a message on another label every time the text-box value changes.</p>

<pre><code>private void DataSets_Load(object sender, EventArgs e){

    //Connection Strings
    string ConnString = @" Server=example;Database=example;Integrated Security=true";

    string sql = @"SELECT MAX(ClientID) FROM Clients WHERE ClientID &lt;&gt; (SELECT MAX(ClientID) FROM Clients)";

    SqlConnection conn = new SqlConnection(ConnString);

    conn.Open();

    //CREATE DATA ADAPTER
    SqlDataAdapter da = new SqlDataAdapter(sql, conn);

    DataSet ds = new DataSet();

    //FILL DATASET
    da.Fill(ds, "ClientID");

    txtDisplayData.Text = ds.Tables[0].Rows[0].ItemArray[0].ToString();

    conn.Close();
    ds.Dispose();
}  
</code></pre>
