give backcolor to some row of gridview according to db

Sonali Avhad

Theare 2 tables in datatbase of same column name.There are 10 records in first table and same 8 records in second table.

I display 10 records in gridview now i want to give backcolor to those two recods which are not in second table.

How can i use sql query and give backcolor to those 2 records.

for all records i use following query-

"select id,amount,DATE from OT

union

select id,amount,DATE from CH"

for backcolor purpose i have following query-

"select id,amount,DATE from OT where id not in (select id from CH )"

Please help me.

2 Replies

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

Mageshwaran R5y ago
Hi Sonali,
Please refer this link,
https://blog.sqlauthority.com/2018/06/25/sql-server-alternate-rows-color-in-table-background-in-html/
0
Sachin Singh5y ago
your requirement seems very simple
follow below approach
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            try
            {
                GridViewRow grv = e.Row;
                if (getId().Contains(grv.Cells[0].Text)
                {
                    e.Row.BackColor = System.Drawing.Color.Red;
                }

            }
            catch (Exception ex)
            { }
        }

  private List getId()
{
  using (SqlConnection connection =
            new SqlConnection(connectionString))
        {

            SqlCommand command = new SqlCommand("select id from OT where id not in (select id from CH )", connection);

            try
            {
                  List Ids=new List();
                connection.Open();
                SqlDataReader reader = command.ExecuteReader();
                while (reader.Read())
                {
                   Ids.Add(Convert.Toint32(reader[0]));
                }
                reader.Close();
            }
            catch (Exception ex)
            {

            }
             return Ids;

        }
+1