how to bind data from database using ado.net with dropdownlist using asp.net3.5

aspx page:

<asp:Panel ID="pnl" runat="server" Visible="false">
<asp:DropDownList ID="ddlSecond" runat="server">
<asp:ListItem Text="AAA" Value="1">asp:ListItem>
<asp:ListItem Text="BBB" Value="2">asp:ListItem>
asp:DropDownList>
asp:Panel>
<asp:DropDownList ID="ddlName" runat="server" AutoPostBack="true" OnSelectedIndexChanged="ddlName_SelectedIndexChanged">
asp:DropDownList>

aspx.cs
Page_Load event

SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings[0].ConnectionString;
SqlCommand cmdallltransactions = new SqlCommand("SELECT ID, Name FROM Employee", con);
con.Open();
SqlDataAdapter sqlAdapter = new SqlDataAdapter(cmdallltransactions);
DataTable dtRecord = new DataTable();
sqlAdapter.Fill(dtRecord);
con.Close();
ddlName.DataSource = dtRecord;
ddlName.DataTextField = "Name";
ddlName.DataValueField = "ID";
ddlName.DataBind();

protected void ddlName_SelectedIndexChanged(object sender, EventArgs e)
{
pnl.Visible = true;
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Marimuthu Arigovindasamy16y ago
Accepted answer
aspx page:

<asp:Panel ID="pnl" runat="server" Visible="false">
<asp:DropDownList ID="ddlSecond" runat="server">
<asp:ListItem Text="AAA" Value="1">asp:ListItem>
<asp:ListItem Text="BBB" Value="2">asp:ListItem>
asp:DropDownList>
asp:Panel>
<asp:DropDownList ID="ddlName" runat="server" AutoPostBack="true" OnSelectedIndexChanged="ddlName_SelectedIndexChanged">
asp:DropDownList>

aspx.cs
Page_Load event

SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings[0].ConnectionString;
SqlCommand cmdallltransactions = new SqlCommand("SELECT ID, Name FROM Employee", con);
con.Open();
SqlDataAdapter sqlAdapter = new SqlDataAdapter(cmdallltransactions);
DataTable dtRecord = new DataTable();
sqlAdapter.Fill(dtRecord);
con.Close();
ddlName.DataSource = dtRecord;
ddlName.DataTextField = "Name";
ddlName.DataValueField = "ID";
ddlName.DataBind();

protected void ddlName_SelectedIndexChanged(object sender, EventArgs e)
{
pnl.Visible = true;
}
shweta gupta16y ago
Dear Muthu,
Thanks for ur immediate reply. I know this code but if I use asp.net 3.5 ajax with drop down list.Will this code work.
Thanks & Regards,
Shweta