Click here to Skip to main content
14,922,146 members
Home / Discussions / C#
   

C#

 
QuestionC# How to show my List of data in Pivot format Pin
Mou_kol16-Nov-19 8:17
MemberMou_kol16-Nov-19 8:17 
QuestionRe: C# How to show my List of data in Pivot format Pin
Eddy Vluggen16-Nov-19 9:30
professionalEddy Vluggen16-Nov-19 9:30 
AnswerRe: C# How to show my List of data in Pivot format Pin
Richard Deeming17-Nov-19 22:57
mveRichard Deeming17-Nov-19 22:57 
Questionprint statements within a method is not displaying on Rich text box in c# windows form Pin
Member 1465244915-Nov-19 18:35
MemberMember 1465244915-Nov-19 18:35 
AnswerRe: print statements within a method is not displaying on Rich text box in c# windows form Pin
OriginalGriff15-Nov-19 19:57
mveOriginalGriff15-Nov-19 19:57 
GeneralRe: print statements within a method is not displaying on Rich text box in c# windows form Pin
Member 1465244915-Nov-19 22:30
MemberMember 1465244915-Nov-19 22:30 
GeneralRe: print statements within a method is not displaying on Rich text box in c# windows form Pin
OriginalGriff15-Nov-19 22:48
mveOriginalGriff15-Nov-19 22:48 
QuestionGetValueOrDefault() Throws Pin
Kevin Marois15-Nov-19 6:35
professionalKevin Marois15-Nov-19 6: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 6:50
professionalEddy Vluggen15-Nov-19 6:50 
GeneralRe: GetValueOrDefault() Throws Pin
Kevin Marois15-Nov-19 8:09
professionalKevin Marois15-Nov-19 8:09 
GeneralRe: GetValueOrDefault() Throws Pin
Eddy Vluggen15-Nov-19 9:16
professionalEddy Vluggen15-Nov-19 9:16 
GeneralRe: GetValueOrDefault() Throws Pin
Kevin Marois15-Nov-19 9:23
professionalKevin Marois15-Nov-19 9:23 
GeneralRe: GetValueOrDefault() Throws Pin
Eddy Vluggen16-Nov-19 0:31
professionalEddy Vluggen16-Nov-19 0:31 
QuestionRe: GetValueOrDefault() Throws Pin
Eddy Vluggen17-Nov-19 0:34
professionalEddy Vluggen17-Nov-19 0:34 
AnswerRe: GetValueOrDefault() Throws Pin
Richard Deeming17-Nov-19 22:53
mveRichard Deeming17-Nov-19 22:53 
GeneralRe: GetValueOrDefault() Throws Pin
Kevin Marois18-Nov-19 8:40
professionalKevin Marois18-Nov-19 8:40 
GeneralRe: GetValueOrDefault() Throws Pin
Richard Deeming18-Nov-19 8:48
mveRichard Deeming18-Nov-19 8:48 
GeneralRe: GetValueOrDefault() Throws Pin
Kevin Marois18-Nov-19 8:54
professionalKevin Marois18-Nov-19 8:54 
GeneralRe: GetValueOrDefault() Throws Pin
Richard Deeming18-Nov-19 9:00
mveRichard Deeming18-Nov-19 9:00 
GeneralRe: GetValueOrDefault() Throws Pin
Kevin Marois18-Nov-19 9:02
professionalKevin Marois18-Nov-19 9:02 
GeneralRe: GetValueOrDefault() Throws Pin
Richard Deeming18-Nov-19 9:04
mveRichard Deeming18-Nov-19 9:04 
GeneralRe: GetValueOrDefault() Throws Pin
Kevin Marois18-Nov-19 9:24
professionalKevin Marois18-Nov-19 9:24 
QuestionDAL Exception Handling Pin
Kevin Marois15-Nov-19 4:33
professionalKevin Marois15-Nov-19 4:33 
AnswerRe: DAL Exception Handling Pin
Pete O'Hanlon15-Nov-19 4:40
mvePete O'Hanlon15-Nov-19 4:40 
GeneralRe: DAL Exception Handling Pin
OriginalGriff15-Nov-19 5:04
mveOriginalGriff15-Nov-19 5: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.