var for_formatting = (from n in db.BillMasterDbSet where n.COMPID == compid && n.PATIENTYY == year && n.PATIENTYYID == yearID select n).ToList(); //fetch data
string billdt= "", discharge = "", disTime = "";
foreach(var x in for_formatting)
{
billdt = Convert.ToDateTime(x.BILLDT).ToString("dd-MMM-yyyy");
// Example: Jun-14-2016
discharge = Convert.ToDateTime(x.DISCHGDT).ToString("dd-MMM-yyyy");
disTime = Convert.ToDateTime(x.DISCHGTM).ToString("HH:mm:ss");
}
string billdt= "", discharge = "", disTime = "";
foreach(var x in for_formatting)
{
billdt = Convert.ToDateTime(x.BILLDT).ToString("dd-MMM-yyyy");
// Example: Jun-14-2016
discharge = Convert.ToDateTime(x.DISCHGDT).ToString("dd-MMM-yyyy");
disTime = Convert.ToDateTime(x.DISCHGTM).ToString("HH:mm:ss");
}
No comments:
Post a Comment