Click here to Skip to main content
15,891,473 members
Home / Discussions / C#
   

C#

 
AnswerRe: Incomplete data after trapping Date Pin
Richard Deeming8-Dec-15 6:11
mveRichard Deeming8-Dec-15 6:11 
GeneralRe: Incomplete data after trapping Date Pin
Robert Kamarowski8-Dec-15 6:18
Robert Kamarowski8-Dec-15 6:18 
GeneralRe: Incomplete data after trapping Date Pin
OriginalGriff8-Dec-15 6:37
mveOriginalGriff8-Dec-15 6:37 
GeneralRe: Incomplete data after trapping Date Pin
Dave Kreskowiak8-Dec-15 7:43
mveDave Kreskowiak8-Dec-15 7:43 
GeneralRe: Incomplete data after trapping Date Pin
Richard Deeming8-Dec-15 7:51
mveRichard Deeming8-Dec-15 7:51 
GeneralRe: Incomplete data after trapping Date Pin
Robert Kamarowski8-Dec-15 8:17
Robert Kamarowski8-Dec-15 8:17 
GeneralRe: Incomplete data after trapping Date Pin
Richard Deeming8-Dec-15 8:30
mveRichard Deeming8-Dec-15 8:30 
GeneralRe: Incomplete data after trapping Date Pin
OriginalGriff8-Dec-15 8:33
mveOriginalGriff8-Dec-15 8:33 
You are storing your dates in the DB as strings as well? Sigh | :sigh:
That's something else you need to change. And it's going to take longer because you have existing data in there that isn't a valid datetime value.

So create a new table using DATETIME values this time, and a program to transfer each row one-by-one after they have been converted, and log the rows that fail so you can manually work out which ones you need to fix. Fix 'em, and then delete the old table, and rename the new. Then change your app to insert DateTime values directly via parameterised queries.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

GeneralRe: Incomplete data after trapping Date Pin
Robert Kamarowski8-Dec-15 8:43
Robert Kamarowski8-Dec-15 8:43 
GeneralRe: Incomplete data after trapping Date Pin
Robert Kamarowski8-Dec-15 10:25
Robert Kamarowski8-Dec-15 10:25 
GeneralRe: Incomplete data after trapping Date Pin
Richard Deeming9-Dec-15 2:56
mveRichard Deeming9-Dec-15 2:56 
GeneralRe: Incomplete data after trapping Date Pin
Robert Kamarowski9-Dec-15 5:07
Robert Kamarowski9-Dec-15 5:07 
QuestionTask.ContinueWith Return Value Pin
Kevin Marois8-Dec-15 5:19
professionalKevin Marois8-Dec-15 5:19 
AnswerRe: Task.ContinueWith Return Value Pin
Richard Deeming8-Dec-15 6:04
mveRichard Deeming8-Dec-15 6:04 
GeneralRe: Task.ContinueWith Return Value Pin
Dave Kreskowiak8-Dec-15 6:09
mveDave Kreskowiak8-Dec-15 6:09 
GeneralRe: Task.ContinueWith Return Value Pin
Kevin Marois8-Dec-15 6:22
professionalKevin Marois8-Dec-15 6:22 
AnswerRe: Task.ContinueWith Return Value Pin
Dave Kreskowiak8-Dec-15 6:08
mveDave Kreskowiak8-Dec-15 6:08 
GeneralRe: Task.ContinueWith Return Value Pin
Kevin Marois8-Dec-15 6:23
professionalKevin Marois8-Dec-15 6:23 
GeneralRe: Task.ContinueWith Return Value Pin
Dave Kreskowiak8-Dec-15 7:20
mveDave Kreskowiak8-Dec-15 7:20 
QuestionMessage Removed Pin
7-Dec-15 15:59
Eilson Tang7-Dec-15 15:59 
AnswerMessage Removed Pin
7-Dec-15 16:38
professionalBillWoodruff7-Dec-15 16:38 
GeneralMessage Removed Pin
7-Dec-15 16:43
Eilson Tang7-Dec-15 16:43 
GeneralMessage Removed Pin
7-Dec-15 16:56
professionalBillWoodruff7-Dec-15 16:56 
QuestionThreads and Dispatcher Pin
Member 121764286-Dec-15 6:23
Member 121764286-Dec-15 6:23 
AnswerRe: Threads and Dispatcher Pin
Richard Deeming7-Dec-15 1:22
mveRichard Deeming7-Dec-15 1:22 

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.