public void BindData(string orderBy)
		{
			string columns = "Plog,Status,Priority,DateReported,LastModified,Environment,Applications,ReporterName,DepartmentName,ProblemDetails,ResolvedBy";
			string search = "WHERE Plog like '%"+searchQuery+"%' OR Status like '%"+searchQuery+"%' OR Priority like '%"+searchQuery+"%' OR DateReported like '%"+searchQuery+"%' OR LastModified like '%"+searchQuery+"%' OR Environment like '%"+searchQuery+"%' OR Applications like '%"+searchQuery+"%' OR ReporterName like '%"+searchQuery+"%' OR DepartmentName like '%"+searchQuery+"%' OR ProblemDetails like '%"+searchQuery+"%' OR ResolvedBy like '%"+searchQuery+"%'";
			
			if (Request.QueryString["viewType"] == "Open")
				search = "WHERE Plog like '%"+searchQuery+"%' AND Status ='Open' OR Priority like '%"+searchQuery+"%' OR DateReported like '%"+searchQuery+"%' OR LastModified like '%"+searchQuery+"%' OR Environment like '%"+searchQuery+"%' OR Applications like '%"+searchQuery+"%' OR ReporterName like '%"+searchQuery+"%' OR DepartmentName like '%"+searchQuery+"%' OR ProblemDetails like '%"+searchQuery+"%' OR ResolvedBy like '%"+searchQuery+"%'";
			else if (Request.QueryString["viewType"] == "Closed")
				search = "WHERE Plog like '%"+searchQuery+"%' AND Status ='Closed' OR Priority like '%"+searchQuery+"%' OR DateReported like '%"+searchQuery+"%' OR LastModified like '%"+searchQuery+"%' OR Environment like '%"+searchQuery+"%' OR Applications like '%"+searchQuery+"%' OR ReporterName like '%"+searchQuery+"%' OR DepartmentName like '%"+searchQuery+"%' OR ProblemDetails like '%"+searchQuery+"%' OR ResolvedBy like '%"+searchQuery+"%'";
			else if (Request.QueryString["viewType"] == "Pending")
				search = "WHERE Plog like '%"+searchQuery+"%' AND Status ='Pending' OR Priority like '%"+searchQuery+"%' OR DateReported like '%"+searchQuery+"%' OR LastModified like '%"+searchQuery+"%' OR Environment like '%"+searchQuery+"%' OR Applications like '%"+searchQuery+"%' OR ReporterName like '%"+searchQuery+"%' OR DepartmentName like '%"+searchQuery+"%' OR ProblemDetails like '%"+searchQuery+"%' OR ResolvedBy like '%"+searchQuery+"%'";

			string sql = "SELECT "+columns+" FROM OccurrenceLogs "+search+" ORDER BY "+orderBy+" "+Session["order"].ToString();

			DataTable table = SqlHelper.ExecuteDataset(myConn,CommandType.Text,sql).Tables[0];
			this.MyDataGrid.DataSource = table;
			this.MyDataGrid.DataBind();
		}