FieldName property of GridViewDecimalColumn does not like a string with two underscores

[Johan]

Hi,

I'm creating a GridViewDecimalColumn as follows:

GridViewDecimalColumn col = new GridViewDecimalColumn();

col.Name = node.Name;
col.FielName = node.Name;
col.HeaderText = friendlyName;

When setting the FieldName property, if node.Name = tb_Column then everything is fine. However, when node.Name = tb_Column_1 then I get a FormatException - Input string was not in a correct format.

Do I need to format that FieldName property in any special way or something?

Thanks

[Richard Slade]

Hi Ryno,

It should not matter what the field name is. Please can you try the following.

1: Start a new project with a RadGridView on it.
2: In form load, add the following code

this.radGridView1.AutoGenerateColumns = false;
m_myList.Add(new Person(10, "Richard"));
m_myList.Add(new Person(20, "Stew"));
m_myList.Add(new Person(30, "Chris"));
m_myList.Add(new Person(40, "Peter"));
radGridView1.DataSource = m_myList;
GridViewDecimalColumn idColumn = new GridViewDecimalColumn();
idColumn.Name = "tb_Id_1";
idColumn.HeaderText = "Id";
idColumn.FieldName = "tb_Id_1";
this.radGridView1.Columns.Add(idColumn);
GridViewTextBoxColumn nameColumn = new GridViewTextBoxColumn();
nameColumn.Name = "Name";
nameColumn.HeaderText = "Name";
nameColumn.FieldName = "Name";
this.radGridView1.Columns.Add(nameColumn);

4: Add the following class

class Person
{
    public Person()
    { }
    public Person(decimal id, string name)
    {
        this.tb_Id_1 = id;
        this.Name = name;
    }
    public decimal tb_Id_1 { get; set; }
    public string Name { get; set; }
}

Let me know if that's ok. You should just see the grid display the data without any issues.
Richard

[Johan]

Richard, thanks again for all your help. I wrote a follow up reply solving my related issues I had with formatting etc.

[Richard Slade]

Ah, I was just reading that. Glad you have it all sorted.
All the best
Richard