public void bindLVQuest() { QuestAnsBAL QuestBAL = new QuestAnsBAL(); QuestAnsBE Quest = new QuestAnsBE(); DataTable dt = new DataTable(); DateTime FromDate = Convert.ToDateTime("2010/01/01"); DateTime Todate = DateTime.Now; if (txtFromDate.Text == "") { Quest.FromDate = FromDate; } else { IFormatProvider culture = new CultureInfo("es-Mx", true); // Quest.FromDate = DateTime.Parse(txtFromDate.Text, culture); Quest.FromDate = DateTime.ParseExact(txtFromDate.Text + " " + ddlFromHrs.Text + ':' + ddlFromMns.Text, "dd/MM/yyyy HH:mm", culture); } if (txtToDate.Text == "") { Quest.ToDate = Todate; } else { IFormatProvider culture = new CultureInfo("es-Mx", true); //Quest.ToDate = DateTime.Parse(txtToDate.Text, culture); Quest.ToDate = DateTime.ParseExact(txtToDate.Text + " " + ddlToHrs.Text + ':' + ddlToMns.Text, "dd/MM/yyyy HH:mm", culture); } if (txtSubject.Text == "") { Quest.Subject = "%"; } else { Quest.Subject = "%" + txtSubject.Text + "%"; } if (txtTags.Text == "") { Quest.Tag = "%"; } else { Quest.Tag = "%" + txtTags.Text + "%"; } if (txtYrOfStudyExp.Text == "") { Quest.YrsOfStudyStream = "%"; } else { Quest.YrsOfStudyStream = "%" + txtYrOfStudyExp.Text + "%"; } if (txtStudyStream.Text == "") //AM?? { Quest.StudyStream = "%"; //AM?? } else { Quest.StudyStream = "%" + txtStudyStream.Text + "%"; //AM?? } // if (txtKeyword.Text == "") //AM???? // { // Quest.Keyword = "%"; // } // else // { // Quest.Keyword = txtKeyword.Text; //} if (QuestBAL.SearchList(ref dt, Quest)) { lvQuestList.DataSource = dt; lvQuestList.DataBind(); recalcNoOfPages(); } else { lvQuestList.Items.Clear(); lvQuestList.DataSource = null; lvQuestList.DataBind(); LoggedIn master = (LoggedIn)this.Master; master.ShowMessage("Sorry No Records Were found", false); } }