Sunday, December 18, 2011

DataTable doesn't support CheckState values

DataTable (related to DataSet) doesn't parse CheckState values when a column of CheckState data type is added using the Visual Studio designer.

Friday, December 16, 2011

Handling CellClick event suppresses CellDoubleClick event.

Sri Guru Gauranga Jayate

In DataGridView, if one handles the CellClick event, CellDoubleClick event doesn't fire.

Om namo shridharaya.
Sri Guru Gauranga Jayate

DataGridView CellFormatting event is funny. As per the MSDN, the ConvertEventArgs argument has a property 'Value' that holds the unformatted value and must be set to the formatted (converted) value inside the event handler. But for DataGridViewCheckBoxColumn, this property had a fixed (constant) value irrespective of the underlying value of the DataGridView cell.

Om namo shridharaya

Wednesday, December 14, 2011

tableAdapter.Update method is 2-way

Sri Guru Gauranga Jayate

tableAdapter.Update method implies not just saving the dataset to the database but also retrieval of any autoincrement (identity) key values to the dataset after saving it to the database. In other words there's no need to call tableAdapter.Fill method to get the identity key values.

Om namo sridharaya.