protected void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
		
			if (e.Item.ItemType == ListItemType.Header)
			{
				_recordCount = 0;
				_casesOverdue = 0;
			}
			if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
			{
				_recordCount++;

				try
				{
					DateTime nextRepDate = DateTime.Parse(e.Item.Cells[12].Text);
					if (nextRepDate.CompareTo(DateTime.Today) < 0 && e.Item.Cells[15].Text.Trim() == "Open")
					{
						e.Item.Cells[12].ForeColor = Color.Red;
						_casesOverdue++;
					}

					DateTime startDate = DateTime.Parse(e.Item.Cells[4].Text);
					DateTime endDate = (e.Item.Cells[12].Text != " ") ? DateTime.Parse(e.Item.Cells[12].Text) : DateTime.Today;

					TimeSpan dateDiff = endDate.Subtract(startDate);
					int daysOpen = dateDiff.Days;

					((Label) e.Item.Cells[13].FindControl("lblDaysOpen")).Text = daysOpen.ToString();

					DataSet Offenselist = ScidData.DDLGetOffensesByCaseID(Convert.ToInt32(e.Item.Cells[0].Text));
											/*string[] options = { "OptionA", "OptionB", "OptionC" };*/
					DropDownList list = (DropDownList) e.Item.Cells[7].FindControl("ddlGridOffenseList");
					list.DataTextField = "pc_Description";
					list.DataSource = Offenselist;
					list.DataBind();
					
				}
				catch (Exception ex) {}
			}
			if (e.Item.ItemType == ListItemType.Footer)
			{
				lblResultSummary.Text = String.Format("{0} record(s) found matching search criteria with {1} case(s) overdue.", _recordCount, _casesOverdue);
				
			}
		}