Binding DropDownList With Database in ASP.NET

Rohatash Kumar

2y1.6m25100Article

C#ASP.NETC# articlesDropDownList in asp.netBinding DropDownList With Database

25 Comments

Join the conversation! Your thoughts help the community grow.

Vishnu Kumar5y ago
Please show that how it is work in .net core....?
Goku Op5y ago
SOLVED!!!!!!!! There is NO OnSelectedIndexChanged event handler for Dropdown. That is why it fetches only id=1 data. What is this Handler?? Ans>>>When an item is changed in ASP.Net DropDownList, the following OnSelectedIndexChanged event handler is executed.Inside the event handler, the selected Text and Value of the DropDownList Selected Item is fetched and displayed using JavaScript Alert message box.
Vivek K. Chauhan6y ago
On button click the query is fetching id 1 even after selecting 2nd or 3rd option in dropdown. Not getting the reason?
indradeo kumar7y ago
Only one row display not multiple row
projects fun7y ago
GridView1.DataSource = dt; what does this command do??
- Rohan Rao6y ago
  It binds your Datatable values with your Gridview.
harshita chaudhary9y ago
How to do for multiple dropdown list????
Brajesh Singh9y ago
DropDownList1.DataTextField = "Name"; DropDownList1.DataValueField = "ID";
Thiruppathi R9y ago
Nice Article........
Fzii Rosal9y ago
Hy guys i need help anyone can helpme?
Shobhit Kaushik11y ago
thank u
Rama Gopala Krishna Badithaboina11y ago
I am requesting you to make it as i am not much aware about these codings
Rama Gopala Krishna Badithaboina11y ago
Sir i request you to make a two drop down boxes and make another box which would our result box when i select the data from the two dropdown lists i should get details in result box
Vandana Bochker11y ago
why we are using both command and adapter here and iam getting error near da.fill(dt) error is "An exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll but was not handled in user code"
nofact noface11y ago
tank you over and over and over again
Vinod Banala12y ago
Only first person data is displaying even i select other person name field....what to do
- Yosef Sindi11y ago
  add the code inside this if statement : protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { add the code here } }
pushpa cp12y ago
only the 1st person detail is displayed in gridview even if 2nd or 3rd or any other person is selected, kindly reply soon the solution so that any person selected oly his data is displayed........
- Yosef Sindi11y ago
  add the code inside this if statement : protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { add the code here } }
ravichandran perumal12y ago
reply as soon as possible
ravichandran perumal12y ago
string strConnection = "Data Source=.; uid=sa; pwd=wintellect;database=rohatash;"; Now bind the DropDownList with the database table. SqlConnection con = new SqlConnection(str); i want to know is (str)=strConnection;
Vikram Rathore14y ago
Hello you are binding dropdownlist1 twice,was this done with a purpose?
Anubhav Satle14y ago
hello sir, i want to know the deference between DropDownList1.DataTextField = "Name"; & DropDownList1.DataValueField = "ID"; sir why we use textfild and valuefild..
nitin karande14y ago
i am doing this example,but it shows complete table...not selected row in my practice.
- Rahul Kayat12y ago
  use the [select columnname1,columnname2 from table] query in button click event

Introduction

Today, I have provided an article showing you how to bind a DropDownList with a database and display the bound data in a GridView in ASP.NET. In this article, we create a table in an SQL Server database and bind that table with a DropDownList control. After that, we select an item in the DropDownList and match it with the database table for the records that match with the database. It will be displayed in the GridView control. To do that, we create a connection string object to connect the database with the application and read data from the database using the select command to display data in the DropDownList. All you have to do is implement and hook it up to your requirements or needs. First, start Visual Studio .NET and make a new ASP.NET website using Visual Studio 2010.

Creating Table in SQL Server Database

Now create a table named UserDetail with the columns id, name, country, and city. Set the identity property=true for id. The table looks as in the following.

sqlQuery

Now insert some values in this table. The table looks like this.

SQL Table

Now you have to create a website.

Go to Visual Studio 2010
New-> Select a website application
Click OK

Visual Studio WIndow

Now add a new page to the website.

Go to the Solution Explorer
Right-click on the Project name
Select add a new item
Add a new web page and give it a name
Click OK

Solution Explorer

Design the page and place the required control in it. Now drag and drop one DropDownList control, Button, and GridView control on the form. Let's take a look at a practical example.

Example

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
        <div>
            <asp:DropDownList ID="DropDownList1" runat="server"></asp:DropDownList>
            <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
            <br />
            <br />
            <asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click1" Style="height: 26px" />
            <br />
            <br />
            <asp:GridView ID="GridView1" runat="server" BackColor="White" BorderColor="#999999"
                BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Vertical">
                <AlternatingRowStyle BackColor="#DCDCDC" />
                <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
                <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
                <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
                <RowStyle BackColor="#EEEEEE" ForeColor="Black" />
                <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
                <SortedAscendingCellStyle BackColor="#F1F1F1" />
                <SortedAscendingHeaderStyle BackColor="#0000A9" />
                <SortedDescendingCellStyle BackColor="#CAC9C9" />
                <SortedDescendingHeaderStyle BackColor="#000065" />
            </asp:GridView>
        </div>
    </form>
</body>
</html>

Now add the following namespaces.

using System.Data.SqlClient;
using System.Data;

Now write the connection string to connect to the database

string strConnection = "Data Source=.; uid=sa; pwd=wintellect;database=rohatash;";

Now bind the DropDownList with the database table.

SqlConnection con = new SqlConnection(str);
string com = "Select * from UserDetail";
SqlDataAdapter adpt = new SqlDataAdapter(com, con);
DataTable dt = new DataTable();
adpt.Fill(dt);
DropDownList1.DataSource = dt;
DropDownList1.DataBind();
DropDownList1.DataTextField = "Name";
DropDownList1.DataValueField = "ID";
DropDownList1.DataBind();

Now double-click on the Button control and add the following code.

SqlConnection con = new SqlConnection(str);  
SqlCommand cmd = new SqlCommand("select * from UserDetail where id = '" + DropDownList1.SelectedValue + "'", con);  
SqlDataAdapter Adpt = new SqlDataAdapter(cmd);  
DataTable dt = new DataTable();  
Adpt.Fill(dt);  
GridView1.DataSource = dt;  
GridView1.DataBind();  
Label1.Text = "record found";

In the code-behind, write the following code.

To display data in The GridViw, use a DataAdapter object to retrieve the data from the database and place that data into a table.

using System;    
using System.Collections.Generic;    
using System.Linq;    
using System.Web;    
using System.Web.UI;    
using System.Web.UI.WebControls;    
using System.Data.SqlClient;    
using System.Data;    
     
public partial class Default2 : System.Web.UI.Page    
{    
    string str = "Data Source=.;uid=sa;pwd=wintellect;database=rohatash";    
    protected void Page_Load(object sender, EventArgs e)    
    {    
        SqlConnection con = new SqlConnection(str);    
        string com = "Select * from UserDetail";    
        SqlDataAdapter adpt = new SqlDataAdapter(com, con);    
        DataTable dt = new DataTable();    
        adpt.Fill(dt);    
        DropDownList1.DataSource = dt;    
        DropDownList1.DataBind();    
        DropDownList1.DataTextField = "Name";    
        DropDownList1.DataValueField = "ID";    
        DropDownList1.DataBind();    
    }    
    protected void Button1_Click1(object sender, EventArgs e)    
    {    
        SqlConnection con = new SqlConnection(str);    
        SqlCommand cmd = new SqlCommand("select * from UserDetail where id = '" + DropDownList1.SelectedValue + "'", con);    
        SqlDataAdapter Adpt = new SqlDataAdapter(cmd);    
        DataTable dt = new DataTable();    
        Adpt.Fill(dt);    
        GridView1.DataSource = dt;    
        GridView1.DataBind();    
        Label1.Text = "record found";    
    }    
}

Now run the application select the name from the DropDownList control, and click on the Button.

Dropdown List

Now click on the Button.

Dropdown Output