Change label's button color when click with condition

Israel

Hi,

I have one label(lbl_signal):

Then when I run my program my label will receive data from a specific column's database like this:

string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Foods\App_Data\office.mdb;Persist Security Info=False";

OleDbConnection sqlCon = new OleDbConnection(connectionString);

sqlCon.Open();

string commandString = "select * from myTable where S ='" + "*" + "'";

OleDbCommand sqlCmd = new OleDbCommand(commandString, sqlCon);

OleDbDataReader read = sqlCmd.ExecuteReader();

if (read.HasRows)

{

while (read.Read())

{

lbl_signal.Text = read["signal"].ToString();

}

else

{

//line of code

}

read.Close();

sqlCon.Close();

Then if there is a word connected it's should be automatically in green's color. If its disconnected it's should be automatically in red's color.

How can I do it with a condition please?

Thanx,

Israel.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta10y ago
Your implementation is wrong.. use that single line after you close your connection, thats it.
lblExample.ForeColor = lblExample.Text=="connected" ? Color.Green:Color.Red.
No need to write ifelse, recheck what you have done mistakes while implementing
if (lbl_signal.Text == "Connected")
{
lbl_signal.Text = "Disconnected";
lbl_signal.ForeColor = lbl_signal.Text == "Connected" ? Color.Green : Color.Green;
}
else
{
lbl_signal.Text = "Connected";
lbl_signal.ForeColor = lbl_signal.Text == "Disconnected" ? Color.Green : Color.Red;
}

0
Israel10y ago
See what I wrote as codes. It's worked well. But it's static (not dynamic). In other word when the data coming from the database. Later when I click on the button it's coming back as you can see in my codes. How can resolv it.
if (lbl_signal.Text == "Connected")
{
lbl_signal.Text = "Disconnected";
lbl_signal.ForeColor = lbl_signal.Text == "Connected" ? Color.Green : Color.Green;
}
else
{
lbl_signal.Text = "Connected";
lbl_signal.ForeColor = lbl_signal.Text == "Disconnected" ? Color.Green : Color.Red;
}
0
Amit Gupta10y ago
Change the forecolor of the label.
lblExample.ForeColor = lblExample.Text=="connected" ? Color.Green:Color.Red.
Add System.Drawing namespace
0