Salakhetdinov Shamil
mcp2004 at mail.ru
Thu Apr 5 07:17:19 CDT 2012
Hi Gustav -- Setting cell value in.RowPostPaint works well, but DataGridView is flickering a bit... > Not possible to create? I meant I can't create a calculated column with a formula as e.g. ([SavedStartDateValue] - DataTime.Today).TotalDays Never used that "complex" calculated columns before. The set of possible calculated columns expressions seems to be very limited - http://msdn.microsoft.com/en-us/library/system.data.datacolumn.expression.aspx I have also tried to use unbound column and to set its value in .RowPostPaint event - that worked well, DataGridView flickering disappeared but in this case automatic sorting of DataGridView by unbound column isn't working. Implementation of manual (custom code driven) sorting seems to be not right way to go as it would be laborious and it would relatively slow comparing to bound columns sorting: the source dataset has more than 10000 rows and the quantity of rows will grow with time - that is a customer requirement... So I decided to give-up and to get column values calculated in a back-end MS Access database query... Do you expect there could be an effective solution for my case without using calculated columns created in MS Access back-end queries? Thank you. -- Shamil Thu, 05 Apr 2012 13:24:27 +0200 от "Gustav Brock" <gustav at cactus.dk>: > Hi Shamil > > Not possible to create? > > Are you receiving an error or getting blank results before the RowPostPaint? > > /gustav > > > >>> Salakhetdinov Shamil <mcp2004 at mail.ru> 05-04-12 11:53 >>> > Hi All -- > > I have a DataGridView bound to a DataSet created on MS Access back-end table using built-in into DataSet SQL query. > And I need a calculated column to have a value equal to a > > ([SavedStartDateValue] - DataTime.Today).TotalDays > > That seems to be not possible to create? > > I tried to use .PostPaint event to have a value calculated on run-time. It works but DataGridView "flickers". > > Because of design limitations I can't create a custom query in MS Access back-end db with a calculated field value to be used as binding source for target DataGridView column. > > I'd be very grateful for any useful for my real programming case advises. > > TIA, > -- Shamil > > > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com > >