Home / Questions / 563306
Accepted
Franqo Balsamo
Asked: 2022-10-21 04:47:50 +0800 CST 2022-10-21 04:47:50 +0800 CST

Exception in the formatting of a data brought from MSSQL in C#

  • 772

Dear, I have a problem when bringing two data from a table of MSSQL. The table contains two fields that I want to fetch: CC_PreFijoand CC_Nro. These data in the table, as attached in the following image, are of type INT the first and type BIGINT the second:

enter image description here

What I do is that by DataGridViewselecting an item from it, I make a query to the table asking for those values ​​(and others as well) but the query returns the following error:

System.FormatException: 'La cadena de entrada no tiene el formato correcto.'

And I notice this line:

int prefijo = Convert.ToInt32(sqlDataReader["prefijo"]?.ToString());

What is my mistake? From already thank you very much

c#

2 Answers

  1. The BigInitis equal to Long(64-bit) in C#, try one of the following:

    int prefijo = Convert.ToInt64(sqlDataReader["prefijo"]?.ToString());
    • 1
  2. Best Answer

    The solution to my problem was to create the type variables intinitialized to 0:

    int prefijo = 0;

    And then I use the TryParsedata type property inttaking as input the value of sqland parsing it to the value of the variable:

    int.TryParse(sqlDataReader["prefijo"].ToString(), out prefijo);
    • 1