public DataTable GetDataNew() { string strStart = dateTimePickerStart.Value.ToString(); string[] strListStart = strStart.Split(' '); strStart = strListStart[0].ToString() + " 00:00:00"; string strEnd = dateTimePickerEnd.Value.ToString() + " 23:59:59"; string[] strListEnd = strEnd.Split(' '); strEnd = strListEnd[0].ToString() + " 23:59:59"; DataTable dt = new DataTable(); dt.TableName = "getqc"; DataSet dst = new DataSet(); using (gjtEmrPatients.emrPatients pi = new gjtEmrPatients.emrPatients()) { dst = pi.GetQCTableByMonthEndNew(strStart, strEnd, "$", Globals.DoctorID); dt = dst.Tables[0]; } return(dt); }