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();
}