C# MySQL Question

[d87c]

Hi All, I have a problem I have a MySQL Table, one of the columns' Data Type is TinyInt(1) When I use this line of code it gives an error int newNumber = int.Parse(string.Format("{0}", reader["someField"])); I think the reader is reading a bool value however MySQL Table has row values of 0 & 1 & 6 & 7 so it is not bool true/false type How can I actually grab that value to store into "int newNumber" Thanks

[Richard Andrew x64]

The reader returns type object, and it must be cast to the necessary type for use in function calls. For the TinyInt type, I forget exactly what you need to cast it to but you can try short. Try this:

int newNumber = (int)(short)reader["someField"];

The difficult we do right away... ...the impossible takes slightly longer.

[d87c]

thank for your reply, however, I got an error and it says Specific Cast is not valid

[Richard Andrew x64]

What about:

int newNumber = (int)(byte)reader["fieldName"];

The difficult we do right away... ...the impossible takes slightly longer.

[Dave Kreskowiak]

A MySQL TinyInt is 1 byte. That type in C# i, obviously, byte. BTW, why on earth are you converting the returned database value to a string, only to parse it back to an int??

A guide to posting questions on CodeProject[^]
Dave Kreskowiak

[d87c]

I tried byte as well, still same error, specific cast .... =(

[d87c]

my friend's db is mysql and I am trying to grab his data and then store the value into my sql db Im grabbing the mysql data parse into a collect list its a WCF project so I created a datamember of int newNumber ... thats why I need to grab it int newNumber = (int)(byte)reader["fieldName"]; doesn't work >< it looks like it is reading as a bool value cause if i convert it to a string, it will gives false since in that column, I have values of 0, 4, 6 ,7

[PIEBALDconsult]

How about an sbyte then?

[Lost User]

MySQL TinyInt maps to C#'s byte. Use byte.Parse().

[Luc Pattyn]

using strings and sometype.Parse/TryParse is a complete waste, as Dave already pointed out. all that is required here is a simple numeric-to-numeric cast. :(

Luc Pattyn [My Articles] Nil Volentibus Arduum

[Simon Bang Terkildsen]

you should use Convert.ToInt32(myByte) to convert byte to int Convert class on MSDN[^]

[Luc Pattyn]

reader["someField"] returns an object of some type, probably byte or sbyte. You can see which by looking at reader["someField"].GetType().ToString() Once you know the .NET type of the incoming data just do two casts:

(typeYouWant)(typeItIsNow)reader["someField"]

BTWL The alternative of course is to change the field type in MySQL itself, i.e. modifying the database. :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

[marssilen]

[removed]

[realJSOP]

Nice try, retard. What makes you think a web site by and for programmers is not going to have that base covered? Oh, and by the way, your account will be deleted in the next 30 minutes or so.

".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass." - Dale Earnhardt, 1997

[OriginalGriff]

Normally, I do not agree with your occasional use of "retard". In this case however, it is accurate and justified. 5! :laugh:

Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together. Manfred R. Bihy: "Looks as if OP is learning resistant."

[marssilen]

[marssilen]

[GenJerDan]

Ah, the dreaded inerhtml attack. ;P

Ain't nothin' in the circus for free, kid. My Mu[sic] My Films My Windows Programs, etc.

[Lost User]

My apologies. I wanted to ask the OP to use Convert.ToByte() or an explicit cast like (byte)reader["col1"], but I was carried away by the OP's use of Parse/TryParse. Thanks for pointing out. :-)

[Gonzalo Cao]

Actually this is not your fault, MySQL reader transforms TINYINT to BOOL by default. In order to prevent this, you need to add the following line to you connection string: "Treat Tiny As Boolean = false". Just by doing this, TINYINT will be treated as a numeric value :)