Click here to Skip to main content
11,928,352 members (48,390 online)
Click here to Skip to main content
Add your own
alternative version


49 bookmarked

Multiple selection using DropDownList in DataGrid

, 13 Aug 2004
Rate this:
Please Sign up or sign in to vote.
Multiple selection using DropDownList in DataGrid.


In this article, I will explain how to select multiple DropDownList values when the DropDownList is one of the columns of the DataGrid. I am using Northwind database in this example which is the default database in SQL Server.

Adding DropDownList to DataGrid:

Okay, adding DropDownList to DataGrid is straightforward. Read the following steps:

  1. Drag and drop DataGrid onto the webform.
  2. Right click on DataGrid -> select Property Builder.
  3. In Property Builder, select Columns.
  4. Add two bound columns and one template column. (Remember to add bound columns first and than the template column.) Uncheck Create columns automatically.
  5. Now, in the same window, click on the bound column appearing on the right window and set its header text to "Category ID" and DataField to "CategoryID". Click on the second bound column appearing in the right window and set header text to "Category Name" and DataField to "CategoryName".

Remember that header text is just the pure plain text which can be anything. DataField on the other hand is the name of the column in the database, so it must be the exact same name as of the column in database.

Now, it's time to add the DropDownList. Simple right click on DataGrid and select the option Edit template. In the item template, just drag and drop a DropDownList in item template.

Also, add one HTML Button control anywhere on the form.

Once you have done all these steps, your DataGrid should look something like this:

Sample screenshot

Populating DataGrid with Data:

Populating DataGrid is straight forward, just make the data source run a query and bind the source to the DataGrid.

private void Page_Load(object sender, System.EventArgs e)

public void BindData() 
  SqlDataAdapter ad = new SqlDataAdapter("SELECT * FROM Categories",myConnection);
  DataSet ds = new DataSet();
  myDataGrid.DataSource = ds;

In the code above, I have used Ad-Hoc query, a query in string format. You should never execute your query like this, and always use stored procedures for security purposes.

Populating DropDownList from database:

You can always populate your DropDownList by using its Collections property, but to make things interesting, I am going to populate the DropDownList with the data coming from the database column.

public DataSet PopulateList()
  SqlDataAdapter ad = new 
    SqlDataAdapter("SELECT Description FROM Categories", myConnection);

  DataSet ds = new DataSet();
  return ds;

As you see in the above code, the method PopulateList is returning a DataSet. This DataSet is used by the DropDownList to populate itself. Let's see how DropDownList named "ddlList" uses this DataSet to populate itself.

In the aspx page HTML, find the line where DropDownList is declared, and add properties to it.

<asp:DropDownList id="ddlList" runat="server" 
    DataSource="<%# PopulateList %>" DataTextField="Description" 
    DataValueField="Description" >

After this, your DropDownList will be populated with the data coming from "Description" column of the NorthWind database.

Here is a picture of the complete WebForm:

Sample screenshot

Button Click Event Code:

Remember that we added a HTML Button control. In the Click event of the Button, write this code:

private void Button1_Click(object sender, System.EventArgs e)
  string name = null;
  foreach(DataGridItem dgi in myDataGrid.Items)
    DropDownList dl = (DropDownList)(dgi.Cells[2].Controls[1]);
    if(dl.SelectedValue != null)
      name+= dl.SelectedValue;
  Label2.Text = name;

Okay and that's it. After making your selection from the DropDownList, press button and it will bind your selection with a Label control on the WebForm.

In this code, we are using "DataGridItem" dgi whose purpose is to iterate through the DataGrid items. Next, we make a new DropDownList "dl" and place the value of the DropDownList which is in DataGrid cell [2] (cells start with 0) in it. We check using "if" condition that if the selected value is not null, we concatenate it in the string variable name and display name afterwards.

That's it! Happy coding Big Grin | :-D


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

Web Developer
United States United States
I am the founder of knowledge base website, HighOnCoding, GridViewGuy, and

HighOnCoding is a website which will get you high legally with useful information. There are tons of articles, videos and podcasts hosted on HighOnCoding.

My Blog:


Buy my iPhone app ABC Pop

You may also be interested in...

Comments and Discussions

Generalhelp Pin
piyush_hsp16-Mar-09 20:20
memberpiyush_hsp16-Mar-09 20:20 
GeneralThank you Pin
Fastfootskater5-Jan-08 5:24
memberFastfootskater5-Jan-08 5:24 
Generalits Really Good Article.. Pin
ViReNdrA KuMaR KoHli3-Jun-07 23:42
memberViReNdrA KuMaR KoHli3-Jun-07 23:42 
Generalthank you Pin
hassan salman20-Apr-07 9:59
memberhassan salman20-Apr-07 9:59 
Generaldropdown Pin
sureshgganesh16-Apr-07 3:36
membersureshgganesh16-Apr-07 3:36 
<asp:DropDownList id="ddlList" runat="server" 
    DataSource="<%# PopulateList %>" DataTextField="Description" 
    DataValueField="Description" >
when i am using this with an access as an database its showing error how can i solve this problem
Generalvalue from dropdown Pin
hassan salman6-Apr-07 11:47
memberhassan salman6-Apr-07 11:47 
Newsgood artical Pin
ykgautam14-Dec-05 0:35
memberykgautam14-Dec-05 0:35 
GeneralNeed help Pin
HamidTheProgrammer29-Aug-05 6:44
memberHamidTheProgrammer29-Aug-05 6:44 
GeneralThere is a small issue in this article Pin
shcolin2001@hotmail.com6-Jun-05 18:45
membershcolin2001@hotmail.com6-Jun-05 18:45 
GeneralThank You Pin
Johan-BioVolt18-Aug-05 22:26
memberJohan-BioVolt18-Aug-05 22:26 
GeneralRe: Thank You Pin
azamsharp20-Aug-05 7:37
memberazamsharp20-Aug-05 7:37 

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.

| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.151126.1 | Last Updated 14 Aug 2004
Article Copyright 2004 by azamsharp
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid