C# ASP.NET DropDownList Bind To Table Source Code Example

Pluralsight courses
LinkedIn Premium uses PayScale to estimate job salaries

Premium (Not Free) Video Tutorials

Free Video Tutorials & Free Tools

C# ASP.NET DropDownList Bind To Table Source Code Example

Purpose: – Illustrates using and bind to for C# ASP.NET.
Prerequistes:

  1. Install C# (Express or Standard Edition)
  2. Install SQL Server Express
  3. Download Northwind Database
  4. 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:

  1. Use Visual Web Developer 2008
  2. 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.
  3. Add New folder named "Standard_Controls"
    • Right-click project name in solution explorer;
    • add new folder;
    • name of folder could be: Standard_Controls
  4. 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
  5. Click on copy code in code below to copy code into web form DropDownListBindToTable.aspx
  6. Click on copy code in second set of code below to copy code into code-behind DropDownListBindToTable.aspx.cs
  7. 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:

  1. VB.NET ASP.NET DropDownList Bind To Table Source Code Example VB.NET ASP.NET DropDownList Bind To Table Source Code Example...
  2. C#: Sql Stored Procedure Source Code Example C# Sql Stored Procedure source code example with SqlDataReader...
  3. C# Select Statement Source Code Example Source Code example shows how to use Sql Select in...
  4. SqlDataReader Example – C# – SqlDataReader Example C# Source code example shows how to use SqlDataReader to...
  5. 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.

Comments

One Response to “C# ASP.NET DropDownList Bind To Table Source Code Example”
  1. mrdamniit says:

    Thank so much!

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!

Powered by WP Hashcash

This blog uses the cross-linker plugin developed by Web-Developers.Net