Time must be egual to data system

Israel

Hi,

I have on my form a Timer1, Label1 and Label2.

Then on my OnLoad Event I put:

Timer1.Start();
conn = new SqlConnection("Data Source = (LocalDB)\\MSSQLLocalDB; AttachDbFilename=C:\\myFolder\\App_Datas\\DB.mdf;Integrated Security = True;Integrated Security = True");
conn.Open();
string commandString = "select top 1 * from operation where S='" + "S" + "' order by nord desc";
SqlCommand comm = new SqlCommand(commandString, conn);
SqlDataReader read = comm.ExecuteReader();
if (read.HasRows)
{
while (read.Read())
{
Label1.Text = read["time"].ToString();
}
}
else
{
}
read.Close();
conn.Close();
if Label1.Text = DateTime.Now.ToString()
Label2.txt = "Yes";

On my timer_Click I put this:

What I need?

When the time its equal to the date system its should display on Label2 the word "yes". Otherwise its cant activate the second Label2.

3 Replies

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

Israel7y ago
@Rajanikant Hawaldar

Can you help and explain me please.
Israel7y ago
@Rajanikant Hawaldar

The code is work perfectly. But I have a little preocupation.

Just for curiosity I do change the label1 code to button1. Means that when the label1 is equal to data system its should click on the button1. But When its not equal to the date system its should just disable the button1. But when I start these codes its ONLY activate the button1. What happen???

private void PrincipalForm_Load(object sender, EventArgs e)
{
timer1.Start();
if (lblTime.Text.ToString() == System.DateTime.Now.ToString("HH:mm"))
{ button1.PerformClick(); } else { button1.Enabled = false; }
}
Rajanikant Hawaldar7y ago
If(Label1.Text.ToString("HH:mm") == System.DateTime.Now.ToString("HH:mm")) { Label2.Text = "Yes"; } else { Label2.Text = string.empty; }