dropdownlist

Vivek Joy

Can Anyone help me...

1.I need to display the companyname from the database to the dropdown list.How can i do it?

2.Next is by selecting an item in the dropdownlist that item details should be displayed there in different textboxex,etc.

6 Replies

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

Hi,

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        TextBox1.Text = DropDownList1.SelectedItem.Value;
    }

Vivek Joy11y ago
thanks but i need to populate the values to textboxes according to the selection of item in dropdownlist
0
Vivek Joy11y ago
thanks but i need to populate the values to textboxes according to the selection of item in dropdownlist
0
Rajeesh Menoth11y ago
Hi,

code :

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindContrydropdown();
}
}
///
/// Bind COuntrydropdown
///
protected void BindContrydropdown()
{
//conenction path for database
using (SqlConnection con = new SqlConnection("Data Source=SureshDasari;Integrated Security=true;Initial Catalog=MySampleDB"))
{
con.Open();
SqlCommand cmd = new SqlCommand("Select UserId,UserName FROM UserInformation", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
ddlCountry.DataSource = ds;
ddlCountry.DataTextField = "UserName";
ddlCountry.DataValueField = "UserId";
ddlCountry.DataBind();
ddlCountry.Items.Insert(0, new ListItem("--Select--", "0"));
con.Close();
}
}

initialize dropdown selected value to textbox..

Ref : click here
+1
Rojalin Sahoo11y ago
1. So bind your dropdownlist with the datatable fetching company name from database BindDropdownlist

2. Then fire OnSelectedIndexChanged event of the dropdownlist.
+1