Home
About
Contact
Categories
Classic ASP (26 - Sub-Categories)
JavaScript (4 - Sub-Categories)
Databases (21 - Sub-Categories)
ASP.NET (21 - Sub-Categories)
Delphi (5 - Sub-Categories)
Windows Server Core (3 - Sub-Categories)
VMWare (1 - Sub-Category)
Code Editing Tools (2 - Sub-Categories)
Linux (1 - Sub-Category)
Bug Reports
(Fugs Fixed
New CFFCS Coding Source is still in Beta
Please report any errors to the [Contact] page. Thank you.
Classic ASP (26)
JavaScript (4)
Databases (21)
ASP.NET (21)
Delphi (5)
Windows Server Core (3)
VMWare (1)
Code Editing Tools (2)
Linux (1)
Resources
[View The Source Code For This Project]
Format SQL Script
ASP.NET
C#
ASP.NET (C# Version) Database Driven Select Menu (Dropdown Menu)
HTML
ASP.NET (C# Version) SQL Server Database Driven Dropdown Menu
This demonstration loads all values into a Select Menu from a database table.
SQL
XDropDown
-- Create a new database called [Virtual-Class-01] in SQL Server. -- Right-click and choose [New Query] -- Copy and paste the code below and hit [Execute] USE [Virtual-Class-01] GO /****** Object: Table [dbo].[DropDown] Script Date: 7/31/2022 5:57:27 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DropDown]( [ddID] [int] IDENTITY(1,1) NOT NULL, [ddName] [nvarchar](50) NOT NULL, CONSTRAINT [PK_DropDown] PRIMARY KEY CLUSTERED ( [ddID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO SET IDENTITY_INSERT [dbo].[DropDown] ON GO INSERT [dbo].[DropDown] ([ddID], [ddName]) VALUES (1, N'asp classic') GO INSERT [dbo].[DropDown] ([ddID], [ddName]) VALUES (2, N'visual basic') GO INSERT [dbo].[DropDown] ([ddID], [ddName]) VALUES (3, N'jquery') GO INSERT [dbo].[DropDown] ([ddID], [ddName]) VALUES (4, N'javascript') GO INSERT [dbo].[DropDown] ([ddID], [ddName]) VALUES (5, N'asp.net') GO INSERT [dbo].[DropDown] ([ddID], [ddName]) VALUES (6, N'vb.net') GO INSERT [dbo].[DropDown] ([ddID], [ddName]) VALUES (7, N'C#') GO INSERT [dbo].[DropDown] ([ddID], [ddName]) VALUES (8, N'web.config') GO INSERT [dbo].[DropDown] ([ddID], [ddName]) VALUES (9, N'database.config') GO INSERT [dbo].[DropDown] ([ddID], [ddName]) VALUES (10, N'runtime') GO SET IDENTITY_INSERT [dbo].[DropDown] OFF GO
ASP.NET
web.config
database.config
Load.aspx.cs
using System.Data; using System.Configuration; using System.Data.SqlClient; protected void Page_Load(object sender, EventArgs e)
if (!this.IsPostBack)
string constr = ConfigurationManager.ConnectionStrings["Virtual-Learning"].ConnectionString; using (SqlConnection con = new SqlConnection(constr))
using (SqlCommand cmd = new SqlCommand("SELECT ddId, ddName FROM Dropdown"))
cmd.CommandType = CommandType.Text; cmd.Connection = con; con.Open(); DropDownList1.DataSource = cmd.ExecuteReader(); DropDownList1.DataTextField = "ddName"; DropDownList1.DataValueField = "ddId"; DropDownList1.DataBind(); con.Close();
DropDownList1.Items.Insert(0, new ListItem("--Select Programming Language--", "0"));
Preview
Tags
ASP.NET C# database-driven dropdown menu
C# database-driven dropdown menu
dropdown menu with SQL Server
Create a connection to our database
populate our select menu
close the RecordSet
close database connection in C#