Forms Data Controls :: Two Dropdown Lists That Populate Gridview?
Jul 22, 2010
I have 2 drop downlists 1 gets the User hits my sql database and pulls back all my users in the database. I have post back on. The second drop down brings back all the account numbers for the user that is selected in the first drop downlist I have that post back on also.
My gridview then uses those 2 dropdownlists to populate for that user and that account number selected.
Now for the problem.
User Albert is in the drop down when page is loaded because its sorts by name the first account number for albert is in the 2nd drop down and the gridview works on page load for albert and account number 1 i can select account number 2 and the gridview changes.
I then switch user to Bill and it populates the 2nd drop down with Bill's account numbers however my gridview at this point is still showing alberts account information. I have to take drop down 2 and select another account say account 2 then my gridview displays bill's account 2 information i can then switch back to account 1 for bill and see that account information.
What do I need to do so that my gridview will populate when the first dropdown is changed to match the 2 new values?
I am using a dataset control and I have 5 dropdown lists in which their content depends on what item is selected in each dropdown list.
I know I can populate the lists with 5 different queries taking the variables from each list but I am thinking there must be a better way.
Is there a way to populate each list with one query that takes the distinct items from each column returned without looping through the entire recordset?
I'm trying to create a page with multiple fields to be used as parameters for filtering a GridView. I'm using a combination of two asp:dropdown lists and two check boxes. When I select a value in one ddl, I want to clear the value in the other ddl. I was trying to use the event "onTextChanged" but that doesn't seem to fire off on the client side and I cannot seem to find any event for an asp:ddl or asp:checkbox or asp:radio button that fires off on the client side.
Are there events, like onClientClick for asp:button, that fire on the client side for these controls when a selected value is changed or when the user clicks on them? or do I need to use html controls instead?
I have a gridview where i have two fields. one is product and second is sub category.
I need to do 2 things.
1. I need to populate the two combos from the database. But depending what is selected in dropdown 1 this will determine what needs to be populated in drop down 2?
I have a gridview that had a field called "GenericNameHepDrug" within the row. It's not the key field. I have an insert button that opens a formview in insertmode. How can I get the selected value of generichepdrug into the formview that opens when the button is clicked? I am using VB.NET 2.0.
here is some code from the source:
[Code]....
Here is what I tried to do in the code nehind of the button3_click:
[Code]....
[Code]....
CLearly I am lost. I have been working with ASP.NET VB for 2 months. I'm in over my head with figuring this one out - I've been at it for days.
I have a number of dropdown lists which are populated from a database. They load depending on what the previous dropdown selection was so for example if the system was car based and I had chosen Ford then the next dropdown list would populate all cars made only by Ford. What I'm wanting to do is add a select all to one of the dropdown lists. Does anyone know how this would be done?
I have a dropdownlist and a gridview with a drop down list in every row. I have removed other cols in Grid for simplicity.
Whenever a new value in the dropdownlist is selected I would like to set all of the dropdownlists in the gridview to that same value via javascript. (Yea both the dropdownlist outside the gird and the ones inside the grid are populated by the same data source)
function onJDSelection() { var jd = document.getElementById('ctl00_MAIN_DropDownList3').Text; var grid = document.getElementById('ctl00_MAIN_GridView2'); for (var i = 1; i < grid.rows.length; i++) { grid.rows[i].cells[0].getElementsByTagName("*")[1].selectedText = jd; } }
[Code]...
When clicking on the dropdown I get an alert that says "test" and an alert that says "[Object object]" However nothing happens with the dropdowns in the grid and the alert(i) never fires.
Ive been strugglng with this one problem for a while now. I have an application as: SelectCommand="SELECT [CategoryID], [Name], [UserId] FROM [Categories] WHERE ([UserId] = @UserId) ORDER BY [Name]"> <SelectParameters> <asp:QueryStringParameter Name="CategoryID" QueryStringField="ID" /> </SelectParameters> [code]....
the dropdown list control will populate values from the database but when i live those 2, it won't populate any value from the database. When i remove only the <asp:QueryStringParameter Name="CategoryID" QueryStringField="ID" /> </SelectParameters> and live ([UserId] = @UserId), i get the error : Must declare the scalar variable "@UserId".
I want to dynamically populate data in Dropdown box in the Edititemtemplate of the Listview. The below code is showing error "Object reference not set to an instance of an object". The problem is in Findcontrol function. How to solve this.
Using a gridView to read some data from a SQL database. The user can select a record in the gridview. On the SelectedIndexChanged property I populate this to a couple of text boxes & drop down list; txtCountry,ddlProvince,ddlCity.
I have special characters in France ( accent marks) and when I populate it to the drop down list it fails giving out the error message "SelectedValue which is invalid because it does not exist in the list of items".
Example of items that I try to populate are as follows. ( separated by commas) ÃŽLE-DE-FRANCE , PROVENCE-ALPES-CÔTE D'AZUR , RHÔNE-ALPES, DRÔME,ISÈRE ........ When I looked in the drop down lists for Province and Cities I see those Provinces there in the item list. When I debug line by line the word ÃŽLE-DE-FRANCE comes out like ÎLE-DE-FRANCE which is not there in the drop down list. Got to know the ÃŽ is typed by pressing down ALT+206 and lloks like this is what is coming in at the start of the string above.
populating the dropdownlist with column name. I have a gridview that has 7 columns . I want to have a textbox search and dropdownfield where user can select column name and type a word in search box and click search so that text for that column name is being search and displayed in grid. how I can fetch just column names from DB and search ?
I'm currently working on a project and I want to make as much things as possible performing on client side - with as little loading as possible. The project consist of three "main" pages. On one page I use jQuery DataTable plugin which is working great. One page has tabs (using jQuery). I want to put datacontrol (repeater) on this site and when user selects one item in dropdown, data in repeater loads on client side, without performing the action on server.
I have grid view which databind from object datasource. my problem is i want to disply dynamic dropdown list on edit template based on the id which has in grid view. but still i can't figure out a way to do this.
i have a dropdown with month names if the user has data for the month tht is selected then gridview displays the rows with day nos as per the month but if the gridview has no data for the same the dropdown or gridview via some event should call a insert procedure to insert data into the table for tht month with daynos ad rebind the gridview witht the rows just created
i have two dropdown lists and i would like if i select lets say "1" the second list returns "A""B" but instead it returns "A" how to make the second list display A"B when i select "1" from the first list.
I don't want to link my dropdownlists with a database like most of tutorials and forums show. I just want to link 2 dropdownlists, for instance if one says "Food" I want to show only the food producs in the other DropDownList. All this items are not from a database, I just inserted them in the DropDownList control.
I have 3 dropdown lists. All 3 are using the same generic list for there items. I am using C# as the code behind. The code below shows the DTO list i am using and how I'm adding them to the drop downs...
in all browers this works but in IE the dropdown list items in my modal pop up extender vanish when I make a selection. I even have a ddl in ajax panel and the same thing happens. it seems like a bug.
I want to know how to make up dropdown lists with numbers in them and and the end of the page as you selected the numbers they add themselfs up and you see a total at bottom the page
drop down list one 50
drop down list two 55
drop down list three 35
TOTAL IS _____140 _______
(and the end of the page when you select one number in each dropdown list) it adds it up for you and shows your total on the same page
i have over 100 items all loaded in a dropdown list. They all are assigned a value between 1-10 which represent 10 categories. When certain buttons are clicked, i want the dropdown list to display only items with a value "1" or "2", etc.
