DropDownLists in Visual WebParts when created in Visual Studio 2010

Toutes les réponses

• jeudi 14 juin 2012 15:00

   

   
  

  0

  Hi,

  You need to populate the dependent DropDownlist on the SelectedIndexChanged event of the parent DropDownlist.

  The code should be something like this:

  protected void Page_Load(object sender, EventArgs e)
  {
      DropDownList ddlParent = new DropDownList();
      DropDownList ddlChild = new DropDownList();
              
      // method to bind data to the dropdownlist
      DataBindParent();
  
      ddlParent.SelectedIndexChanged += new EventHandler(ddlParent_SelectedIndexChanged);
      ddlParent.AutoPostBack = true;
  
  }
  
  void ddlParent_SelectedIndexChanged(object sender, EventArgs e)
  {
      // method to bind data to the dropdownlist
      DataBindChildren(ddlParent.SelectedValue);
  }
  

  
  

  Cheers,

  Dan.

  ---

  You can find my blog here: http://developertrack.blogspot.com

  • Proposé comme réponse Bjoern H RappMicrosoft Community Contributor, Moderator lundi 18 juin 2012 14:00
  • Marqué comme réponse IAmANewcomer lundi 18 juin 2012 14:53
  •  
  • Réponse
  • Citation

   
• lundi 18 juin 2012 13:13

   

   
  

  0

  Hi,

  Lets say you want to bind a drop down list from a sql table using LINQ to SQL, the code would look something like this:

  I have a connection string in the web.config file called dbconnectionString,

  I have a table in SQL called ItemTable, that has two fields, Id (Primary key), and a text field called Name

  I have a drop down list called ddlItems.

  using (sqlDataContext context = new sqlDataContext(ConfigurationManager.ConnectionStrings["dbconnectionString"].ToString())
  {
  //get the items
  var itemList = context.ItemTable.ToList();
  
  //bind and set what users will see
  ddlItems.DataSource = itemList;
  ddlItems.DataValueField = "Id";
  ddlItems.DataTextField = "Name"
  ddlItems.DataBind();
  }

  Regards
  

  ---

  I find it distasteful to beg for 'Mark as Answer' and 'Mark as helpful'. It's supposed to be about helping people, not about getting the high score.

  • Réponse
  • Citation

   
• lundi 18 juin 2012 14:53

   

   
  

  0
  Thanks, I think this is what I need.  I'm testing it now.

  ---

  Sharon

  • Réponse
  • Citation

   
• lundi 18 juin 2012 14:54

   

   
  

  0
  Thanks for the reply however I this doesn't seem like what I need.

  ---

  Sharon

  • Réponse
  • Citation