ADO.NET 3.5 Cookbook, 2nd Edition

8.1. Loading Data into and Binding a Field to a Web Forms Control

Problem

You need to load a data value into a server-side control.

Solution

Load the value directly with an assignment or use a DataBinder object.

Follow these steps:

1. Create a C# ASP.NET web application named LoadDataWebFormControl.

2. Add the following controls to the Default.aspx design surface:

   • TextBox named departmentIDTextBox

   • TextBox named departmentNameTextBox1

   • TextBox named departmentNameTextBox2

   • Button named getNameButton with Text property = Get Name

   Add HTML text in front of each text box describing the text boxes.

   The completed layout of the Web Form page Default.aspx is shown in Figure 8-1.

   

   Figure 8-1. Layout for Default.aspx in LoadDataWebFormControl solution

   The code in Default.aspx in the project LoadDataWebFormControl is shown in Example 8-1.

Example 8-1. File: Default.aspx for LoadDataWebFormControl solution

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="LoadDataWebFormControl._Default" %> <!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>Untitled Page</title> </head> <body> <form id="form1" runat="server"> <div> DepartmentID: <asp:TextBox ID="departmentIDTextBox" runat="server"></asp:TextBox> <br /> DepartmentName 1: <asp:TextBox ID="departmentNameTextBox1" ...