datagridview control

Submitted by: 
In this tutorial, I will teach you how to retrieve data with checkbox in vb.net. This procedure is very useful if you want something to retrieve in the database that would then be displayed in the datagridview together with the checkboxes. If you want to find out how it’s done, check the instructions below.
Submitted by: 
In some cases, you want to add new rows to the DataGridView programmatically. If you are using a data-bound DataGridView control, you cannot easily use the cells properties of the DataGridView control. All you need to do is use the dataset where the DataGridView control is connected. Say you want to get the record from employees table and put it in DataGridView. Here’s how to do it: Dim strSQL As...
Submitted by: 
If you encounter the following error: System.Data.InvalidConstraintException: ForeignKeyConstraint FK_foreign_key_name requires the child key values (-1) to exist in the parent table. Or The INSERT statement conflicted with the FOREIGN KEY constraint "FK_foreign_key_name ". The conflict occurred in database "YourDatabase", table "dbo.Tablename", column 'YourPrimaryKey'. The statement has been...
Submitted by: 
I read a lot of question about this on the forum and thought it’s time to share with you on how to differentiate two cell values in DataGridView control. By default we use the Value property of cells like: QtyOrdered = InvoiceDetails ( "Qty" , e. RowIndex ) . Value Another is to use the FormattedValue like: QtyOrdered = InvoiceDetails ( "Qty " , e. RowIndex...
Submitted by: 
On my last tutorial I discuss on “ How to Display Data in Windows Forms ”. This time I will teach you on “How to Create Master/Detail Windows Forms”. Creating a master/detail form still requires the same method as displaying data in windows forms. Except that we use additional control called “DataGridView”. This control will display the related record known as child form. In our database example...
Submitted by: 
This source code will show you on how to make a ComboBox in DataGridView autocomplete. This project is using a simple Order database for the sake of this demo.