Does 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
Imports System.Data.Sql
Imports System.Data.SqlClient
Imports System.Configuration
Module Module1
[code].....
this is my connection string on my pc how can i make this as a dynamic connectionstring so i cant remove the db and get a new connectionstring?
I am developing an application that takes user input into text boxes or list boxes or check boxes. I have 4 forms with questions of different categories. I want to form a paragraph string with some literal string text and add in the text from text boxes, selected item from list boxes and, either, add literal text string or add nothing to the string based on check box condition.dim strScopeParagraph as string
View 10 Repliesok, For the moment I have a string() where each element is in the structure of
[Code]...
I 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].....
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 RepliesI 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 RepliesI 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
I have quick questions for you guys how do I pick a random string from a listbox ? and also second question how do I randomize which line to pick out of a string array? lets say I have 5 strings
[Code]...
So im trying to do a simple system in my VB Express Edition 2008 and what it does is add some car models (example) to a list box and stores it in a .txt file for future use. But when the user clicks a delete button it should delete from both the listbox and the .txt. I have to use only the FileOpen(OpenMode.Append or OpenMode.Input/Output) functions.
View 3 RepliesSo im trying to do a simple system in my VB Express Edition 2008 and what it does is add some car models (example) to a list box and stores it in a .txt file for future use. But when the user clicks a delete button it should delete from both the listbox and the .txt.I have to use only the FileOpen(OpenMode.Append or OpenMode.Input/Output) functions.
View 1 RepliesI am using Visual Basic 2005 Express Edition I have to find a string in record of a ListBox; the string is in fixed place on the record. I wrote this code and this code working ok:
[Code]...
Right now im using
If ListBox1.FindStringExact(TextBox2.Text) = "0" Then
Label2.Text = "yes"
GoTo procheck
[Code]....
and it searches the first item in the listbox correctly but nothing else. Im assuming im going to need to loop through the listbox somehow?
I need to sort the values of my listbox to have the latest date on top plus some text
I used a reference I found here on the forum but I can't get it to work properly.[code]...
I have a problems regarding on how to display my data by 3 characters every listbox. This what really my problem is, I have data coming from my database and that specific field contains numbers but the problem is that is was merge and what i want is that i want to split that by 3 so that i can get the itemcode coming from other table that i need to display again on my grid or listbox. This is how it look like.[code]....
View 6 RepliesI have a number of listboxes called (listbox1, listbox2 etc) with various words and data in and I would like words that appear in the listbox to also appear in a string in a rich text box called rtb_Select.
strSQLSelect = "SELECT" & ListOf(lst1) & "FROM" & ListOf(lst2) & "WHERE" & ListOf(lst3) & "SORT BY" & ListOf(lst4) & ;
have the folowing code
rtb_select.Text = rtb_select.Text & "Select " & ListBox1.SelectedItem.ToString() & ", " & " From " & ListBox2.SelectedItem.ToString() & " Where " & ListBox6.SelectedItem.ToString() & " " & ListBox3.SelectedItem.ToString() & " " & ListBox4.SelectedItem.ToString() & ";"
In this it only allows one item to be selected and outputted to the string.
How would i be able to select 2 seperate items from listbox1 and have them displayed next to each other and seperated by a comma??
I have a small program that talks to a server, grabs the content from a website using a php webscraping program and then places the results in a listbox as a string. My problem is taking this string and creating a list from it. Each item in the string is followed by a | (pipe). I have included the code that I've tried below:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim str As String
Dim start As Integer = 1
[code]....
I'm adding text string into a list box together with data retrieved from text box, and I wanna bold that text but really don't have any idea how to do so.
E.g. listProducts.Items.Add("Product Name - " & textProdName.text)
I just wanna bold that first bit of text in the quotes.