Comments by Member 12330102 (Top 3 by date)

it show or display for only one id. it not check whole database id

private void display()
{
try

{

string ss2 = "Select Date_of_maintenance,Next_date_of_maintenance From CMC ";
if (con.State != ConnectionState.Open)
con.Open();
SqlCommand command = new SqlCommand(ss2, con);
command.ExecuteNonQuery();

DataSet dataSet = new DataSet();
SqlDataReader reader = command.ExecuteReader();
reader.Read();

if (reader.HasRows)
{
textBox1.Text = reader[0].ToString();
textBox2.Text = reader[1].ToString();


DateTime date1 = Convert.ToDateTime(textBox1.Text);

DateTime date2 = Convert.ToDateTime(textBox2.Text);

TimeSpan ts = date2 - date1;

textBox3.Text = ts.TotalDays.ToString();
con.Close();
con.Open();





int value;
if (Int32.TryParse(textBox3.Text, out value))
{
if (value > 0)
{



string ss21 = "Select Machine_Id,Machine_name,S_provider_name,Contact_number From CMC ";
if (con.State != ConnectionState.Open)
con.Open();
SqlCommand command1 = new SqlCommand(ss21, con);
command1.ExecuteNonQuery();

DataSet dataSet1 = new DataSet();
SqlDataReader reader1 = command1.ExecuteReader();
reader1.Read();

if (reader1.HasRows)
{


label23.Text = reader1[0].ToString();
label24.Text = reader1[1].ToString();
label25.Text = reader1[2].ToString();
label26.Text = reader1[3].ToString();
}
}
else
{
// not a number in textbox
}


}