I want to add only unique items into the list box.I am using lstListBox.FindStringExact(strKey) it works perfectly. But I have large number of strings and it is taking too much time. It also make the CPU uses 100%.
View 5 Replies
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 RepliesWhat I need is to be able to put in a SortedList a combination of two fields that are non-unique, but the pair is (like database composite keys).More precisly, i have my list, and i want to be able to do this with it
Dim myList = New Generic.SortedList(Of String, String)
myList.add("aaa","aaa")
myList.add("aaa","bbb")
[code].....
In my VB project I need to create a unique string of alphanumeric characters 4 in length from a numeric string 8 in length.This numeric string will always be 8 in length and could range from 00000001 through to 99999999
View 12 RepliesI have a listbox which is populated from a sql table. I need to select unique month values from the dates in this listbox.
Dates are, for example:
21/09/2010
22/09/2010
21/07/2010
09/06/2010
I need to extract september, june and july only from the above, sort them and display them in a another listbox.
I have a datatable and I want to create a text file using this datatable. I want that each row of the newly created text file is unique. If there is a duplicate row, then it should add * to both rows ( duplicate rows)
I am using following code:
Dim str As String
For Each row As DataRow In dataTable.Rows
str += row(1) ' This is text data
[Code]...
My goal is to make the string ...
vb
strLocations = "WI - WI IL"
to
[code]....
I need to generate a globally unique ID of fixed 16-lengthThe GUID is too long for my purpose. So I wonder is there any way to convert it to a 16-length?If this is not possible, I have a program key of 8 chars, and is thinking of using the DateTime as my key.
View 4 RepliesI am trying to populate an array with all the unique values in a string, to prevent me ReDim'ing an array every time I find a value that not already contained in the array I am trying to create (consumes alot of time), I am trying to get the unique values first so I only have to ReDim once and after that I can simply iterate through the string and the array I have will be the correct size for the unique values I aquire (I am using this...)
[Code]...
I'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]....
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].....
I am going to have a series of numbers, I want to count how many times each unique number exists in the results.For example if I have this string" "1, 2, 3, 5, 3, 7, 1" I want to know the number 1 appears 2 times, the number 2 appears 1 time, the number 3 appears 2 times, the number 5 appears 1 time, and the number 7 appears 1 time.I want to load this up into a datagrid each unique number will be stored in a column named acct the number of times the number appeared in the string will be stored in a column named numref?
View 3 RepliesASPX:
<a
href="ShowImageVB.aspx?id=<%# Eval("ProdID") %>">
<asp:Image
runat="server"
ID="ImageThumbnail"
AlternateText="Click here to open the real size image"
ImageUrl='<%# "ShowImageVB.aspx?thumbnail=true&ID="& Eval("ProdID").toString%>'
Style="border-width:
0px;"
/>
</a>
Code Behind:
Dim data As DataView = SqlDataSource1.[Select](New DataSourceSelectArguments())
The above code does not seems to work when I change my ProductID to UniqueIdentifier Datatype. This is the error I have ""Input string was not in a correct format."
But when change the ProductID to Int datatype is working fine.
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 a listbox which on form load generates correctly from a text file like so in a listbox...ex"John Doe, 1""Bob Brown,2"I now would like to search the listbox if it contains either a "1" or a "2" which is does in this case and copy the item to another listbox. The 1 and 2 indicate positions I have a position listbox for each position. So 3 listbos, first one contains the names on form load, 2 other empty listboxes one for position 1 other for position 2...I have tried the following
If xReservationListBox.SelectedIndex = xReservationListBox.FindString("1") Then
'MessageBox.Show("Found It")
xSpot1ListBox.Items.Add(xReservationListBox.Items(0))
[code].....
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 have Editbox1 and Listbox1..Inside Listbox1 are the items "#FIRSTNAME# " and "#LASTNAME# "How would I go about adding the text in Editbox1 BELOW the item "#LASTNAME# " in Listbox1 ?
View 3 RepliesDoes this code look correct to complete the task?'store all medications information as string value
While lstMeds.Items.Count > -1
For i = 0 To lstMeds.Items.Count - 1
strActiveMeds = strActiveMeds & lstMeds.SelectedItem & ", "
Next
End While
I have a list box with groups of people and is displayed as such:
Paul Mary John
Frank Steve Bill
Jacob Dan Spongebob
and so on...
If i use the code below i can find and auto highlight Paul, Frank, Jacob but never finds anyone after the first like Mary, or Bill.
Dim findperson As String
findperson = CStr(TextBox1.Text)
ListBox1.SelectedIndex = ListBox1.FindString(findperson)
Essentially it is for quick reference for people to find who will be in their groups.
Im creating a program that allows the user to query a database.ive got a listbox which will contain the table names of the attributes that were selected during the building of the query. How do i get the items from the listbox into a string (my sql statement) as im using this as my FROM clause?
View 7 RepliesI have a string of filenames separated by commas that I want to add to a listbox. This is how I'm currently doing it:
vb.net
Dim FileNameArray() As String
myFileNames = tblOpenTemplate.Rows(0).Item("filenames").ToString
FileNameArray = myFileNames.Split(",")
For i As Integer = 0 To UBound(FileNameArray)
.ListBoxFileNames.Items.Add(FileNameArray(i).ToString)
Next i
But I've been reading about using:
vb.net
Dim FileNameArray As New List(Of String)
How to populate this with string of filenames?
i would like to do it almost the same way like in my recent other topic, read a file and put every line of it in a listbox.
View 5 Repliesi wish to make something similar to a command-line kind of thing in which one can type a series of words and the program will run the string through a function that splits up the words uses the first word string to find which function needs to be run and makes the other word strings as parameters of the function to run. its kind of like a odd interpreter based scripting language however once this problem is addresed i have a seperate issue.
i then need to output to a new entry on a ListBox that would be named as a parameter of the first function that splits and such that i explained above.
however i do not know of what i can use to input the name of the listbox only then have that add an entry from within the function.
i wish to do it this way so as not to be tied down to the same naming conventions of the list box every time i use it.
in the end i would like to main function to do all of the above and be called simply like this: Comand2Function(inputstring, outputlistbox)
ListBox1.Items.Add(aString.Replace(" ", vbCrLf))
aString is like this: Tom Gary Kevin Bob Jason and so on, just all in 1 line What i want to do it add them in a listbox as a list. Also the string could be 1 name, 2 names or 200 names.I tryed replacing the " " with vbCrLf but since its a listbox all it does is remove the " "?
I'm a beginner, so my explanation might be a bit dumb, but i hope you know what I mean. I have a listbox listing goods (CD's) with information Idnumber, artist, album, price etc.
[Code]...
I'm trying to compare a string with all the items in a listbox, if it finds a match it returns true
Private Function Checkuser(ByVal username2 As String) As Boolean
If InvokeRequired Then
Invoke(New checkmeInvoker(AddressOf Checkuser), username2)
[Code]....
note ive tried more than string.compare does it have something with return false being at the bottom of the function. becuase ive tried adding an exit function once it returns true, but still I get returned with false to make it even more frustraiting the clipboard results are test/test
how would i convert a listbox to a string in vb 2008
View 5 Repliesim trying to get details from a listbox to appear in a string during run time. I have a string called strSQLselect and want it to appear with the details already in the string and have the details selected in the listbox appear with it in a rich text box called rtb_select.
Hear is the code i have so far
Private Function ListOf(ByVal lst As ListBox) As String
Dim strSQLselect As String
strSQLselect = "SELECT " & ListOf(ListBox1) & " FROM " & ListOf(ListBox2) & "
[Code].....
I need to take the items in a listBox and post it in a textBox with a delimiter. I worked some code but it does not work correctly. I think my array is wrong but i am lost. what happening is when i click button it highlights an item in listBox and then adds it one item to the textBox x number of times of items in listBox. so if i have 4 items in listBox it adds same item 4 times. anyway here is what i have.
[Code]...
I have splitted comma separated values in an string array, something like this
[Code]...
note 0,2,4,6,8 [even positions] are having number and odd positions are having string. I am having a class Attachmodel
[Code]...
In the above i want to set the values and bind it to the grid, using List
