Generic DataGridView V2.0

GenericDataGridView is a new control which is more flexible for coding than a simple datagrid. However, there are a lot of developers who are facing diffulties about DataGridView Calendar, Mask, ComboBox and also Validations. Actually, GenericDataGridView does not support such as important properties.

Generic Data Grid View is a user control which can be really helpful for,

1) Adding a combobox to DataGridView (DataGridViewComboBoxColumn),
2) Adding a calendar to DataGridView (DataGridViewCalendarColumn),
3) Adding a MaskedTextBox to DataGridView (DataGridView MaskedTextBox Column),
4) Validating DataGridView Columns,
5) Saving any editted row with automatic created queries.

While I was coding Generic DataGridView, I try to put all important features which can be required for a project. However, these are unlimited. You can add more properties and methods in order to improve it.

After placing the GenericDataGridView(GDGV) to your project, you should set some properties.

Picture 1 - Properties

DataColumns should be set in design time or in Form_Load such as above and below,
GenericDataGridView1.DataColumns = "OrderID,CustomerID%,OrderDate%,EmployeeID,Freight, ShipPostalCode%"

The columns which has a string or date type should be written with % to distinguish. It is necessary for creating DML(Save and Update Queries). And also the first column should be an identity column. The Northwind Database and The Orders table has been selected to demonstrate the example project. In addition to this, the first column(OrderID) must be an identity column.
GenericDataGridView1.DataConnection = "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Northwind;Data Source=localhost"
GenericDataGridView1.DataColumnsTable = "Orders"

There are some other definitions to be set in form_load;

FillAll : to fill DataGridView.
AddCombo : to add a comboboxcolumn to DataGridView.
AddValidation : to add validation to Columns.
AddMask : to place a mask to columns.
AddCalendar : to add a calendarcolumn to DataGridView.

Picture 2 - Form Load

Picture 3 - Add Combo

Picture 4 - Add Validation

Picture 5 - Add Calendar

Picture 6 - Add Mask

Picture 7 - Form Load

Picture 8 - Calendar Column

Picture 9 - Combo Column

Picture 10 - Validation

Picture 11 - MaskedText Column