Home / Questions / 258130
Accepted
cosito
Asked: 2020-04-25 09:50:56 +0800 CST 2020-04-25 09:50:56 +0800 CST

Replace from X to 0 C#

  • 772

I am inserting a grid, with a debbug I realize that if I am receiving the data, some are decimal, as you can see I do the conversion, but it turns out that there may be an 'X' in these, so it throws an exception,

So I need that if its value is an X, I change it to 0 (zero) and that in this way I can do the insert correctly.

How can I achieve it?

foreach (DataGridViewRow item in datagrid.Rows)
{
    comando.Parameters.Add(":Stock", item.Cells[2].Value.ToString()); 
    comando.Parameters.Add(":Cant", float.Parse(item.Cells[3].Value.ToString()));
    comando.Parameters.Add(":Units", float.Parse(item.Cells[4].Value.ToString()));
    .
    .
    .
}
c#

2 Answers

  1. Make yourself a helper functor in your work context:

    Func<Cell, Float> numero = c =>
{
    float resultado = 0;
    float.TryParse(c.Value.ToString(), out resultado);
    return resultado;
};

foreach (DataGridViewRow item in datagrid.Rows)
{
    comando.Parameters.Add(":Stock", numero(item.Cells[2]));
    comando.Parameters.Add(":Cant",  numero(item.Cells[3]));
    comando.Parameters.Add(":Units", numero(item.Cells[4]));
    .
    .
    .
}

    The above functor returns 0if the value could not be converted to a number.

    • 6
  2. Best Answer

    You can use the TryParse()in this way you define a default value and if the Xdoes not let you convert correctly nothing will happen

    Something like this

    foreach (DataGridViewRow item in datagrid.Rows)
{
    float cant = 0;
    float.TryParse(item.Cells[3].Value.ToString(), out cant);

    float unit = 0;
    float.TryParse(item.Cells[4].Value.ToString(), out unit);

    comando.Parameters.Add(":Stock", item.Cells[2].Value.ToString()); 
    comando.Parameters.Add(":Cant", cant);
    comando.Parameters.Add(":Units", unit);
    .
    .
    .
}

    If the problem is the culture that you have applied, you could use

    float cant = 0;
float.TryParse(item.Cells[3].Value.ToString(), out cant, CultureInfo.CreateSpecificCulture("en-US"));

    This way you make sure that when receiving a numerical value with the point as decimal separator, it recognizes it

    • 3