give backcolor to some row of gridview according to db

Question

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.

Sachin Singh · Answer

your requirement seems very simple follow below approach protected void GridView 1 _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.Toint 32 (reader[ 0 ])); } reader.Close(); } catch (Exception ex) { } return Ids; }

Mageshwaran R · Answer

Hi Sonali, Please refer this link, https://blog.sqlauthority.com/2018/06/25/sql-server-alternate-rows-color-in-table-background-in-html/