C# ASP.NET DropDownList Bind To Table Source Code Example
Get 5 Hours of FREE PREMIUM Videos:
LearnVisualStudio.NET Free Preview
“ I am a lifetime member of LearnVisualStudio.net and a Premium Plus member of dotNetVideos.net.
LearnVisualStudio.net is awesome because it grows in value each year as more videos are added.
dotNetVideos.net is also great because it focuses a lot on MS Certifications and practical interview questions.
”
- Wade Harvey (IdealProgrammer.com)
LearnVisualStudio Premium Videos
 |  |  |  |  |
 |  |  |  |  |
 |  |  |  |  |
 |  |  |  |  |
 |  |  |  |  |
 |
dotNetVideos Premium Video Catalog
 |  |  |  |  |
 |  |  |  |  |
 |  |  |  |  |
 |  |  |  |  |
 |  |  |  | |
Premium (Not Free) Video Tutorials
Free Video Tutorials & Free Tools
C# ASP.NET DropDownList Bind To Table Source Code Example
Purpose: – Illustrates using DropDownList and bind to data table for C# ASP.NET.
Prerequistes:
- Install C# (Express or Standard Edition)
- Install SQL Server Express
- Download Northwind Database
- Attach Northwind Database to Databases in Sql Express
Notes:
- You can build your own library of syntax examples by using same web site over and over and just adding new web forms.
Instructions:
- Use Visual Web Developer 2008
- Create new web site;
- Click File/New Web Site
- Select ASP.NET Website Template
- Select C-Sharp for Language
- name of website could be CSharp_ASPNET_Syntax.
- Add New folder named "Standard_Controls"
- Right-click project name in solution explorer;
- add new folder;
- name of folder could be: Standard_Controls
- Add Web Form Named DropDownListBindToTable to Standard_Controls folder
- Right-click Standard_Controls folder;
- add new item;
- Select Web Form
- Check place code behind in separate file
- Web Form name could be DropDownListBindToTable
- Click on copy code in code below to copy code into web form DropDownListBindToTable.aspx
- Click on copy code in second set of code below to copy code into code-behind DropDownListBindToTable.aspx.cs
- Click green arrow to start with debugging
Step 1: Click on Copy Code to Cut-n-paste code into DropDownListBindToTable.aspx
| XML | | copy code | | ? |
< %@ Page Language="C#" AutoEventWireup="true" CodeFile="DropDownListBindToTable.aspx.cs" Inherits="Standard_DropDownListBindToTable" %> |
< !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> |
</div> |
</form> |
</body> |
</html> |
Step 2: Click on Copy Code to Cut-n-paste code into DropDownListBindToTable.aspx.cs
| C# | | copy code | | ? |
using System; |
using System.Data; |
using System.Data.SqlClient; |
using System.Collections; |
partial class Standard_DropDownListBindToTable : System.Web.UI.Page |
{ |
protected void // ERROR: Handles clauses are not supported in C# |
Page_Load(object sender, System.EventArgs e) |
{ |
SqlConnection con = new SqlConnection("Server=(local)\\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=SSPI"); |
SqlCommand cmd = new SqlCommand(); |
cmd.CommandText = "SELECT EmployeeID, FirstName + ' ' + LastName as FullName FROM Employees"; |
cmd.Connection = con; |
DataTable Table1; |
Table1 = new DataTable("Employees"); |
//creating a table named Employees |
DataRow Row1; |
//declaring row for the table |
DataColumn EmployeeID = new DataColumn("EmployeeID"); |
//declaring a column named EmployeeID |
EmployeeID.DataType = System.Type.GetType("System.Int32"); |
//setting the datatype for the column |
Table1.Columns.Add(EmployeeID); |
//adding the column to table |
DataColumn FullName = new DataColumn("FullName"); |
FullName.DataType = System.Type.GetType("System.String"); |
Table1.Columns.Add(FullName); |
try { |
con.Open(); |
SqlDataReader reader = cmd.ExecuteReader(); |
//(CommandBehavior.SingleRow) |
while (reader.Read()) { |
Row1 = Table1.NewRow(); |
//declaring a new row |
Row1["EmployeeID"] = reader.GetInt32(0); |
//filling the row with values. Item property is used to set the field value. |
Row1["FullName"] = reader.GetString(1); |
//filling the row with values. adding FullName |
Table1.Rows.Add(Row1); |
} |
reader.Close(); |
} |
finally { |
con.Close(); |
} |
DropDownList1.DataSource = Table1; |
this.DropDownList1.DataTextField = "FullName"; |
this.DropDownList1.DataValueField = "EmployeeID"; |
DropDownList1.DataBind(); |
} |
} |
Related posts:
- VB.NET ASP.NET DropDownList Bind To Table Source Code Example VB.NET ASP.NET DropDownList Bind To Table Source Code Example...
- C#: Sql Stored Procedure Source Code Example C# Sql Stored Procedure source code example with SqlDataReader...
- C# Select Statement Source Code Example Source Code example shows how to use Sql Select in...
- SqlDataReader Example – C# – SqlDataReader Example C# Source code example shows how to use SqlDataReader to...
- VB.NET Sql Command Update Statement Source Code Example VB.NET Source Code Example shows how to use Sql Command...
Related posts brought to you by Yet Another Related Posts Plugin.
Thank so much!