.Net DbType for MySql Column of Int(11)

[Auguy]

The MySql column Physician is Int(11). What should be the DbType in the following statement? Int24,32,..?

command.Parameters.Add("@PhysicianPK", MySqlDbType.Int24, "PhysicianPK")

Auguy
Sylvania/Toledo Ohio

 

[Auguy]

Here's another issue. Trying to use MySql TinyInt in a checkbox in a datagridview. Works ok if checked, but if unchecked it does not go to zero, but to nothing and causes update to fail with a cannot be null error. I used TinyInt after trying the Bit(1) in MySql. Here is code for column setup in the Update command. I also tried Int16

      command.Parameters.Add("@IsPremier", MySqlDbType.Bit, 4, "IsPremier")

Auguy
Sylvania/Toledo Ohio

 

[Auguy]

I solved this latest issue by looping thru the table and changing empty values to 0. That seems like a bad hack.

Auguy
Sylvania/Toledo Ohio