private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Optimum"].ConnectionString);
string query = "select Firstname,Lastname,Address,Email,registrationnumber,phonenumber,alternatenumber,packagename1,duration,amount,packagename2,duration2,amount2,total,Duedate1,Duedate2 from register ";
SqlCommand comdata = new SqlCommand(query, con);
try {
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = comdata;
dt = new DataTable();
sda.Fill(dt);
BindingSource bs = new BindingSource();
bs.DataSource = dt;
dataGridView1.DataSource = bs;
sda.Update(dt);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
code to show data in gridview .
I want is when the due date passes the following row should be higlighted in red.