Telerik radgridview change row color based on value

  protected void gvUserDetail_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)

        {

           

            if (e.Item is GridDataItem)

            {

                //Get the instance of the right type

                GridDataItem dataBoundItem = e.Item as GridDataItem;

               

                //Check the formatting condition

                if ((dataBoundItem["column"].Text) == "Test")

                {

                    dataBoundItem["column"].ForeColor = Color.Green;

                    dataBoundItem["column"].Font.Bold = true;

                    e.Item.BackColor = Color.Red;

                    //Customize more...

                }

            }

          

        }

SQL Time Overlap/Conflict Query

select * from table t2

 where name = @name

 and (@inserted_start_datetime between start_datetime and end_datetime

  or @inserted_end_datetime between start_datetime and end_datetime

  or start_datetime between @inserted_start_datetime and @inserted_end_datetime

  or end_datetime between @inserted_start_datetime and @inserted_end_datetime

http://stackoverflow.com/questions/5143269/sql-time-overlap-conflict-query