Click here to Skip to main content
Click here to Skip to main content

How to add selection controls to your DataGrid

, 11 Feb 2005
Rate this:
Please Sign up or sign in to vote.
This article describes how to add controls to a DataGrid. This will add controls at runtime. I hope this will be helpful for developers who are using DataGrids for data entry forms.

Sample

Introduction

This will help you to understand how to add any type of control (ComboBox, DateTimePicker, CheckBox, RadioButton, etc.) to your DataGrid control. If you want, you can load data into some columns of the DataGrid from a database/XML file and add the controls to a separate column as a selection. By doing this, it will help you to reduce coding needed for validation since you are limiting data entry to a selection.

In the same time, you can capture events of those added controls and do whatever you want when firing those events.

Background

When I was asked to develop a configuration screen for an application, I faced so many difficulties while searching for 'how to add controls to the DataGrid'. I couldn't find any good complete article on this. After doing a long research on this, I was able to make a good methodology to do that. Without keeping it as a secret, I would like to share it with you all.

Using the code

The attached application contains all the code needed to run. Since some of the columns of the DataGrid are loading through a MS SQL Server ® database, you need to change the server settings accordingly (server name, user ID and password).

And run the attached script on the Query Analyzer to create the database on the SQL Server.

//Capturing clicked cell into a locally defined variable.
Private hitTestGrid As DataGrid.HitTestInfo

All the controls which you wish to have on the DataGrid should be declared along "WithEvents" keyword, only if you are interested with their events to be captured.

Private WithEvents datagridtextBox As DataGridTextBoxColumn
Private WithEvents dataTable As dataTable
Private WithEvents comboControl As System.Windows.Forms.ComboBox
Private WithEvents dtp As New DateTimePicker
Private WithEvents chk As New CheckBox

Now we will see about capturing events and getting values to the DataGrid. (This code fragment shows you how to get value form a DateTimePicker and place it on the selected cell.)

Private Sub dtp_ValueChanged(ByVal sender As Object, _
        ByVal e As System.EventArgs) Handles dtp.ValueChanged
    dgMember(hitTestGrid.Row, hitTestGrid.Column) = dtp.Value.ToString
End Sub

Looping through available columns and determining on which cell you have clicked:

For i = 0 To dataTable.Rows.Count - 1
    sType = dgMember(i, 0).ToString()
    If hitTestGrid.Row = i Then
        Select Case hitTestGrid.Row
            Case 1
                datagridtextBox.TextBox.Controls.Add(dtp)
                dtp.BringToFront()
            Case 0
                datagridtextBox.TextBox.Controls.Add(comboControl)
                comboControl.BringToFront()
            Case 2
                datagridtextBox.TextBox.Controls.Add(chk)
                chk.BringToFront()
            Case 3
                datagridtextBox.TextBox.Controls.Add(rb)
                rb.BringToFront()
        End Select
    End If
    datagridtextBox.TextBox.BackColor = Color.White
Next i

Please look into the code, by that you will get a better picture about the concept.

Points of Interest

I learnt a lot about new features on .NET while writing this code. And I hope to do my VB.NET certification next week.

History

Initial version.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

About the Author

Buddhi Dananjaya
Team Leader
Sri Lanka Sri Lanka
No Biography provided

Comments and Discussions

 
GeneralMy vote of 3 Pinmembertigercont23-Jan-12 22:45 
QuestionSelection control in Datagrid Pinmemberinfotools13-Nov-07 17:45 
AnswerRe: Selection control in Datagrid Pinmemberinfotools15-Nov-07 23:15 
QuestionDisk full error in vb 6.0 and VB.NET 2003 Pinmemberketanani31-Aug-07 1:56 
Questionhow to handle key left/right/up/down? Pinmembersonixs31-Jul-07 3:44 
GeneralVery good job Pinmemberalfigueroa25-Jun-07 7:02 
GeneralRe: Very good job PinmemberBuddhi Dananjaya25-Jun-07 17:12 
QuestionHow to write Keyperss event for UP/ DOWN Keys in DatagridtextColumn Pinmemberketanani27-Apr-07 3:09 
Generalur work is great PinmemberManeeshOhm3-Jan-07 0:36 
Generalgreat work PinmemberManeeshOhm3-Jan-07 0:34 
Generalapp fails on reorder of the columns Pinmemberra00l2-Sep-06 5:27 
Generalcan't see my picbox control unless I click in a cell PinmemberLes Stockton10-Aug-06 4:26 
Questionhow to add combobox in datagrid.i use following.but i can't work.any idea about this send it me Pinmembervidyashankar17-Jul-06 23:31 
AnswerRe: how to add combobox in datagrid.i use following.but i can't work.any idea about this send it me Pinmemberinfotools15-Nov-07 23:17 
QuestionHow to handle typed text combo. PinmemberRDoes18-Mar-06 5:42 
GeneralDateTimePicker & Access PinmemberVitoto16-Jan-06 12:19 
GeneralCopied version of Your Article PinmemberHemaRawat22-Dec-05 21:50 
GeneralNeed More Documentation PinmemberHemaRawat22-Dec-05 21:42 
QuestionHow to use this control to in usercontrol PinmemberHarSha9919-Oct-05 3:41 
QuestionHow to add selection countrols to your datagrid? But it has the problem? Pinmembermyphuong24431-Aug-05 23:49 
AnswerRe: How to add selection countrols to your datagrid? But it has the problem? Pinmembermaster_pine11-Jun-06 18:35 
QuestionCombo padding? PinmemberAranda L Morrison21-Jun-05 18:25 
AnswerRe: Combo padding? Pinmembershuxuzhen3-Feb-06 20:39 

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

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

| Advertise | Privacy | Mobile
Web04 | 2.8.140721.1 | Last Updated 11 Feb 2005
Article Copyright 2005 by Buddhi Dananjaya
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid