Databases
StackOverflow2013
Postsdbo
POReading MySQL Int(10) value in C# doesn't work
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POReading MySQL Int(10) value in C# doesn't work
    primarykey
    data
    text
    <p>I'm trying to connect to mysql from C# WinForms program. Everything seems to be working fine, i get 99% of column values just fine just one <code>int</code> column doesn't want to return proper value:</p> <pre><code> public static void getFromMySqlAndInsertIntoSql() { const string preparedCommand = @" select * from agreements"; using (var varConnection = Locale.sqlConnectOneTimeMySql(Locale.sqlDataConnectionDetailsMySQL)) using (var sqlQuery = new MySqlCommand(preparedCommand, varConnection)) { using (var sqlQueryResult = sqlQuery.ExecuteReader()) while (sqlQueryResult.Read()) { int agr_id = sqlQueryResult["agr_id"] is int ? (int)sqlQueryResult["agr_id"] : int.MinValue; string agr_idTest = sqlQueryResult["agr_id"].ToString(); string agr_fname = sqlQueryResult["agr_fname"].ToString(); int agr_stocks_count = sqlQueryResult["agr_stocks_count"] is int ? (int)sqlQueryResult["agr_stocks_count"] : int.MinValue; MessageBox.Show(agr_id.ToString(), agr_idTest); } } } } </code></pre> <p><code>agr_id</code> always returns int.MinValue, but <code>agr_idTest</code> it returns proper string. <code>int</code> value for <code>agr_stocks_count</code> returns int properly so it doesn't seem to be the problem with code. </p> <p>The only difference I can find in the MySQL table between first int column and the other is:</p> <pre><code>Field Type Collation Attributes Null Default Extra agr_id int(10) UNSIGNED No None AUTO_INCREMENT agr_stocks_count int(11) No None </code></pre> <p>Does anyone have explanation?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USMadBoy
    1. USMadBoy
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COIs agr_id an int? I would think it is either uint or maybe ulong.
      singulars
      1. POReading MySQL Int(10) value in C# doesn't work
      1. USVladislav Vaintroub
    2. COAs you can see in MySql Table (column overview) it says int(10).
      singulars
      1. POReading MySQL Int(10) value in C# doesn't work
      1. USMadBoy
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload