public void bindLVQuest() { QuestAnsBAL QuestBAL = new QuestAnsBAL(); QuestAnsBE Quest = new QuestAnsBE(); DataTable dt = new DataTable(); DateTime FromDate = Convert.ToDateTime("2013/01/01"); DateTime Todate = Convert.ToDateTime("9999/01/01"); 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 (txtShortDesc.Text == "") { Quest.ShortDesc = "%"; } else { Quest.ShortDesc = "%" + txtShortDesc.Text + "%"; } // if (txtKeyword.Text == "") //{ // Quest.Keyword = "%"; //} //else //{ // Quest.Keyword = "%" + txtKeyword.Text + "%"; //} if (QuestBAL.SearchKO(ref dt, Quest)) { KOList.DataSource = dt; KOList.DataBind(); recalcNoOfPages(); } else { KOList.Items.Clear(); KOList.DataSource = null; KOList.DataBind(); LoggedIn master = (LoggedIn)this.Master; master.ShowMessage("There is no data to show.", false); } }