Gustav Brock
gustav at cactus.dk
Thu Apr 5 08:20:48 CDT 2012
Hi Shamil OK, seems like you are limited to basic expressions as in the report viewer. So your expression could look like: Date() - [SavedStartDateValue] but I doubt Date() is at your disposal. Anyway, you should be able to sort on [SavedStartDateValue] and not the days' count. Don't know if a saved query will do ... does it support functions Of VBA like Date()? /gustav >>> Salakhetdinov Shamil <mcp2004 at mail.ru> 05-04-12 14:17 >>> 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