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?
how can i achieve this?
how to populate a dropdown list box based on selected value in another.
dropdown list box? Say, for example, the first dropdown is a list of car manufactures. When a user selected a manufacture from that dropdown list, the second dropdown would list would automatically gets populated with all the car models for that manufacture.
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?
Here is my code
[Code]....
How to populate dropdownlist in a gridview by selecting another dropdown in same gridview
i tried the code in driiopdownlist selectedchanged
dropdownlist d=(dropdownlist)gridview.findcontrol("dropdownlist1") but it gives null
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'm having trouble figuring out how to display a gridview based on the selection of a drop down list. I manually entered the drop down list items, but in the configure/choose data source I don't understand how you make a relationship between each list item and the corresponding database table you want to show.
View 7 RepliesI have seen article in code snippet but i have never used web services so that is complicated .
View 1 Repliesi 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
View 6 Repliesi want to see the sales in the grid view based on the month selected from drop down list. Ex: when I select June 2010 from the ddl box, the sales for that month are correctly displayed in the grid view. I go to page 4 to look at some sales there and then switch the month to August 2010 to see sales for that month instead. Here is the problem. When I switch the month, it show August 2010 sales, but stays in page 4 instead of going back/resetting back to page 1 of August 2010 sales.
How do I reset the grid view page back to the first page of August 2010 sales?
I am fairly new to ASP. If I have missed an imp. detail in this post, let me know and I will get that info. out there.
I am a complete newcomer to ASP.NET. However in the few weeks I have been playing with it I have got pretty far and have mastered things like stored procedures, gridviews, formviews and templates.I have a dropdown box which is populated from SQLDataSource1
I have a second dropdown box which is populated from SQLDataSource2, but i need the query feeding this to be dependent on what was selected in the first dropdown box. I assumed it would simply be a case of modifying the select statement on SQLDataSource2 using the SelectedIndexChanged event on the first DropDownList to update the second SQL source, but I cannot work out for the life of me how to do it. Pretty much all of the code I have is ASP.
can i do this purely in ASP rather than using VB behind the scenes or do I need to use VB? I am pretty comfortable with vb.net but one of the other issues I have is referencing an ASP object from VB... so for instance if I had a text box in ASP, how can I read or change the properties of this object from VB?
FYI I am using Visual Studio 2010 and SQL/Server
I have a dozen tables, and two dropdown lists.The first drop down list shows the table names. The second dropdown list needs to be poulated with the data from the specific table selected in the first dropdown list.I wrote a stored procedure that will query the selected table name choosen in the the first dropdown list. My results though are only showing this...
[Code]....
I have dropdown1 that has some items in it.I also have dropdown2 that gets populated from a database based on whatever is selected from dropdown1.Dropdown2 has its first item as "Make Selection" and then appends the data from the db based on what was selected in dropdown1.
Now when I select an item from dropdown1 it puts the correct data in dropdown2 but as soon as I select another item from dropdown1 it appends those values into dropdown2. How can I remove the values from dropdown2 after a new item is selected from dropdown1?
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.
[Code]....
I normally have a function to populate my dropdown list with the database values.
How can I populate a dropdown list so the values are stored in the web config?
The only problem is that the list would need to store two values, the text value of the combo, and the data value.
I have a category and a subcategory column in a Jqgrid. I have enabled inline editing, both category and subcategory are dropdownlists columns (edittype:'select'). I need to filter the subcategory list based on the selected category. I wonder how can I acheive this functionlity? I tried the below event but its not working for me
afterEditCell: function(rowid, celname, value, iRow, iCol) {
//to do here
}
the above event doesn't get fired. my all column are editable
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.
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?
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 ?
View 1 RepliesI wanted to populate the dropdown list when selecting the edit button based on the officeid from the gridview.
My code:
<
asp:GridView
ID="gridassignserv"
runat="server"
[Code]....
I have two dropdown linked with sqldatasources.When I select item in ddl1 then on the basis of selection ddl2 is being loaded.Is there any possiblity that if I select ddl2 then ddl1 will also load on the basis of selection?
View 3 RepliesI'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.
View 4 RepliesI am new to MVC, I have a form in which selection of one dropdown should reload another dropdown. On selection of the dropdown, I use a jquery post to get the data and my viewstate is reloaded with new data, but I am not sure how to set the newly loaded viewdata to load the dropdown again.
View 5 RepliesI 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.
View 1 RepliesI have drop down selection box as follow...
1 - Car
2 - Plane
3 - Train.
Now, based on user selection say, 'Car', I want to display Help text associated with selection on page. Help text description - 1000 characters. Now, how do I fetch Help Text Description from? should I store in Session scope or Application Scope or fetch from Database based on drop down selection.