My application stands at the minute where the user can fill in a textbox, hit search and gets the results. The problem is that the user only get the exact name i.e. if he types in golf he only gets golf, what I need it to be able to do is when he types 'go' and hits search it shows all of the entries that contain 'go'.
My Current syntax is
"Select * from Software WHERE STitle = '" + TxtSearch.Text + "'"
I am to make a program that lets the user save certain data values with a delimiter(":") to a text file(done) Example of data entries [code]Then i am to load those values to a listbox , i was able to do that as well and i include the delimiter when i load the values.Now i am supposed to let the user enter any month/year value for date(mm/yyyy) such as 06/2010 and if any of the entries match the search string then either the program selects those values in the listbox or a popup msgbox is used to show the entries. How the result is displayed is a little irrelevant, but how do i search and atleast select the matching entries in the listbox ? and not just the first instance but all instances of the search string.
View 3 RepliesI have a program where you have three entries, CD name, artist, price and it goes into a listbox and .txt file when closing. I have to have a message box if you enter the same CD name. I have a code to open the .txt file and compare strings but I need to change it to compare only the CD name and not all three entries. Is there a way to do my string compare against my listbox without opening the .txt file?? The program loads the listbox from the .txt file when opening. Private Sub btnAdd_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnAdd.Click' adds CD information to the list box
' declare variables
Dim strName As String
Dim strArtist As String
Dim strPrice As String
[code].....
I need to know how to show my search item in a data grid? There is error in grid display part. [Code]
View 1 Repliesso basically, (pretty simple) I have this listbox, filled with items like
(eg.)
Billy Bob
Jerry
Jo-Shmo
Okay, how can I 'search' and listbox item containing 'Bob', like I click a button on a form with the listbox presented, and then it auto-selects the one that contains bob? HOW COULD I DO THAT?
I'm trying to load up a comma delimited text file and have only the name of a person loaded into a listbox. Then when the user selects a person from the listbox have additional stats pertaining to that person show up in a label.
View 4 RepliesHow can i select all the entries from a field?
e.g. here's the database:
| Username=Password |
| Nick=23123|
| John=asdf|
[Code].....
In my application I have a listbox and SelectionMode should be MultiSimple because users need to see which items they selected. In another tab we have another listbox this one should show all the selection users had done in first tab. Private Sub
[Code]....
How can I search, for example ID Number, and want to highlight the listview item found in search from my first form? I'm using combobox from my second form to search.
View 6 RepliesI have a multiple form application with a listbox on each form. I want to be able to select an item in one listbox on one form and then click a button and it show up in a listbox on another form.
View 3 RepliesHow someone would select an item from a list box and click a button and have that item go into another listbox with it's price? I seem to be stuck on this part.
Here's my code:
I want to select the first option from the first listbox and I want to put it into another listbox along with the price of that item on the same line in the listbox. I can't seem to figure out how to that.
Public Class Form1
Const dcmPRICE_STRESS As Decimal = CDec(595.0)
Const dcmPRICE_TIME_MANAGMENT As Decimal = 695
[CODE]...
I'm a bit of a noob at this and finding that all my research that's led me to wanting to do things right for data integrity are making it a bit more complicated on the front end.
Presently I have a Form in which I have two DataGridViews that I'm populating, each with it's respective stored procedure.
What the form is for is for linking rows from the one DataGridView (I'll call it DGV1) to a different one in the other DataGridView (DGV2).
Now to facilitate the ease of doing this for the user I want to both have the dgvs fully populated so that if the user wants they can just slide on through and manually select the rows in each they want and then there'll be a button to select which I'm planning to then use another stored procedure to then insert this connection between these two items into the database.
Another thing to facilitate this is a search bar. I want them to be able to type in something and have the datagridviews both navigate to where their selection is as well as selecting it so that it's then ready to be bound to the selection in the other.
What I'm wanting to know, and having a hard time figuring out, is how do you get such a search function to work on DataGridViews that I have bound to these read only stored procedures? How do I search and select within the DataGridView? And then how would I go about using the selection from two different datagridviews and putting those as parameters in the stored procedure that I wanted to use to then record the relationship in the database?
i have a treeview with 8 Root items, my program needs to add items to the treeview without me selecting the proper root or item, the root items have been coded so they cannot be deleted, but i'm not sure how to get the software to place data in a particular root by what its name is. when you add children the indexs change so im not sure where to begin. heres an example
[Code]...
how whould I go about deleteing an item from a listbox and it will select the next available item.you know like the treeview control selects the next node if you delete one.
View 2 RepliesI want to set a certain column to true or false automatically based on what value another column has entered. I managed to get this working by myself using the 'SQL Pane' in VB and testing it by using execute sql but I don't know what to do now. I assumed that I could just save it and it would work from there but that's not the case, it dissapears from the SQL Pane if I close the project (even though it worked fine when I ran the project the first time), so where do I put it/what do I do with it in order to get this to work?
View 1 Repliesstock table
fkodsno
[code].....
In My Application, i have one Text Box, One List View Control and one Button. When I enter some text in Textbox and click the Button, it will highlights that search item in Listview Control.. if match was found otherwise nothing.[code]...
View 4 RepliesI need to do a lookup in a DatagridView column. I would like something with the blazing speed of what recordset.seek used to provide. I am assuming that a similar function/method is available for use with the DVG. What else is there to use that is better than my present implementation.
[Code]...
I currently have this for search:
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Using sr As New streamreader("C:moblist.txt")
While Not sr.endofstream
[code]....
I'd like to modify that to be able to put part of the name and it find it. example: Search for Banana Apple pie what it finds is 1743 = Banana Apple Pie Also I'd like when clicked the item from the listbox is displayed in a text box. If I use textbox.text = moblist.items(i) it only shows it when I search and not when I click. I've tried textbox.text = moblist.selecteditem but it does nothing?
I am using VB .NET 1.1 and wanted to make sure if inside a key value pair class "Dates" (collection type) a key by name "TerminationDate" exists.
If Not Dates.Item("TerminationDate") Is Nothing Then
'Do x y z'
End if
But this is throwing an exception: Argument Index is not a valid value.
How to Write Code in Vb.NET For Search Function having three item table?
View 1 RepliesData in Table1 is as follows
Code-------product--------weight
1-------------Apple----------2.00
2-------------Mango---------3.25
[code]......
i wanted to show the name of an employee once he/she typed the correct id number and password.. and it will show the name into the name textbox... same as the the current time once the user clicked the time in button it will show into the time-in txtbox...same to the time-out how its logic goes..
View 3 RepliesIs it possible to always select the first item in a listbox?I prefer not to use listbox1.selectedindex = 0 or something like that because i have loads of listbox1.items.add etc. and that would just make the code bigger.so is there an option in a listbox or something..?
View 1 RepliesI have a listbox with items in it. And the top item is selected, how can I make it so when a button is clicked it goes to the next one in the list? I used this but
UseClick(Listbox1.SelectedItem + 1)
The selected item needs to be an string, and not an object.
what I want to do is make it so when i select the first item in Listbox1 it will also select the first item in listbox2 and if i select the second one it selects the second one on listbox2 as well. Is there a way to do this? i honestly have no clue and i know my code is wrong cus i do not know how to select the item # on listboxes but this is what i have:[code]
View 7 Replieswhen i click an item in my datagridview, how can i get the item value?i thought datagridview.item would give me that.
View 5 RepliesI have three columns in my ListView and they are ID,Name and Age, and from the properties of ListView i have set "FullRow" select to True and "MultiRow" select to false
ID Name Age
1 nix 12
2 pix 21
3 xin 22
4 xip 24
i want to select the ListView entire row where ID = 3
How do i do in vb.net 2008?
Before i did like this
me.myListView.Items(0).SelectedItems = 3 but this gave me an error
i want to select the last item in the listbox but it look like i'm having a problems with it..
here is what i have done so far
itemCnt = ListBox1.Items.Count
lastItem = ListBox1.SelectedIndices(itemCnt)
textbox1.text = lastItem
its look like it take a long time to proceed this code..
I have a combo box with a list of book conditions. When a book is loaded into the form, the condition the book has needs to be selected. How can I do this? Here's what i have: Excellent Very Good Good Fair Poor just for example, how would i select "Good" WITHOUT USING THE INDEX? The database knows the condition text, and condition id. I need to select the condition in the combo box with either. However, I don't know how to add the condition id to the items in the combo box. How would I do this in Visual Basic 2008? **EDIT** I forgot to mention, although i am using a database, i am NOT using SQL Server. I just need a way to select it with a variable containing either the id or condition.
View 11 Replies