I want to populate a Dropdown list from divisons of a figure in my projects database
for example database figure 50
I want the dropdown list to show 5,10,15,20,25,30,35,40,45,50
The database figure wont always be the same.
how would i go about doing this ? esp the populating of the dropdown list itself based on the way i want to show it.
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 RepliesI have a dropdown control that has a list of names in it called PlayerNameDropDownList_Insert and a textBox called PlayerName.
When I select a name from the dropdown it populates the textbox correctly.However, when the page opens the first name is selected in the dropdown but nothing in the textbox. How can I get the textbox to populate with the value of the dropdown at pageload?
[Code]....
I am running into some additional difficulties with dropdown lists, and I'm hoping you can correct my thinking.
I have a table populated with items; ITEM_ID, ITEM_NAME, ITEM_COST.
Here is my code:
[Code]....
With this code I get this error: DataBinding: 'ITEM' does not contain a property with the name '2'.
If I remove the assignment of DataSource to c1, the dropdown generates this error: 'DropDownList3' has a SelectedValue which is invalid because it does not exist in the list of items.
Parameter name: value
How should I code this so that the user is presented with a list of ITEM_NAMES, and that the ITEM_ID is stored in the value field so I can use it when the selection event is fired? I know I could databind the source directly to the dropdown list, but I am trying to understand the behind the scenes working of a dropdown list object.
I am populating a page with controls reading properties of a class using reflection. If the property type is 'String' I will add a text-box. If the property type is enum I am adding a dropdownlist. Now I have to populate the dropdown options with enums. How can this be done?
Both the enum definition class(Assignment) and the class(classOne) using which I am populating the page with controls are in the same Namespace(MySolution.Data). While looping through classOne properties when the property name is 'SkillLevel' I will have to go to assignment class get the members of enum SkillLevelEnum and populate the dropdown.
Same needs to be done for other dropdowns also.
My Code:
namespace MySolution.Data
{
public class classOne : MyAdapter
{
private string _Model;
[code]....
I have a ASP.NET AJAX Autocomplete Textbox and Two other dropdownlist in a Update Panel. On selection of an item in Autocomplete Textbox, I want to populate Dropdown list from Database.
View 1 RepliesIf got 2 dropdownlist say the user selects "toyota" in Dropdown list then it should show all the modals in the 2nd dropdown list what if tried is this ( i dont know why this aint working)
[Code]....
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
In a vb.net application I have a set of integers currently stored in multiple Arraylist (But this could be something different if required)
al1 = {1, 2, 3, 6, 7, 9}
al2 = {2, 3, 4, 9}
al3 = {2, 3, 19}
I would like to get the set {2, 3}
I thought about using LINQ to join the list, but the number of Arraylist can change. I know I can always loop through everything and check if an integer exsist and keep track of it, but I thought there might be an easier way?
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") %>'
I would like to use the IEnumerable function Intersect() to combine a few list and get the similar integers from each list. The problem I'm faced with is that I don't know how many list I will need to compare.
Here is an example:
A{1,2,3,4}
B{1,2,3}
C{1,2}
results = A.Intersect(B).Intersect(C)
This works great, but the next time around I may have a D{1,2} next time I come across the function.
I'd like to use the Intersect method, but I'm open to new ideas as well.
I've currently got a form with two dropdown boxes on, and an XML file sitting on the site.
My two drop down boxes are Location and Date and what i'm trying to do it get the Location box to filter the XML and put the dates in the Date dropdown box.
I'm using C#.
Unfortunatly, its not working.
My code is:
[Code]....
and my XML is like this:
[Code]....
why my dropdown boxes are not being populated?
I am using gridview for my application, in the grid i am using dropdown list for two columns ,It's working when i run my application but when i am edit application ddl can't show the editable data ( it show only select).And one more thing that two columns are interrelated , one ddl(Itemgroup) is connected with(ItemName).
View 2 RepliesI have a complicate problem. I'm not sure if I can explain it clearly. I have SQL table with columns: id, PartNo, ManuPartNo, GovtPartNum.
My boss want to do like this with 3 dropdown or 1 Dropdown with 2 listbox: If he select any PartNo, it will pull associated value For ManuPartNo & GovtPartNum
Also, if he select any ManuPartNo, it will populate back to other dropdown
Also, if he select any GovtPartNum, it will populate back to other dropdown
I'm so stuck & I don't know where to start on this.
Trying to populate a Dropdown in a DataList
Error is on line
cboCompany.DataSource = drSQL
Error is NullReferenceException was unhandled by user code
Code Behind
[Code]....
Code on ASP Page
[Code]....
I have been searching the forum for how to populate a dropdown without "spaces" or "-" but I can not find exactly what I am looking for.Actually the data input by the user contains specaial character and using datasource the dropdown is being populated with the original data but every user has different style to insert data so I want to populate dropdown(within forview) without spaces or dashes, hashes. By making this change I may be able to populate dropdown in an asc or desc order.I know it can be handle from database but I want to do it with some coding technique in vb.net or asp.net.
View 11 Replieswhen testing my query in the grid configuration wizard it works fine, but when i run the page it does not.
first - i select values from my cascading drop down list then enter values for two textbox (dates). then when i hit the button to populate my grid nothing is return back.
[Code]....
I have 2 drop down lists.I have a very simple dropdown list #1 that diplays a title and holds an id value which is a GUID.I know it is getting this value and sending this value as I tested sending it to a label.I have the dropdown list #1 to autopostback to dropdown list #2 that "Is supposed to get" another title and value based on the GUID value of the first dropdown list. for some reason it wont return anything. I have done 100's of these but never based off a guid value.I assume the value needs to be converted to guid before selecting it in the second dropdown list.How can I do this? or is there something I am missing?
View 9 RepliesDoes 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 RepliesI 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 RepliesI have a Drop Down List that has some items in it, I have a switch set up that will clear and repopulate the drop down list from a sql server db depending on which item is chosen. When the list is repopulated from a database table I want to use an if statement to do something based on which item is chosen. I've tried to use an if statement but no matter what I try, the code checks the if statement for the original items in the drop down list, not the items that repopulated the drop down list.
View 4 RepliesI have a dropdown box showing a list of roles. I used Roles.GetAllroles() for showing all roles in the dropdown box but I don't want to show a role named "Admin" in the dropdown box. How can I keep it out?
View 2 RepliesI have 2 dropdowns on my form, ddlMake & ddlModel. I want that ddlModel should have the corresponding value for which I have clicked the ddlMake dropdown, something like the cascading dropdown.
Here's my code :
[code]......
I have a upload section on a user control
<div class="AttachQuote"><fieldset>
<legend>Quote(s)</legend>
<asp:Button ID="btnAttachQuote" UseSubmitBehavior="false" Text="Attach Quote" runat="server" />
<ol id="olUploadedFiles" style="list-style-type: decimal; padding-left: 30px;">
</ol></fieldset></div>
the btnAttachQuote is defined as
protected global::System.Web.UI.WebControls.Button btnAttachQuote;
can i do something simular to olUploadedFiles? there are alot of list options in webcontrols and i'm unsure how to use them. I would like to use a for loop to populate olUploadedFiles from a string array in my .cs. something like ...
int i = 0;
while (files[i].Length !=0)
{
olUploadedFiles.add (files[i]);//i'll substring the file names out
i++;
}
I'm using the same control for both the form submit and the status page(label only mode). I can load the rest of the info i just can't populate the dropdown from the codebehind.
I'm trying to retrive data from an SQL server db and populate one of the columns into a drop down list.
View 7 Replies
