Click here to Skip to main content
14,920,488 members
Articles / Desktop Programming / Windows Forms
Posted 24 Jul 2007


131 bookmarked

DataGridView with Detail Edit Form - VS 2005

Rate me:
Please Sign up or sign in to vote.
4.36/5 (30 votes)
24 Jul 2007CPOL4 min read
How to create a DataGridView with an associated Detail Edit Form using a strongly typed dataset data layer.

Sample Image


This article is a tutorial on how to create a WinForms selectable datagridview with a separate Form for editing detail row data using a strongly typed DataSet data layer. We will use Visual Studio 2005 and .NET 2.0.


Creating an editable datagrid is a very straightforward way to edit a datagrid's values, but sometimes a separate editable Form/UserControl is desired (increased flexibility, more detail, etc.). This example will load the editable fields and lookups with the grid on Form load. This will keep us from having to synchronize and manage separate instances of similar data and will reduce round trips to the database. When dealing with lots of records, you would want to implement a where filter in your query. We will include a Save button on the Edit form. The Save button could just as easily be implemented on the main form. The edit form could also be changed to a UserControl to display on the main form instead of a popup.


1. Add a DataSource (Strongly typed dataset)

  • Create a new Windows Forms Project and create two forms, Orders and Order.
  • Open Orders in Design View.
  • Click on Add New Datasource in the Data Sources Window.

    Add Data Source

  • Choose Database as the Datasource Type.
  • Create a New Connection.
  • Select Microsoft SQL Server (SqlClient) as the Data Source.
  • Enter the location and login credentials for the Northwind Database.
  • Click Next till you get to Choose Your Database Objects.
  • Select OrderID, CustomerID, and EmployeeID from the Orders table, CustomerID, CompanyName, and ContactName from the Customers table, and EmployeeID, LastName,FirstName and Title from the Employees table as below:

    All Tables

    Image 4 Image 5Image 6

  • Click Finish.


    This automatically creates the NorthwindDataSet strongly typed dataset with related tables/tableAdapters.

    Image 7

  • Change the CustomerID and EmployeeID columns to ComboBoxes in the Data Sources Window.

    Image 8

2. Create the DataGridView

  • Drag the Orders table from the Data Sources Window onto the Orders form.

    Image 9

  • This will create a NorthWindDataSet instance, a BindingSource, and a BindingNavigator.
  • Delete the BindingNavigator.

    Image 10

  • Click the DataGridView's "Smart Tag" to open the DataGridView Tasks Window.

    Image 11

  • Disable Editing, Deleting, and Adding. Then dock in parent container.
  • Click Edit Columns...Change the CustomerID and EmployeeID columns to DataGridViewComboBoxColumn ColumnTypes.


  • Bind the Datasource, DisplayMember, and ValueMember properties for the Customer and Employee columns.



    Customer Column

    Employee Column


    Selecting the DataSources from the Project Data Sources node automatically creates the BindingSources and TableAdapters for the Form.

  • Change the DisplayStyle to Nothing for both columns since these will be read-only.

3. Create the Edit Form

  • Open the Order form in design view.
  • Change the NorthwindDataSet.Orders table in the DataSources Window from DataGridView to Details.

    Image 17

  • Drag the detail table from the DataSources Window onto the Order form. This will create the 3 controls on the form as well as the DataSet, BindingSource, TableAdapter, and BindingNavigator.
  • Delete the BindingNavigator.
  • Drop a Button control on the form and rename it ButtonSave.
  • Click each ComboBoxes' "Smart Tag" to edit the DataSource, DisplayMember, SelectedValue, and ValueMember properties as we did earlier with the GridViewComboBoxColumns.
    You must check the Use data bound items option to edit these values.

    Smart Tag

    Data Source Selected Value

  • This will create BindingSource and TableAdapter components on the form for the Employees and Customers tables.
  • Delete the corresponding TableAdapters (Not the OrdersTableAdapter) since we will be filling these tables from the Orders form.
  • Set the DataBindings.Text property to None since we're now binding to the SelectedValue property.

    Text DataBinding

4. Instantiate the Edit Form

  • Create a Sub New() in the Edit Form.

    Order Sub New

  • Double-click the Save button in design mode to create a click event handler.
  • Use the following code (fix any naming differences):

    Private Sub Orders_FormClosing(ByVal sender As Object, _
            ByVal e As System.Windows.Forms.FormClosingEventArgs) _
            Handles Me.FormClosing
        'Reject any changes that were not saved.
    End Sub
    Private Sub ButtonSave_Click(ByVal sender As System.Object, _
            ByVal e As System.EventArgs) Handles ButtonSave.Click
        'Update the database and close.
        If Not Me.OrdersTableAdapter.Update(Me.NorthwindDataset.Orders) > 0 _
            MsgBox("No records were updated.")
        End If
    End Sub
    Public Sub New(ByVal nwDataSet As NorthwindDataSet, _
                        ByVal position As Integer)
        ' This call is required by the Windows Form Designer.
        ' Add any initialization after the InitializeComponent() call.
        ' We will specify the DataSet from the DataGrid form here
        Me.NorthwindDataset = nwDataSet
        Me.OrdersBindingSource.DataSource = Me.NorthwindDataSet
        Me.CustomersBindingSource.DataSource = Me.NorthwindDataSet
        Me.EmployeesBindingSource.DataSource = Me.NorthwindDataSet
        Me.OrdersBindingSource.Position = position
    End Sub
    Private Sub Order_Load(ByVal sender As System.Object, _
            ByVal e As System.EventArgs) Handles MyBase.Load
        'Do not refill. You could optionally refresh this record or
        'access additional database columns by creating another query
        'with a primary key parameter in the table adapter.
    End Sub


    In Sub New, we will pass in the dataset created and filled with the grid. We then point the local NorthwindDataSet variable to the existing dataset. This does not change the properties already set in InitializeComponent for the DataSet, so we must reconfigure the other elements on the form to point to the existing DataSet. Fortunately, the BindingSources provide abstraction. We need only reset the 3 BindingSources' DataSource properties. We then set the BindingSource position so the form knows which record to edit.

  • On Save click, we will save the changes and exit.
  • Finally on form close, we undo any changes that were not saved, because the dataset is shared with the grid.

5. Code the DataGridView Double-click event

  • Open the Orders form in code view.
  • Create a RowHeaderMouseDoubleClick event handler.

    Grid Double Click

  • Create a FormClosing event handler.
  • Use the following code (fix any naming differences):

    Private Sub Orders_FormClosing(ByVal sender As Object, _
        ByVal e As System.Windows.Forms.FormClosingEventArgs) _
        Handles Me.FormClosing
    End Sub
    Private Sub Orders_Load(ByVal sender As System.Object, _
            ByVal e As System.EventArgs) Handles MyBase.Load
        'TODO: This line of code loads data into the
        ''NorthwindDataSet.Employees' table.
        'You can move, or remove it, as needed.
        'TODO: This line of code loads data into the
        ''NorthwindDataSet.Customers' table.
        'You can move, or remove it, as needed.
        'TODO: This line of code loads data into the
        ''NorthwindDataSet.Orders' table. 
        'You can move, or remove it, as needed.
    End Sub
    Private Sub OrdersDataGridView_RowHeaderMouseDoubleClick_
        (ByVal sender As Object, ByVal e _
        As System.Windows.Forms.DataGridViewCellMouseEventArgs) _
        Handles OrdersDataGridView.RowHeaderMouseDoubleClick
        If Me.OrdersDataGridView.SelectedRows.Count > 0 Then
            Dim editForm As New Order(Me.NorthwindDataSet, _
            DataBoundItem, DataRowView).Row, NorthwindDataSet.OrdersRow)))
        End If
    End Sub


The DataSet is filled on form load. The tableadapter fill statements were created by configuring the BindingSource. We have to dispose of the grid before the form closes to avoid possible DataErrors from the GridViewComboBoxColumns.

The Double-click event instantiates the detail edit form, passing in the DataSet and the position. The position is found by tracking the selected row back to its row instance in the order table, then finding the index of that row in the dataset.


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Robert R Freeman
Chief Technology Officer Kiefer Consulting
United States United States
Sacramento, CA based Senior .Net and SharePoint Solution Architect for Kiefer Consulting
B.S. in Mathematics from UCDavis
.NET Wizard - Experts-Exchange
MCSD, MCTS: MOSS 2007 Config

Some of the bigger questions:
1. What is the meaning of my life?
To satisfy the purpose of your creator(s). (Meaning must derive from purpose. Those who create you, give you meaning.)

2. Who is my creator?
Ultimately, God is your creator. God designed and created the universe and everything in it. You and others in your life can also be a part of your creation, overriding or furthering God's purpose.

3. What is God's purpose for me?
To love and be loved by your creator and others and to enjoy the life you've been given.
This can be distinguished two ways.
a. Use your built in common sense (morality/feelings)
b. Use the creator's handbook. Fortunately our creator did not abandon us. He is with us now and even lived and died as one of us. Check out his biography in "The Bible"

Note on free-will vs. predetermination:
God exists outside the constraints of time. He exists at every point in time simultaneously and knew of your birth and every decision you will/have made. But this does not mean God predetermined any of it. Pre and post are time related concepts that do not apply to God. God always has been and always will be. He determines our universe to exist, gives it the parameters of natural law, and allows us to make our own way through it (free-will). Note that these are all present tense, it would be more appropriate to use past, present, and future tense combined. God's purpose is for us to love him and one another. But a prerequisite of love is the free-will to love. So even though God wants us to love him/others, he can not ensure it. He can, however, help us if we allow him to. A miracle is God modifying natural parameters in response to human will.

Comments and Discussions

Questionneed the same project in C# Pin
coolerfantasy9-Oct-14 3:10
Membercoolerfantasy9-Oct-14 3:10 
QuestionNice post Pin
Tridip Bhattacharjee12-Dec-13 21:53
professionalTridip Bhattacharjee12-Dec-13 21:53 
Questionhi Pin
Member 999349622-Apr-13 17:00
MemberMember 999349622-Apr-13 17:00 
GeneralMy vote of 5 Pin
luvsqin20-Mar-13 20:04
Memberluvsqin20-Mar-13 20:04 
GeneralMy vote of 5 Pin
JOE Heart Under Blade25-Jun-12 20:06
MemberJOE Heart Under Blade25-Jun-12 20:06 
Questiondatagrid with edit form having ms access db Pin
shann171820-Jan-12 16:20
Membershann171820-Jan-12 16:20 
GeneralMy vote of 5 Pin
RaviRanjanKr28-Nov-11 8:42
professionalRaviRanjanKr28-Nov-11 8:42 
GeneralMy vote of 5 Pin
akd016-Oct-11 15:59
Memberakd016-Oct-11 15:59 
GeneralThe same example but in VB.NET 2008 ?? Pin
rkanabus12-Jun-11 7:35
Memberrkanabus12-Jun-11 7:35 
GeneralThanks Pin
YZK30-Mar-11 18:58
MemberYZK30-Mar-11 18:58 
GeneralPlease how delete record from Grid Pin
garik3883-May-10 4:25
Membergarik3883-May-10 4:25 
QuestionInserting a new record Pin
AndrewjBrink25-Feb-10 23:12
MemberAndrewjBrink25-Feb-10 23:12 
QuestionC# Example Pin
CoramSteve2-Mar-09 11:21
MemberCoramSteve2-Mar-09 11:21 
GeneralPlease abstain from religious announcements. PinPopular
DoubleService1-Mar-09 23:42
MemberDoubleService1-Mar-09 23:42 
Generalcombobox depending on another combobox Pin
raulhs26-Aug-08 14:26
Memberraulhs26-Aug-08 14:26 
QuestionHow to add gridview data into sql table using 2005 Pin
naresh150726-Jun-08 23:04
Membernaresh150726-Jun-08 23:04 
GeneralSave As Functionality Pin
Member 468859629-Apr-08 3:56
MemberMember 468859629-Apr-08 3:56 
QuestionDelete rows Pin
Member 468859625-Apr-08 3:56
MemberMember 468859625-Apr-08 3:56 
General-1 sent to Edit Form Pin
joshua453-Apr-08 3:54
Memberjoshua453-Apr-08 3:54 
GeneralRe: -1 sent to Edit Form Pin
Robert R Freeman3-Apr-08 6:56
MemberRobert R Freeman3-Apr-08 6:56 
GeneralRe: -1 sent to Edit Form Pin
joshua453-Apr-08 6:57
Memberjoshua453-Apr-08 6:57 
Questioncan not update, cursor stack after value in combo changed Pin
Schering26-Nov-07 6:02
MemberSchering26-Nov-07 6:02 
AnswerRe: can not update, cursor stack after value in combo changed Pin
Robert R Freeman26-Nov-07 11:32
MemberRobert R Freeman26-Nov-07 11:32 
AnswerRe: can not update, cursor stack after value in combo changed Pin
Schering26-Nov-07 21:29
MemberSchering26-Nov-07 21:29 
GeneralRe: can not update, cursor stack after value in combo changed Pin
Robert R Freeman29-Nov-07 12:51
MemberRobert R Freeman29-Nov-07 12:51 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.