Click here to Skip to main content
14,391,319 members
   

C#

 
QuestionC# How to show my List of data in Pivot format Pin
Mou_kol16-Nov-19 9:17
MemberMou_kol16-Nov-19 9:17 
QuestionRe: C# How to show my List of data in Pivot format Pin
Eddy Vluggen16-Nov-19 10:30
mveEddy Vluggen16-Nov-19 10:30 
AnswerRe: C# How to show my List of data in Pivot format Pin
Richard Deeming17-Nov-19 23:57
communityengineerRichard Deeming17-Nov-19 23:57 
Questionprint statements within a method is not displaying on Rich text box in c# windows form Pin
Member 1465244915-Nov-19 19:35
MemberMember 1465244915-Nov-19 19:35 
AnswerRe: print statements within a method is not displaying on Rich text box in c# windows form Pin
OriginalGriff15-Nov-19 20:57
mveOriginalGriff15-Nov-19 20:57 
GeneralRe: print statements within a method is not displaying on Rich text box in c# windows form Pin
Member 1465244915-Nov-19 23:30
MemberMember 1465244915-Nov-19 23:30 
GeneralRe: print statements within a method is not displaying on Rich text box in c# windows form Pin
OriginalGriff15-Nov-19 23:48
mveOriginalGriff15-Nov-19 23:48 
QuestionGetValueOrDefault() Throws Pin
Kevin Marois15-Nov-19 7:35
professionalKevin Marois15-Nov-19 7:35 
I have a SQL table called Users with a DateTime field called ModifiedDT.

In this code...
results = (from u in dc.Users
            select new UserEntity
            {
                .
                .
                .
                ModifiedDT = u.ModifiedDT.GetValueOrDefault()  //<==THROWS
            }).ToList();
The code above throws "The conversion of a varchar data type to a datetime data type resulted in an out-of-range value."

if I change it to this, it works:
results = (from u in dc.Users
            select new UserEntity
            {
                .
                .
                .
                ModifiedDT = u.ModifiedDT.HasValue ? u.ModifiedDT : null //<== WORKS
            }).ToList();
I always thought that GetValueOrDefault() was doing this under the sheets:
public T GetValueOrDefault(T defaultValue)
{
    return HasValue ? value : defaultValue;
}

Any ideas on why this doesn't work?
If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.

AnswerRe: GetValueOrDefault() Throws Pin
Eddy Vluggen15-Nov-19 7:50
mveEddy Vluggen15-Nov-19 7:50 
GeneralRe: GetValueOrDefault() Throws Pin
Kevin Marois15-Nov-19 9:09
professionalKevin Marois15-Nov-19 9:09 
GeneralRe: GetValueOrDefault() Throws Pin
Eddy Vluggen15-Nov-19 10:16
mveEddy Vluggen15-Nov-19 10:16 
GeneralRe: GetValueOrDefault() Throws Pin
Kevin Marois15-Nov-19 10:23
professionalKevin Marois15-Nov-19 10:23 
GeneralRe: GetValueOrDefault() Throws Pin
Eddy Vluggen16-Nov-19 1:31
mveEddy Vluggen16-Nov-19 1:31 
QuestionRe: GetValueOrDefault() Throws Pin
Eddy Vluggen17-Nov-19 1:34
mveEddy Vluggen17-Nov-19 1:34 
AnswerRe: GetValueOrDefault() Throws Pin
Richard Deeming17-Nov-19 23:53
communityengineerRichard Deeming17-Nov-19 23:53 
GeneralRe: GetValueOrDefault() Throws Pin
Kevin Marois18-Nov-19 9:40
professionalKevin Marois18-Nov-19 9:40 
GeneralRe: GetValueOrDefault() Throws Pin
Richard Deeming18-Nov-19 9:48
communityengineerRichard Deeming18-Nov-19 9:48 
GeneralRe: GetValueOrDefault() Throws Pin
Kevin Marois18-Nov-19 9:54
professionalKevin Marois18-Nov-19 9:54 
GeneralRe: GetValueOrDefault() Throws Pin
Richard Deeming18-Nov-19 10:00
communityengineerRichard Deeming18-Nov-19 10:00 
GeneralRe: GetValueOrDefault() Throws Pin
Kevin Marois18-Nov-19 10:02
professionalKevin Marois18-Nov-19 10:02 
GeneralRe: GetValueOrDefault() Throws Pin
Richard Deeming18-Nov-19 10:04
communityengineerRichard Deeming18-Nov-19 10:04 
GeneralRe: GetValueOrDefault() Throws Pin
Kevin Marois18-Nov-19 10:24
professionalKevin Marois18-Nov-19 10:24 
QuestionDAL Exception Handling Pin
Kevin Marois15-Nov-19 5:33
professionalKevin Marois15-Nov-19 5:33 
AnswerRe: DAL Exception Handling Pin
Pete O'Hanlon15-Nov-19 5:40
communityengineerPete O'Hanlon15-Nov-19 5:40 
GeneralRe: DAL Exception Handling Pin
OriginalGriff15-Nov-19 6:04
mveOriginalGriff15-Nov-19 6:04 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.