Get Unique Items From DropDownList?
Jun 12, 2009I am trying to grab all unique items from a DropDownList. Is there a simple way to do this?
View 5 RepliesI am trying to grab all unique items from a DropDownList. Is there a simple way to do this?
View 5 Replieshow to add an item to a dropdownlist.i have tried this
DropDownList1.Items.Insert(0,
"Abu Dhabi")
DropDownList1.Items.Add(
"Dubai")
but nothing is showing in the dropdownlist
Using VB.NET I want to add a data's in the Datagridviewcombobox column
Code.
cmd = New SqlCommand("SELECT Sched_Name from tb_Sched_Master", con)
ada = New SqlDataAdapter(cmd)
ada.Fill(ds1)
[code]....
But I cannot get the data's, what wrong in my code.
I am new to VB.NET 2008 and a few users on this forum have suggested using Generic Lists instead of the old VB6 model of Collections. I need to add to the list of several items to the list, but what is happening it it is changing the first item in the list when I add the second, so there are now of the same item in the list. How do I add unique items to the list? Also, in the collection world, I could define a index of an item by placing the index value into second item of the Add Function.
[Code]...
I'm designing a web page with two dropdownlists, one for the Make of a car, the other for the Model, both bound to a database with separate SQLDataSources, and using a distinct statement. I add "All" at the top of both by setting appendDataBoundItems = true and adding items named all. Then when I fill the Make with a querystring all the model items get added twice (but only the databound items).
Here's my code:
<asp:DropDownList ID="DropDownMake" runat="server"
DataSourceID="SqlMakes" DataTextField="Make" DataValueField="Make"
AppendDataBoundItems="True" EnableViewState="False" AutoPostBack="True">
[Code].....
I would like to disable a specific items from DropDownList. I have below code but it does not working. DropDownList have 5 items.And,I'm getting error:Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index
Protected Sub CheckBox1_CheckedChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles CheckBox1.CheckedChanged
Dim X As Integer = 0 <> 1
DropDownList1.Items(X).Enabled = False
End Sub
But, if I add a different value for X, then it disable 1st and 2nd item.
Protected Sub CheckBox1_CheckedChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles CheckBox1.CheckedChanged
Dim X As Integer = 0 or 1
DropDownList1.Items(X).Enabled = False
End Sub
My goal is if I would have a 365 items in DropwDownList to disable items for example between 120 and 150.
I have an Web application that retrieves some db info and send it out to an html table. All created on the fly in vb code behind. For every post (row) in the db I also fill puts an instance of a Dropdownlist with items read from the db. That means that for every row I read from the database I read the same db info into the Dropdownlist (see the skeleton example below). A lot of overhead I think. It must be possible to create the Dropdownlist once before the loop and copy from that instance in the loop.
Partial Class _Default
Inherits System.Web.UI.Page
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim cboCombo2 As DropDownList
Dim i As Integer
[Code] .....
This is my code and i am getting an error ..Cannot have multiple items selected in a DropDownList. when the page loads it select "ALL" in DDLModality but when i change DDLModality.selectedvalue to any "value" then no error but again when i change to "ALL "getting the error.
onchange of DDLMODALITY submit the form
form1.target = "";
form1.action = "";
form1.submit();
[Code]...
Im using Visual Studio 2008 (ASP.net) to build some web pages..
I have a DropDownList linked to a DataSource from data base to fill it automaticly, and it works perfect, but I want to modify the items before its displayed ?
i used the following technique to Select multiple items from DropDownList into TextBox with No duplicates, however i dont think it is the most proper way,
pressing again with same value selected choose another value from DDL and press button
here is my code Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click If TextBox2.Text.Contains(DropDownList1.SelectedItem.Text) Then
[Code]...
I am trying to use datasource and bind in my application to set a dropdown list to the results of a query. The dropdownlist populates correctly (shows each different type_name in the set) but later when I use ddltype.selectedvalue - I am always getting the value from the first item in the dataset. Here is the code.
[Code]...
I would like to show different values in a dropdownlist, while editing a gridview, depending on which user is logged in. For example...
The officer would see "Approved by Officer" status.
The director would see "Approved by Director" status
I am trying to add these programatically to a dropdownlist which I have in the edit template of my gridview (approvalsGrid). Here is my code:
Protected Sub ApprovalsGrid_RowUpdating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles ApprovalsGrid.RowUpdating
Dim ApprovalEditDD As DropDownList = CType(ApprovalsGrid.Rows(ApprovalsGrid.EditIndex).FindControl("ApprovalEdit"), DropDownList)
[code]....
I do not get any errors. But get an empty dropdown with no items. Am I using the correct event?
I would like to disable a specific items from DropDownList. I have below code but it does not working. So, need someone to told me what I'm doing wrong. DropDownList have 5 items.And, I'm getting error:Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index
Protected Sub CheckBox1_CheckedChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles CheckBox1.CheckedChanged Dim X As Integer = 0 <> 1 DropDownList1.Items(X).Enabled = False End Sub
But, if I add a different value for X, then it disable 1st and 2nd item. Protected Sub CheckBox1_CheckedChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles CheckBox1.CheckedChanged Dim X As Integer = 0 or 1 DropDownList1.Items(X).Enabled = False End Sub My goal is if I would have a 365 items in DropwDownList to disable items for example between 120 and 150.
I have a dropdownlist with a list of options which is subject to change (e.g. 'active users'). Another data source may include historical data, but I wish to use the 'active users' dropdownlist against it. This means an ArgumentOutOfRangeException will be thrown so I want to catch that, and insert the required entry into the dropdownlist on the fly.
I've seen a few suggestions that point towards overriding the ondatabinding event within the dropdownlist, I've managed to do this insofar as I can create a static listitem for example "Value does not exist" and bypass the exception. However I wish rather than "Value does not exist" so show the actual value which we were attempting to find in the ddl.
ondatabinding is passed a standard EventArgs item which doesn't offer much to go on, I can see there is a DataListItemEventArgs class - is this in any way associated with a dropdownlist? I tried directcast on the EventArgs but that didn't work.
So is there any way - within ondatabinding - of finding out the value we're attempting to set on the dll, which causes the ArgumentOutOfRangeException?
How can I create a list (of my custom structure) to hold only unique items? This list should be created from another list.[code]...
View 5 RepliesI have Detail In Which I USed as Dropdownlist to INsert Item Template and I Am trying to add items to Dropdown using vb.net code using for loop bu when THe Page Runs it adds the values Five times because total rows in detail view are five .Here is My Code
If Me.IsPostBack Then
If Page.User.Identity.Name = "gate" Then
For Each DetVW As DetailsViewRow In DetailsView1.Rows[code]......
On the form load event i want to populate my ComboBox1 to display unique items directly from the DB. For that i have set the DataSource property of the ComboBox1 to the selected field. On the ComboBox1_SelectionChangeCommitted event i have set the filter for the DataSource which is working fine.
Now when i select an item from the ComboBox1 i get the filtered result in DataGridView but when i again drop down the combobox i see nothing other than the last selected item. Why is this happening? Is there a better way of populating ComboBox with the items directly from DB with default selected value as null?
I have a webForm app that registers a user in the database based on the information provided with a web service, auto-generates a random password and username, and e-mails the user a link to take an application based on the marketing company selected. How do I get only the currently logged in user's groups to show up under the MarketingCo_DropDownList. Each user allowed access to the system will have membership in at least one of the marketing groups as defined by the web.config. For example, a user that is currently logged in and belongs to the BIG group under location "algACOMP_user_BIG", will only be able to see BIG in the Marketing Company drop down list. A user that is currently logged in and belongs to the NIS group located under "algACOMP_user_NIS" will only be able to see NIS in the Marketing Company drop down list.
Here's my best guess (located under Private Sub GetMarketingCompanies() method in default.aspx.vb):
If InStr(WindowsIdentity.GetCurrent().Groups = "AMG", item.MarketingCompanyShort = "AMG", CompareMethod.Text) Then
marketingCo.Items.Add(String.Format("{0} | {1}", item.MarketingCompanyShort, item.MarketingCompanyName))
For Each item In ac1
[Code] .....
In my project when someone logs in I refresh the overhead and side menus. My overhead menu is an extended menustrip component that I have made. I am able to clear the menu, reload it dynamically but I am not able to add/insert the open windows which are managed by the mdiwindowlistitem property. These are the items named "1 - form name " "2 - form name" etc.
I have been able to copy the whole dropdown list, and with some very hacky loop work I can take out everything but the items related to the forms. But when I add them back in, they are not on my list. The related forms are still open and if you click the maximize button to shrink a open child window, and then re-maximize that same window...the items magically show up in the list.
This ManageMenus sub is called during a login change. If you breakpoint on "openwindowslist" after it is returned with data, it has the proper entries and nothing extra. It just seems that the for/each add loop does not actually add the items. Or, if it does add them, I can't see them.
Tried both insert and add functions, same results both ways.
CODE:
In my xmlMenuStrip component this is the function that removes everything but what follows the seperator. It returns them in a list.
The format of the full window menu is:
CODE:
I am using VB .Net to access the eBay API and store all completed orders in a database. This database is then fed into a proprietary shipping system, which can not handle an order number larger than 20 characters. eBay returns an order number like so 230407279314-680141236013 which is too long. The order number is always 12 numbers a hyphen and 12 more numbers. What I need to do, is turn this (the result can be alpha numerical) into a shorter, unique order key to store in my database alongside the true orderId (so that this can be referenced by the shipping software instead of the actual order number). The reason for the 20 character limit is the barcode algorithm used. Is there any way to achieve this in VB .Net 2010? This number can be anything unique, so long as it does not exist already (even a good uniqueid function would work, but I would have to query the database to make sure it isn't taken)
View 2 RepliesI'm using the datagridview. This is the sample data:
[Code]....
How do I parse through the grid to rename the duplicate values in a particular column (in this example it's the l_name field) into such a format?
[Code]....
I have a window having 2 dropdowmlists(schemename-SN and propertyno-PN) , one chkbox ,one "VIEW" button.SN has options "all" with value=0 and many other options with respctive values.Now,i want the code should behaves as follows:
1.0n window onload, SN must b visible bt PN nt.
2.if i select SN other thn All...the PN shud b visible and if i select "All" ,PN hides.
3.when check box is checked- PN hides,and if it is unchecked- PN visible..
Important:-This whole ddl n chk box are in updatable panel,button is nt in that.I want a browser compatible code so javascript can't b used directly(cz they give problem in mozzila and chrome).Right now, i have done this JavaScript and its is working fine.
function window.onload()
{
DisableProperty();
}
[code]....
but this code is not browser compatible.here onload,onkeyup and onclick functions are used , but they dont work in other browsers except internet explorer.
Let's say I have a menustrip, which has a category "Colors" for example, and in that category there is an option of 20 colors, but I want only 1 to be checked at any one time, now to do that with what I know, I'd have to check every other one of the check boxes and uncheck them in every single click event, is there no cleaner way to do this?
View 5 RepliesI have the following problem: I select a customer from a dropdownlist and then the gridview should load all items of all orders of that customer. I have the following query:
Dim allorders = From ord In db.Orders
Where ord.CustomerID = Convert.ToInt32(CustomerDropDownList.SelectedValue)
[CODE]..............
I also tried to modify the query as follows:
Dim orderitems = From oi In db.OrderItems
Where oi.OrderNumber = (From From ord In db.Orders
[CODE]...........
But this does not work. I just started using LINQ.
How generate the unique no. 1,2,3 and so on .... on button click of each new user ..
the code mentioned below is a readwrite coding in vb.net ...
but the problem is it generate the same id for different users on button click event... but i want the no. of times button clicked the new ids will be generated
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim FILE_NAME As String = Server.MapPath("counts.vbi")
[Code].....
Unique constraint - these columns currently doesn't have unique values..?? I have created Unique Constraint with 3 columns. My code works perfectly but once - two users @ same time entered same data and somehow it saved in DB; after that incident. This UniqueConstraint gives me error - These columns currently doesn't have unique values. How can I check if user enters this kind of entry or how can I restrict the Entry?
View 2 RepliesI have found a couple of examples on the internet to do this but really struggling to get it working in VB. (Tried a converter but had mixed results) I need the selection options of a Dropdownlist to be populated based upon the differing values in the first dropdown list.
Can anyone help with a releativley simple example in VB? Not fussed if the values are "hard coded" in the script. Or a SQL bit that pulls the data from a table
This my working method to send a email
Sub emailConfirm()
Dim email As String = txtMail.Text
Dim name As String = txtPrenom.Text + txtNom.Text[code]....
note:I want to send Link contains a unique identifier and verify the unique identifier in the login.aspx.I don't know when to do this...I found nothing interesting on the net ...
I'm trying to write a program that selects an item (Area Code) from a combobox and this list gets the city that was associated with this area code (another comnbobox list)
View 1 Replieshow unique is this ? will i ever get duplicates ? and will it ever change ?... i want some way of relating my software to the customer .... is there a system GUID?
Function GetCPUID() As String
Dim sReturn As String = ""
Try
[code]....