ASP.NET

Bind Data in Dropdown List Control in ASP.NET using SQLDataSource

Introduction

In this blog, I explained how to bind data to Dropdown List control using SQLDataSource in web application in Asp.net

Dropdownlist Control

It’s enables users to select from a single-selection drop-down list. The drop-down list contains "n" number of items.

The DropDown List control also supports data binding, such as data to bind the control to a data source like object data source, xml data source and Sql data source, that contains the items to display in the control. This DropDown List control can be used to add data manually or even dynamically data binding from database.

DataBind Method

The method to bind the data source to the DropDown List control.

DataTextField, DataValueField Property

To specify which field in the data source to bind to the Text and Value properties of each list item in the control.

SelectedIndex Property

The SelectedIndex property to programmatically determine the index of the item selected by the user from the DropDown List control.

Code

  1. <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Dropdownlist.aspx.cs" Inherits="Dropdownlist" %>  
  2. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">  
  3. <html  
  4.     xmlns="http://www.w3.org/1999/xhtml" >  
  5.     <head id="Head1" runat="server">  
  6.         <title>Asp.Net Dropdownlist control</title>  
  7.     </head>  
  8.     <body>  
  9.         <form id="form1" runat="server">  
  10.             <div>  
  11.                 <table>  
  12.                     <tr>  
  13.                         <td style="height: 45px">  
  14.                             <asp:Label ID="Label1" runat="server" Style="left: -1px; position: relative; top: 0px"   
  15. Text="Name:" Width="46px"></asp:Label>  
  16.                         </td>  
  17.                         <td style="height: 45px">  
  18.                             <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource1"   
  19. DataTextField="EmpName" DataValueField="EmpName" Height="26px" Style="left: 3px;   
  20. position: relative; top: 0px" Width="125px">  
  21.                                 <asp:ListItem><< Select >>  
  22.                                 </asp:ListItem>  
  23.                             </asp:DropDownList>  
  24.                         </td>  
  25.                         <td style="height: 45px">  
  26.                             <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:masterConnectionString %>"   
  27. SelectCommand="SELECT [EmpName] FROM [tbl_employee_profile]">  
  28.                             </asp:SqlDataSource>  
  29.                         </td>  
  30.                     </tr>  
  31.                 </table>  
  32.                 <asp:DropDownList ID="DropDownList" runat="server"></asp:DropDownList>  
  33.             </div>  
  34.         </form>  
  35.     </body>  
  36. </html>
Ebook Download
View all
Learn
View all
Get Started

You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.

Become a sharper developer and jumpstart your career.

Basic

$0

$

. 00

monthly

For Basic members:

  • Standard Profile
  • Access learning courses
  • Access free e-books
  • 1x point
Premium

$20

$

. 00

monthly

For Premium members:

  • Earn 2x reward points
  • Premium profile with Verified check
  • Premium Avatar with status update
  • Learning courses
  • Unlimited Certifications and badges on profile
  • Unlimited Book downloads
  • Access to Premium content
  • Online Training
  • Unlimited PDF conversions and downloads
  • Professional Resume Writing
  • Interview Preparations Guide
  • 25 messages per month
  • 1 "Kodzu" avatar, basic
Elite

$45

$

. 00

monthly

For Elite members:

  • Bundle E-books
  • Access to all Learn Series
  • Unlimited Apply Jobs