Listbox items depends on DropDown

All replies

• 

  

  1

  Sign in to vote

  Welcome to MSDN Forums.

  Sorry, It's a DataGridView not a ListBox which you've been attached it's image.

  You can handle the ComboBox.SelectedIndex changed like below:

  void CB_SelectedIndexChanged(..)
  {
  if(CB.SelectedIndex>=0)
    ((BindingSource)dataGridView1.DataSource).Filter = string.format("Department='{0}'",CB.SelectedValue);
  else
  ((BindingSource)dataGridView1.DataSource).RemoveFilter();
  }
  

  Regards,

  Yasser.

  • Edited by Yasser Zamani - Mr. Help Monday, October 17, 2011 6:25 PM Formatting...

  Monday, October 17, 2011 6:21 PM
• 

  

  0

  Sign in to vote

  i am sorry i put the image of my database.here is the image of the UI

  here is my asp.net code.

  <asp:Label ID="Label19" runat="server" Visible="False"  ></asp:Label>User Profiles</h2>

      <form id="form1">

            <asp:ScriptManager ID="ScriptManager1" runat="server">

                              </asp:ScriptManager>

   

      <div class="proalign">

       <br />

   

        <div class="tang">

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

              DataSourceID="SqlDataSource2" DataTextField="Department"  AutoPostBack="true"

              DataValueField="Department">

          </asp:DropDownList>

          <asp:SqlDataSource ID="SqlDataSource2" runat="server" 

              ConnectionString="<%$ ConnectionStrings:Event %>" 

              SelectCommand="SELECT DISTINCT [Department] FROM [UserProfile]">

          </asp:SqlDataSource> <br />

             <asp:ListBox ID="txtUserName" runat="server" 

              DataSourceID="SqlDataSource3" DataTextField="UserName"  AutoPostBack="true"

                                  DataValueField="UserName" Height="388px" Width="168px"></asp:ListBox>

   

                              <asp:SqlDataSource ID="SqlDataSource3" runat="server" 

                                  ConnectionString="<%$ ConnectionStrings:Event %>" 

   

                                  SelectCommand="SELECT [UserName] FROM [vw_aspnet_Users] ORDER BY [UserName]"></asp:SqlDataSource>                         

       <br />    

   

          </div>

   

   

  Monday, October 17, 2011 6:45 PM
• 

  

  0

  Sign in to vote

  also Could you plz Provide me any sample template or anything link are using a such kind of pattern in a combo Box or anything.

  Monday, October 17, 2011 6:46 PM
• 

  

  0

  Sign in to vote

  Hi Akshat,

  According to your description, I find your topic is related to ASP.NET.You may post the thread in ASP.NET Forum. There are more experts in that forum so that you may get more useful help there.

  Thank you for your understanding.

  ---

  Bob Wu [MSFT]
  MSDN Community Support | Feedback to us
  Get or Request Code Sample from Microsoft
  Please remember to mark the replies as answers if they help and unmark them if they provide no help.
  
  

  • Proposed as answer by Yasser Zamani - Mr. Help Tuesday, October 18, 2011 11:59 AM
  • Marked as answer by Ed Price - MSFTMicrosoft employee Friday, October 28, 2011 7:20 AM

  Tuesday, October 18, 2011 10:11 AM