Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

C# MySQL Question

21 Posts 13 Posters 1 Views 1 Watching

R 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.
B Offline
B Offline
BoxyBrown

wrote on last edited by

#21

I think casting (int)(short) is redundant. Here is good table for mapping clr to sql types http://msdn.microsoft.com/en-us/library/bb386947.aspx[^]
1 Reply Last reply

0