DOTNET: How to Fill the Drop Down Values From DataBase

Thursday, August 2, 2012

Design the DataTable

Default.aspx

</head>

<body>

<div>

<asp:DropDownList ID="DropDownList1" runat="server">

</asp:DropDownList>

</div>

</form>

</body>

</html>

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Data.SqlClient;

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

{

protected void Page_Load(object sender, EventArgs e)

{

SqlConnection con = new SqlConnection("user id=sa;password=uday;database=uday;data source=localhost");

SqlCommand cmd = new SqlCommand("select *from customers", con);

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds);

DropDownList1.DataSource = ds;

DropDownList1.DataTextField = "customername";

DropDownList1.DataValueField = "customerid";

DropDownList1.DataBind();

DropDownList1.Items.Insert(0,new ListItem("--SelectItem--","0"));

}

DOTNET