Easily use ADO in DataGrids, DropDown Lists

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Configuration;

namespace BindList
{
	public class WebForm1 : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DropDownList DropDownList1;
		// Get the SQL Connection string from the web.config.
		public String strConnectSQL = (ConfigurationSettings.AppSettings["dsn_SQL"]);
	
		private void Page_Load(object sender, System.EventArgs e)
		{
		    // Build SQL String
			string SQLstring = "Select EmployeeID,  FirstName + ' ' + LastName as name FROM Employees";
			string TextField = "name";
			string ValueField = "EmployeeID";

			BindList(strConnectSQL, SQLstring, TextField , ValueField, DropDownList1 );
		
		}

		
		private void BindList(string strConnectSQL, string SQLstring, string TextField, string ValueField,
							  System.Web.UI.WebControls.DropDownList Dlist)
		{
			SqlConnection myConnection = new SqlConnection(strConnectSQL);
			SqlCommand myCommand = new SqlCommand( SQLstring, myConnection );
			myConnection.Open();
				
			Dlist.DataSource = myCommand.ExecuteReader();
			Dlist.DataTextField =  TextField;
			Dlist.DataValueField =  ValueField;
			Dlist.DataBind();

			myConnection.Close();
			
		}


		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{    
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion
	}
}