Click here to Skip to main content
15,916,412 members
Home / Discussions / C#
   

C#

 
GeneralRe: Writing source code in seperate files Pin
Luc Pattyn28-Jan-12 22:16
sitebuilderLuc Pattyn28-Jan-12 22:16 
AnswerRe: Writing source code in seperate files Pin
Dean Oliver27-Jan-12 22:38
Dean Oliver27-Jan-12 22:38 
AnswerRe: Writing source code in seperate files Pin
jschell28-Jan-12 4:35
jschell28-Jan-12 4:35 
GeneralRe: Writing source code in seperate files Pin
PIEBALDconsult28-Jan-12 13:34
mvePIEBALDconsult28-Jan-12 13:34 
AnswerRe: Writing source code in seperate files Pin
Eddy Vluggen28-Jan-12 5:29
professionalEddy Vluggen28-Jan-12 5:29 
GeneralRe: Writing source code in seperate files Pin
PIEBALDconsult28-Jan-12 13:37
mvePIEBALDconsult28-Jan-12 13:37 
AnswerRe: Writing source code in seperate files Pin
BobJanova28-Jan-12 6:32
BobJanova28-Jan-12 6:32 
QuestionSimple MultiThread question Pin
PozzaVecia27-Jan-12 20:51
PozzaVecia27-Jan-12 20:51 
AnswerRe: Simple MultiThread question Pin
OriginalGriff27-Jan-12 21:14
mveOriginalGriff27-Jan-12 21:14 
GeneralRe: Simple MultiThread question Pin
PozzaVecia28-Jan-12 1:21
PozzaVecia28-Jan-12 1:21 
GeneralRe: Simple MultiThread question Pin
OriginalGriff28-Jan-12 2:41
mveOriginalGriff28-Jan-12 2:41 
AnswerRe: Simple MultiThread question Pin
Luc Pattyn27-Jan-12 22:22
sitebuilderLuc Pattyn27-Jan-12 22:22 
GeneralRe: Simple MultiThread question Pin
PozzaVecia28-Jan-12 1:56
PozzaVecia28-Jan-12 1:56 
AnswerRe: Simple MultiThread question Pin
Luc Pattyn28-Jan-12 2:29
sitebuilderLuc Pattyn28-Jan-12 2:29 
GeneralRe: Simple MultiThread question Pin
harold aptroot28-Jan-12 2:24
harold aptroot28-Jan-12 2:24 
AnswerRe: Simple MultiThread question Pin
Luc Pattyn28-Jan-12 2:50
sitebuilderLuc Pattyn28-Jan-12 2:50 
AnswerRe: Simple MultiThread question Pin
BobJanova28-Jan-12 6:45
BobJanova28-Jan-12 6:45 
GeneralRe: Simple MultiThread question Pin
PozzaVecia28-Jan-12 9:50
PozzaVecia28-Jan-12 9:50 
QuestionConverting MySqlDateTime Pin
Ian_urquhart27-Jan-12 4:50
Ian_urquhart27-Jan-12 4:50 
Hi there
Im pretty new to C# and im having a real problem when i getting data from my MySql Database.

Firstly I read the data in to a Datatable then i read it in to a Dictionary(Like vb Collection) however when i tried to convert it straight to a string i comes out as DBNULL this was pretty annoying!!

so to get round it it tried conveting it to datetime first and then to string which worked as long as im stepping over, then when i ran it normally i got
'Object cannot be cast from DBNull to other types.'

this is really annoying

when it brings me back in to the code i can see that it has taken the data in the datetime var but still kick up the error

C#
if (datatype == "MySql.Data.Types.MySqlDateTime")
                   {
                      DateTime Ddata = Convert.ToDateTime(dt.Rows[0][colname]);
                      data = Convert.ToString(Ddata);
                   }
                   else
                   {
                       data = Convert.ToString(dt.Rows[0][colname]);
                   }


I'll be real grateful if someone can help with this as im Stumped

Regards Ian
AnswerRe: Converting MySqlDateTime Pin
Bernhard Hiller27-Jan-12 5:01
Bernhard Hiller27-Jan-12 5:01 
GeneralRe: Converting MySqlDateTime Pin
Ian_urquhart27-Jan-12 5:27
Ian_urquhart27-Jan-12 5:27 
AnswerRe: Converting MySqlDateTime Pin
PIEBALDconsult27-Jan-12 5:08
mvePIEBALDconsult27-Jan-12 5:08 
GeneralRe: Converting MySqlDateTime Pin
Ian_urquhart27-Jan-12 5:31
Ian_urquhart27-Jan-12 5:31 
GeneralRe: Converting MySqlDateTime Pin
Richard Andrew x6427-Jan-12 16:43
professionalRichard Andrew x6427-Jan-12 16:43 
GeneralRe: Converting MySqlDateTime Pin
PIEBALDconsult28-Jan-12 4:03
mvePIEBALDconsult28-Jan-12 4:03 

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.