Fastest way to set a cell value

[Administrator]

Clay,

Is the a faster way to set a cell value in the GDBG other than this.grid[1,1].Text?

Regards,
Thomas

[Administrator]

The most effiecient way to do it is to directly access the datasource. eg,

this.dataTable1.Rows[0]["Col0"] = somevalue;

[Administrator]

Ok, thanks. I case of a unbound coulumn? I''m checking the time with a code profiler and see that the value modification of a cell takes a bit a long time.

Regards,
Thomas

[Administrator]

In an unbound grid that stores data in the GridControl.Data object, then setting the value using grid.SetCellInfo with the proper flags set, or directly accessing grid.Data[row, col] as below, will avoid events and perform 5-10 faster that just directly indexing the GridControl.

GridStyleInfo style = null;
if(grid.Data[row, col] != null
{
   style = new GridStyleInfo(grid.Data[row, col]);
}
else
{
   style = new GridStyleInfo();
}
style.Text = "something";
grid.Data[row, col] = style.Store;

[Administrator]

Thanks Clay.

Now, I have to set the Tag property of the header cell in a GDBG. Did you see any problem when I use this code in my implementation:

GridStyleInfoStore store = this.Model.Data[0, 0];
store.SetValue( store.FindStyleInfoProperty( "Tag" ), "Error" );

The performance is great this way.

Regards,
Thomas

[Administrator]

I think this should be OK. You could not venture past row 0 (and probably column 10) as there is no storage allocated in the Data object past those limits.