>> private void btnLocOfficeNotes_Click(object sender, EventArgs e) >> { >> string filterON = ""; >> DateTime begDate, endDate; >> bool testDateOK = DateTime.TryParse(this.mtxtBegDate.Text, out begDate); >> if (testDateOK) >> { >> if (!mmType.IsEmpty(filterON)) >> filterON += " AND "; >> filterON += "EnterDateTime >= '" + begDate.ToShortDateString() + "'"; >> //Add hours and minutes to make sure that I get all entries for the end date, regardless of time >> if (this.mtxtEndDate.Text.Substring(0, 3) == " /") >> { >> endDate = begDate.AddHours(23).AddMinutes(59); >> } >> else >> { >> testDateOK = DateTime.TryParse(this.mtxtEndDate.Text, out endDate); >> if (testDateOK) >> endDate = endDate.AddHours(23).AddMinutes(59); >> } >> filterON += " AND EnterDateTime <= '" + endDate.ToShortDateString() + "'"; >> } >> >> DataTable dtON = (DataTable)oOfficeNote.GetCurrentDataSet().Tables[0]; >> dtON.DefaultView.RowFilter = (filterON); >> dtON.DefaultView.RowStateFilter = DataViewRowState.ModifiedCurrent; >>>>
filterON = String.Format("EnterDateTime >= #{0}# and EnterDateTime <= #{1}#", begDate.Date,endDate.Date);Cetin
this.BindControl(this.grdMyGrid);It's amazing how many different ways there are to set the same filter. Thanks again for your help.