How to bind data to Dropdownlist

using System;

using System.Data;

using System.Configuration;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;



public partial class _Default : System.Web.UI.Page

{ 

protected void Page_Load(object sender, EventArgs e)

{ 

Populate1();

}



public void Populate1()

{ 

SqlCommand cmd = new SqlCommand("SELECT * FROM [tblOne]", new SqlConnection(ConfigurationManager.AppSettings["ConnString"]));

cmd.Connection.Open();



SqlDataReader ddlValues;

ddlValues = cmd.ExecuteReader();



DropDownList1.DataSource = ddlValues;

DropDownList1.DataValueField = "theName";

DropDownList1.DataTextField = "theName";

DropDownList1.DataBind();



cmd.Connection.Close();

cmd.Connection.Dispose();

}



} 

Thanks
Karthik
www.f5Debug.net

Thanks
Karthik
www.f5Debug.net

Best Regard's
Prabhakar

Dhivakar.M

Best Regard's
Prabhakar

Thanks
Karthik
www.f5Debug.net