how to format a string in linq

Question

im having problem with my string of time.. i wanted to format it so that it will display a more neat design.. can anyone help me with this one

here's my code:

 ViewBag.startTime = (from a in test where a.ID == clientCustomerPositionShiftnfo.ID select new{ a.StartTime}) .AsEnumerable() .Select(a => a.StartTime != "Anytime" ? Convert.ToDateTime(a.StartTime).ToString("HH:mm:ss") : a.StartTime.Trim());

In my view:

 <input type="text" id="txtStartTime" name="txtStartTime" class="inputLong" value="@ViewBag.startTime" disabled="disabled"/>

in my view it doesnt show the value of the time instead it shows something like this "System.Linq.Enumerable+WhereSelectEnumerableIterator2[<>f__AnonymousTypeb1[System.String],System.String]" — Mr.Bobo Haha
– Mr.Bobo Haha, Commented Sep 9, 2013 at 2:50
@tuespetre when i select the property i get the value but i cant format it... i need a way to format the starttime.. — Mr.Bobo Haha
– Mr.Bobo Haha, Commented Sep 9, 2013 at 2:53
A cleaner design would be if the view formats the date using JavaScript and the browser's or users local settings. — Danny Varod
– Danny Varod, Commented Sep 9, 2013 at 2:53

p.s.w.g · Accepted Answer · 2013-09-09 02:51:42Z

Try calling First after your query:

ViewBag.startTime = (from a in test where a.ID == clientCustomerPositionShiftnfo.ID select a.StartTime) .AsEnumerable() .Select(t => t != "Anytime" ? Convert.ToDateTime(t).ToString("HH:mm:ss") : t) .First(); // or FirstOrDefault if your query might not return any results

Or perhaps more cleanly:

var startTime = (from a in test where a.ID == clientCustomerPositionShiftnfo.ID select a.StartTime) .First(); // or FirstOrDefault if your query might not return any results ViewBag.startTime startTime != "Anytime" ? Convert.ToDateTime(startTime).ToString("HH:mm:ss") : startTime;

Collectives™ on Stack Overflow

how to format a string in linq

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related