Click here to Skip to main content
15,886,963 members
Home / Discussions / C#
   

C#

 
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 
GeneralRe: Converting MySqlDateTime Pin
jschell28-Jan-12 4:39
jschell28-Jan-12 4:39 
GeneralRe: Converting MySqlDateTime Pin
PIEBALDconsult28-Jan-12 12:05
mvePIEBALDconsult28-Jan-12 12:05 
GeneralRe: Converting MySqlDateTime Pin
jschell28-Jan-12 13:54
jschell28-Jan-12 13:54 
QuestionSocket server handling MySQL queries from clients and return the response to them Pin
Islorvat27-Jan-12 4:48
Islorvat27-Jan-12 4:48 
AnswerRe: Socket server handling MySQL queries from clients and return the response to them Pin
Richard Andrew x6427-Jan-12 7:30
professionalRichard Andrew x6427-Jan-12 7:30 
AnswerRe: Socket server handling MySQL queries from clients and return the response to them Pin
SledgeHammer0127-Jan-12 13:25
SledgeHammer0127-Jan-12 13:25 
Questionconnecting external msSQL Pin
nuyts K27-Jan-12 4:41
nuyts K27-Jan-12 4:41 
AnswerRe: connecting external msSQL Pin
Eddy Vluggen27-Jan-12 6:11
professionalEddy Vluggen27-Jan-12 6:11 
Questiondotnetbar gauge control Pin
isang puntos27-Jan-12 4:36
isang puntos27-Jan-12 4:36 
AnswerRe: dotnetbar gauge control Pin
Wes Aday27-Jan-12 5:02
professionalWes Aday27-Jan-12 5:02 
GeneralRe: dotnetbar gauge control Pin
isang puntos28-Jan-12 1:35
isang puntos28-Jan-12 1:35 

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.