JQGrid Inline Editing - Filter Subcategory Dropdown List Based On Another Category Dropdown
Jul 9, 2010
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
View 1 Replies
Similar Messages:
Jun 11, 2010
I'm having a problem with using a dropdown to filter the contents of another drop down. The basic idea is:
Dropdown 1 = CountryList (Column1)
Dropdown 2 = StateList (Column2)
I read the contents of a CSV file and populate the gridview. The user then visually verifies that the data is valid and proceeds to upload to the database. To do some testing, i have intentionally changed spellings of country names so they DO NOT match the countrylist which the grid view then flags with a different background indicating bad data. The user then edits the gridview. The Country and state columns then show a drop down control populated with the country list and filtered states list based on countryID.
Here's the ASP.NET ASPX Source for the section of code that is dealing with the gridview
[Code]....
Here's the section of VB Code behind that deals with handling the "RowEditing", specifically the binding of the dropdowns
[Code]....
The proglem is that these dropdowns are ment to easily fix minor errors in data. When i intentionally changed the spelling of "Canada" to Canadaa", this has no corresponding CountryID in the table and the ddlEdtStateID Dropdown's datasource filter does not work. I tried setting the datasource to nothing if a valid CountryID was not there and then i tried to use the SelectedIndexChanged event for the ddlEditCountryID to programmatically set the datasourceID for ddlEditStateID but when i try using CType(FindControl("ddlEdtStateID"), DropDownList) to set the DataSourceID, it does not find the control.
If the Country does not exist, then i just want the stateslist dropdown to say "select a country" but when a valid country is selected, it should display the filtered list for that countryID. Right now, if bad data is entered for the country, then the program crashes when it tries to populate the state drop down. I want it to just say, select a country when the countryID is not valid.
View 1 Replies
Oct 10, 2010
I am stuck at this point "Displaying a dropdown list of Categories with a --None -- Option. I want the gridview control to display 2 dropdown list one in read-only mode and the other in edit mode. When a record is in read-only mode, the dropdownlist's enabled property will be set to false."When it's on a read-only mode, it doesn't display the selected Category. it shows but the "No Category". When i click on edit to edit or change category, it doesn't display the selected category.
The example is given below( I am reading the book Sams Teach yourself ASP.NET 2.0 by Scott Mitchell. page 628)
<asp:Label ID="UserIdValue" runat="server" Visible="False"></asp:Label>
<asp:SqlDataSource ID="picturesDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT * FROM [Pictures] WHERE ([UserId] = @UserId) ORDER BY [UploadedOn] DESC"
DeleteCommand="DELETE FROM [Pictures] WHERE [PictureID] = @PictureID"
InsertCommand="INSERT INTO [Pictures] ([UserId], [CategoryID], [Title], [Description], [UploadedOn]) VALUES (@UserId, @CategoryID, @Title, @Description, @UploadedOn)"
UpdateCommand="UPDATE [Pictures] SET [UserId] = @UserId, [CategoryID] = @CategoryID, [Title] = @Title, [Description] = @Description, [UploadedOn] = @UploadedOn WHERE [PictureID] = @PictureID">
<DeleteParameters>
<asp:Parameter Name="PictureID" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="UserId" />
<asp:Parameter Name="CategoryID" Type="Int32" />
<asp:Parameter Name="Title" Type="String" />
<asp:Parameter Name="Description" Type="String" />
<asp:Parameter Name="UploadedOn" Type="DateTime" />
</InsertParameters>
<SelectParameters>
<asp:ControlParameter ControlID="UserIdValue" Name="UserId" PropertyName="Text"/>
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="UserId"/>
<asp:Parameter Name="CategoryID" Type="Int32" />
<asp:Parameter Name="Title" Type="String" />
<asp:Parameter Name="Description" Type="String" />
<asp:Parameter Name="UploadedOn" Type="DateTime" />
<asp:Parameter Name="PictureID" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>
<br />
<asp:SqlDataSource ID="categoriesDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT [CategoryID], [Name] FROM [Categories] WHERE ([UserId] = @UserId)">
<SelectParameters>
<asp:ControlParameter ControlID="UserIdValue" Name="UserId" PropertyName="Text" />
</SelectParameters>
</asp:SqlDataSource>
<br />
<asp:SqlDataSource ID="maxPictureIDDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT MAX(PictureID)
FROM Pictures
WHERE UserId = @UserId">
<SelectParameters>
<asp:ControlParameter ControlID="UserIdValue" Name="UserId"
PropertyName="Text" />
</SelectParameters>
</asp:SqlDataSource>
<br />
<asp:Label ID="cannotUploadImageMessage" runat="server"
Text="The photo could not be added to your album either because you did not specify a file to upload or the file specified was not a JPEG image with the file extension .JPG"></asp:Label>
<br />
<asp:DetailsView ID="dvPictureInsert" runat="server"
DataSourceID="PicturesDataSource" Height="50px" Width="125px"
AutoGenerateRows="False" CellPadding="4" DataKeyNames="PictureID"
DefaultMode="Insert" ForeColor="#333333" GridLines="None">
<AlternatingRowStyle BackColor="White" />
<CommandRowStyle BackColor="#D1DDF1" Font-Bold="True" />
<EditRowStyle BackColor="#2461BF" />
<FieldHeaderStyle BackColor="#DEE8F5" Font-Bold="True" />
<Fields>
<asp:TemplateField HeaderText="Picture">
<InsertItemTemplate>
<asp:FileUpload ID="imageUpload" runat="server" />
<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server"
ControlToValidate="imageUpload" Display="Dynamic"
ErrorMessage="There was no file selected" ValidationGroup="PictureAdd"></asp:RequiredFieldValidator>
</InsertItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Category" SortExpression="CategoryID">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("CategoryID") %>'></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:DropDownList ID="pictureCategory" DataSourceID="categoriesDataSource"
runat="server" DataTextField="Name" DataValueField="CategoryID"
SelectedValue='<%# Bind("CategoryID") %>'
Visible='<%# Bind("CategoryID") %>' AppendDataBoundItems="True">
<asp:ListItem Selected="True" Value="">-- Select Category --</asp:ListItem>
</asp:DropDownList>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("CategoryID") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Title" SortExpression="Title">
<EditItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("Title") %>'></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Title") %>'></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
ControlToValidate="TextBox1" Display="Dynamic"
ErrorMessage="you must provide a name for the title"
ValidationGroup="PictureAdd"></asp:RequiredFieldValidator>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("Title") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Description" SortExpression="Description">
<EditItemTemplate>
<asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("Description") %>'></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("Description") %>'
View 2 Replies
Nov 10, 2010
How can i generate dropdown lists based on what has been selected in the checckbox list. Below is an example of what i need. if the user selects the options day, lotID and waferID, then 3 cascading dropdown lists should be displayed. And then a gridview displays data based on what has been chosen in the dropdown lists.
Day
LotID
SlotID
WaferID
VendorID
ToolID
LocationDetected
ProcessStep
Stage
Precipe
WaferStartMaterial
WaferStartVendor
WaferStartLot
WaferDiameterCOA
WaferMapTitle
BreakPoint
BreakpointSide
BreakpointMeasurement
View 3 Replies
Mar 18, 2011
I'm trying to progam a strongly typed "Create" view using MVC 3 and razor. I want the user to be able to select a customer from a dropdown list (I populated this from my database using ViewBag in the controller). When the user has selected a customer I want a separate dropdown list to generate a list of dogs belonging to that customer related by the customerID in the database. The create button on the form will then take both of these values along with the the other fields and save it to the database.
View 1 Replies
Apr 24, 2010
I have a Gridview with a parameterized SQLdatasource. I want the Gridview to be filter when the a selection is made from the dropdown list Here is what I have. I am missing something.
<asp:SqlDataSource ID="SqlDSAlbums" runat="server"
ConnectionString="<%$ ConnectionStrings:Default %>"
SelectCommand="SELECT Album.Album, genre.Genre, Band.Band, Album.year, Album.AlbumUID FROM Album INNER JOIN Band ON Album.BandUID = Band.BandUID LEFT OUTER JOIN genre ON Album.GenreUID = genre.GenreUID WHERE (genre.Genre = @Genre) OR (genre.Genre <
'ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ') ORDER BY genre.Genre, Band.Band"
ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>">
<SelectParameters>
<asp:ControlParameter ControlID="ddlGenre" Name="Genre"
PropertyName="SelectedValue" />
</SelectParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDSGenre" runat="server"
ConnectionString="<%$ ConnectionStrings:Default %>"
SelectCommand="SELECT Genre, GenreUID FROM genre Order by Genre"></asp:SqlDataSource>
Select a Genre
<asp:DropDownList ID="ddlGenre" runat="server" DataSourceID="SqlDSGenre"
DataTextField="Genre" DataValueField="Genre" AppendDataBoundItems="True"
AutoPostBack="True">
</asp:DropDownList>
<asp:GridView ID="gvAlbum" runat="server" AllowPaging="True"
AllowSorting="True" AutoGenerateColumns="False" DataSourceID="SqlDSAlbums">
<Columns>
<asp:BoundField DataField="Album" HeaderText="Album" SortExpression="Album" />
<asp:BoundField DataField="Genre" HeaderText="Genre" SortExpression="Genre" />
<asp:BoundField DataField="Band" HeaderText="Band" SortExpression="Band" />
<asp:BoundField DataField="year" HeaderText="Year"
SortExpression="year" />
<asp:TemplateField HeaderText="Comments">
<ItemTemplate>
<asp:HyperLink ID="hlToComments" HeaderText="Comments" runat="server" NavigateUrl='<%# String.Format("ViewComments.aspx?AlbumUID={0}", Eval("AlbumUID")) %>' Text="Click Here" />
</ItemTemplate>
</asp:TemplateField>
View 4 Replies
Mar 4, 2011
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?
View 2 Replies
Jan 15, 2011
how to implement a filter feature like this? What Ajax or JQuery controls can be used for this (if any)?
Here is an example of how the UI might look like:
See the Exchange Management Console image:
[URL]
Here is the spec:
The ASP.NET page has a "Filter" component and a "Apply Filter" button. The "Filter" component consists of 4 UI controls as below:
1. A dropdown list with prepopulated values like "Name", "Department", "Building", "Email Address".
2. A dropdown list with four operators - "Equal", "Not Equal", "Like", and "Not Like"
3. This is a dynamic control. It could be a textbox or a dropdown list. If the user chooses "Name" from the first UI control, the third UI control will become a Textbox. If the user chooses "Department" from the first UI control, the third UI control will become a dropdown list with all departments within this company pre-populated.
4. A button with AND expression. If the user clicks this button, one more Filter component will be created.
One possible user case is like this:
ASP.NET: when the page is loaded, it displays one Filter component (3 UI controls and a AND button), a "Apply Filter" button, and an empty "Filter Result" data grid.
View 2 Replies
Aug 4, 2010
I have a listview that is displaying records currently based on a dropdown.. works great.. now, within those results returned, i would like to filter down some more.. How can i add a dropdownlist to the page that is populated with data from the listview(only 1 field would be used to create the list ) and if you chose to filter by that drop down, then the listview is revised to display only records with the selected value.
Example..
Currently you pick from a drop down.. Report#1, Report#2 or Report#3 Say report#1 returns 100 records.. and the field im going to be filtering on is my "Vendor" field.. so once my listview displays my results, a dropdownlist is populated with all the vendors that were returned with the query.. could just be a few..
Now you are sitting there paging thru all the records.. and realize you really just need to see out of the 100 records, records that belong to Vendor#3, so you pick #3 from the drop downlist and the procedure is called again now filtering on that vendor..
View 21 Replies
Sep 16, 2010
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
View 3 Replies
Oct 22, 2010
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.
View 3 Replies
Jun 16, 2010
I am trying to preselect an item in a drop down list box based upon a value I pass in from a data reader. When I place a "Watch" on the drop down list box, the code I am listing below says that it does what it is supposed to and sets the "selected item" to the one I want BUT when the page is rendered and comes up the first item is always selected. It is like it loses the set when the page is loaded or something.
Here is the code....
<td style="width:33%"><asp:Label CssClass="formlabel" ID="lblRU" runat="server" Text="Reporting Unit: "> </asp:Label> <asp:DropDownList ID="ddlRepUnitTeam" runat="server" DataSourceID="SqlDataSource1" DataValueField="MR_LU_TEAMS_PK" DataTextField="MR_LU_TEAMS_NAME"> </asp:DropDownList> </td> <%
For Each item As ListItem In ddlRepUnitTeam.Items
If item.Text = myReader.GetString(0) Then ' ddlRepUnitTeam.Visible = False
item.Selected = True Exit For End If Next %>
For giggles, I add the ".Visible = False" in there as a test and commented it out later. That doesnt work either. The item still is visible. I know the IF statement passes as it enters into the if statement using debug mode and hits the "Exit For" so I know the condition is being met. I am at a loss over this one.
View 8 Replies
Sep 8, 2010
Does anyone know how to do this so when I select something the 1st dropdown and the 2nd one becomes visible and populates list from a Select statement. I really need help on how to do in an aspx and not on the code behind page.
View 12 Replies
Jun 12, 2010
I Have the gridview control with 2 dropdown list and 2 text boxes,When the textbox chnaged event happen 1 row will create and the dropdown back to initial values( its not retaining the selected values),I am binding the control after text changed method,Is there any properties needs to be set or any other way we can retain the values in postbacks?
View 4 Replies
Mar 16, 2011
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?
View 3 Replies
Jan 9, 2011
I 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 Replies
Nov 12, 2010
I have a table that has 3 columns, ID NAME DESCRIPTION at the moment, i have a drop down binded to name(bring back a list of names) simple enough!
now i want to put a label next to the drop down so that what ever is selected , it would show a label description next to it...
View 5 Replies
Sep 21, 2010
I have a dropdown list with four options like:
New Reviewed
To be Reviewed Presented
I need to display only specific items in the dropdown list based on some conditions.I mean sometimes with only 2 items
New Review Sometimes with 3 items
New Review To be Reviewed and sometimes all items.How can I do this? I am using C#.
View 2 Replies
May 27, 2010
Is there a way to open modelpopup window based on value seleted in dropdown list?
View 5 Replies
May 27, 2010
Is there a way to open modelpopup window based on value seleted in dropdown list? I want to open a window when Urgent is selected in the dropdown list=!!!!
here is the code for ModalPopupExtender:
<ajaxToolkit:ModalPopupExtender ID="ModalPopupExtender1" runat="server"
TargetControlID="DropDownList1"
PopupControlID="Panel1"
BackgroundCssClass="modalBackground"
[Code]....
View 4 Replies
Jan 24, 2016
I have following situation
1. I have gridview which is bind with sql data source column name industry
2. I have checkbox list which has all industry name,
3. I want to pass checkboxlist selected value to sql data souce to filter data in gridview.
View 1 Replies
Mar 12, 2010
I have a drop down that lists all our 40+ locations.. I then have a list box with all our locations as well. The client is presented with the question which locations have you worked at before. If they pick say 3 locations, i need to remove or disable those 3 from the drop down. I have other code for creating a drop down, but not sure where to go with this.
Here is my code for the controls and code behind:
[Code]....
View 17 Replies
Feb 21, 2010
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 Replies
Jan 3, 2011
i 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.
View 4 Replies
Sep 30, 2010
I am wonder how I can generate a result table from linq to sql as below
Car sales table
Toyota small
Toyota passenger
Toyota small
Honda small
Honda small
Honda passenger
Honda small
result table
Brand small passenger total
Toyata 2 1 3
Honda 3 1 4
GridView1.DataSource = (from dtCarSales.AsEnumerable() .....
View 3 Replies
