void fill_products() { con.Open(); cmd.CommandText = "select * from student"; cmd.Connection = con; SqlDataAdapter adp = new SqlDataAdapter(); adp.SelectCommand = cmd; DataSet ds = new DataSet(); adp.Fill(ds); DataGrid2.DataSource = ds.Tables[0]; DataGrid2.DataBind(); con.Close(); }
protected void DataGrid2_ItemDataBound(object sender, DataGridItemEventArgs e) { int mark; mark = Convert.ToInt16(DataBinder.Eval(e.Item.DataItem, "mark")); if (mark > 60) { e.Item.BackColor = System.Drawing.Color.AliceBlue; // formatting entire row e.Item.Cells[2].BackColor = System.Drawing.Color.Crimson; //format only a particular cell } }