I have three controls on my form; Textbox1, cboCity, lstCity When something (lets say "a") is entered in the TextBox1; I want to get each and every item in combobox cboCity that starts with "a" and add them to listbox lstCity.
View 5 RepliesI'm in a bit of a quandry. I am trying to build a simple search form where the user selects the column title and in puts the criteria then clicks the search button. This is the code I am using
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
details = ComboBox2.Text
'column name selected by user
specifics = TextBox1.Text
'criteria input by user
[Code]...
Well I have a list of things I want to search based on multiple points of data...for example Resolution, 3D capable, touchscreen capable....etc....What is the best way for display someone can think of & filtering results by capability, I have none of it typed out, etc...like list of objects & capabilities, etc... alreat...so it can be made any way that is thought to be good(with speed as well) for many different listings...say 1,000 of them & it filters pretty much instantly....reading capabilities & such & the list itself is easy but how can I make a filter(unchecking something brings back things, checking something takes away only since well your adding capabilities to filter selection....I have pictures that can go with items too as well as a name & more information could be given directly with the method or clicking on the picture/item.
View 13 Repliesthe combobox with AutocompleteMode,AutoCompleteSource allow the user to search in the Combobox depend on the begin of items(string) how i can develop the combobox to allow to me search inside items example i have combobox contain this items:
[Code]....
In DataGridView I have three columns(year, month, day)
I wont first search dategridview by mounth, and the results search per day
I am doing a simple database project.I need to give the input in the database which is an access db from my input form and i have managed to do this part right.then i need to retrieve the details from the db using multiple search fields and show them in the datagrid view.I have 8 search fields(5 textboxes and 3 combo boxes). I also have included 4 other buttons which respectively clears the search boxes;clear the results of the gridview; show all results from the database;go to the input form and offcourse 1 search button.now all the buttons working fine except the search button. actually when i click on the search button if i include sql query for all the search fields only the first one works and also if i have clicked any other buttons before clicking the search button nothing happens, no result is shown and it happens the same if i search once and clicked any other buttons and come back to search, no result. I need to show the results in the gridview depending on the user input on those search criterias. user should be able to search in any combinations.I am using the below codings in my search form. the combo boxes are not bound.datagrid is bound to database though.
Public Class Paxsearchfrm
Private Sub Paxsearchfrm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'LAFDataSet.Table1' table. You can move, or remove it, as needed.
End Sub
[code]....
I've got a form that populates a DataGridView from an excel file. How would I filter that DataGridView so only the search criteria are visible. I need to search through 2 columns by all rows. I'm not very good with datasources I guess and can't figure out what all I need to accomplish this. DataSets, DataViews, DataTables.
View 17 RepliesCurrently I am searching through my list to find Customers that match on Address.
I need to match on both address and city. How do I rewrite my lambda Expression to match both criteria?
CustomerList.FindAll(Function(c) c.Address = addressToMatch)
[code]the main piece deals with the binding source filter. I've tried or/and. i tried to include that both codes in the string. i don't know what to do again i know you would recommend SQL but i don't know how to use that yet, so could you please recommend some bindingsourcefilter code to assist please. Its for a School project the search window looks like the attached picture
View 13 RepliesI'm using VB.NET with the MySQLConnector, I have an ID column with differents values, i.e:
101
102
201
202
203
302
304
305
306
I want to select all the values that start with "3" and then, select the MAX of them, in this case, "306"
I am building a real estate website. I have a table for properties (i.e. "houses"), a table for pictures, a table for features, etc. So each property's data comes from three, not only one table. I need to provide a function that retrieves requested property data depending on a search criteria, for example:
[Code]...
I need some guidance on the best way to proceed with searching a file content. I have a large file (see attachment) that is in text form, some of these files could be upto 50 times as big, therefore creating a huge file. These files contain information that is produced from another application and therefore I am unable to change the format of the file.
[Code]...
I am using VB.NET together with ADO.NET to create a program. I have set my TableAdapters as needed and bound the correct tables-columns to my comboboxes.My problem though is this:My combobox2 item is bound to a datatable. The table adapter's Fill method (the select command basicaly) includes a public variable in the where clause to fetch the correct results. I ll put some code here to clarify it a bit more.Public Class Frm_inv
[Code]...
I have been using C# for 4 years along with SQL server. However, today I have to do small application using VB.Net to search some users based on their departments
This is the first time that I am trying to do something in Active directory (and this is the first time I ever seen the Active directory). I always write database queries and I have no idea how to do query on Active directory How to search the employees based on deparments?
[Code]...
have build some code which goes through the datasource finding records on what a user types, basically if the user types 'P' in the combobox it finds all records from FieldName with 'P' and if you type 'Portugal' it finds all records from the FieldName with 'Portugal, it all narrows down the search list say if there are to entries which match 'Portugal' the combox would only have to items in. The problem i am have is that when i bound the datasource back to the combobox every letter you type stays at Postion 0 of the combobox and doesn't move to the end of the letter as normally the combo works, does any one now how to get arround this problem.
At the moment i call my combobox search code from the keypress event of the combobox.This code works fine with recordsets in msaccess combobox but i cannot get it to work with the datasource of the combobox in vb.net Heres the code from the combobox keypress event:
Private Sub ComboBox1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles ComboSearch.KeyPress
Dim keyascii As Integer = AscW(e.KeyChar)
PhoneBookComboSearch(keyascii)
End Sub
Below is the code at the end of my keypress event send the datasource back to the combobox.
Dim adapter As New SqlClient.SqlDataAdapter(strSQL, conn)
Dim dt As New DataTable("MyTable")
Dim ds As New DataSet
[code]....
I want to build an application using VB, that is essentially an information system.The operation of this system would be as follows:1. User can select one of several buttons, each button being a different topic.2. When a button is selected, information about that topic appears on the right hand side of the form.3. The system allows information to be added by a user So, for example, if a user clicked on the button named 'Banana', information about the banana would appear on the form, where the user could read this info, scroll down etc.I would also like the user to be able to search a specific word like 'apple' and for information on the apple to appear.How could I implement this? I don't know how I would store paragraphs of information, and then search for it based on a keyword.
View 1 Repliesi want to ask that how i can open a search page in my vb.net webbrowser with a separate textbox in a tool bar separate from the url text box
View 2 RepliesWith writting a program that demotrates Binary Search Tree operation(insert, delete, and search)in VB.N NET?
View 1 RepliesI have a datagridview with 2 columns, 1 is Batch_Number and another is Existing_Stock, there is about 6000 rows.My question is, I want to be able to write in a TextBox and hit a Search Button to search the Batch_Number column and filter out or highlight the row with the matching number to see the Existing_Stock
View 9 RepliesHow 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'm using SQL as a database in VB 2010, I already add a table to my form as a datagrid view but I don't know how to add buttons for filtering, deleting and adding things in my table, for example I want to have one button on my form call it search button to search in table names or Phone Numbers. how can I do that and where shall I write the code?
View 3 RepliesI have a datagrid control with a list of names that it retrieves from a MySql database. I can search through them until i have one result. I want to be able to Display a groupbox control when the number of results is equal to 1. Also, in the groupbox i have a button that when clicked will delete this user from the server and their information from the mysql table called "employee". when the user is deleted i'll display a confirmation message in a messagebox, and reload the table with the updated list. so far the only two problems i have are showing the groupbox when the results are equal to 1 and deleting the user from the sql server based on the name of the search result
Private Sub TextBox1_KeyUp(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles TextBox1.KeyUp
'Search Function.
[code].....
when you want to use the search engine and when mouse cursor move in textbox search you'll see a small word ("Search") or ("Enter your Search term")
[Code]...
Im having a problem in my search..
I have a listbox named listbox1 then a button beside a textbox for searching records inserted inside
the listbox..
but when I dont type anything, the listview items gone..,what is the best way to solve this?
what I want to do is when i type text in the text button it will find a match in the items of the list view, I have already search I found one close solution to my problem but i have a hard time applying it in my codes.
heres my codes:
Private Sub GetStudents()
Dim students As List(Of Students)
students = StudentBAL.GetStudents()
[Code]....
I am building a tool for my team at work to search a XML file for a particular item and return back the nodes associated with it. I have searched the web to no abounds and was wondering if someone would mind letting me know what I am missing.
Here is my XML:
Code:
Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
<?xml version="1.0" encoding="utf-8"?>
<ServiceConfiguration>
[code]....
i have a combobox all names are displayed i want to search by first letter..if i type n in combobox then names starting from n should be displayed in that combobox...how can i do that?i have my code to display all names from database.
[Code]...
changing the way the site search is done from just search a phrase as one string to searching a phrase "as multiple words" search. For example, if I search "cute puppy" right now, it will search it for "cute puppy" as phrase and won't match just "cute" and "puppy". The way the search is implemented is by passing a search phrase to a Stored Procedure in SQL Server.So now, I need to change to site search so when "cute puppy" is searched, it will search two words.... "cute" and "puppy" instead of just "cute puppy". Below is how the store procedure is implemented
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
[code].....
I'm creating a search function to search through a binary file and find a record based on the users input. Surprisingly, that isn't the problem! The problem I'm having is that as part of this I'm using a procedure to display results in text boxes, and I'm getting the error "Too many arguments to private sub display customer"I've encountered this error before, but never really knew what it was... Here is my code.
Private Sub btnSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearch.Click
FilenameCust = "F:\College\CustomersFile.bin"
[code].....
I have a MS access database connected to a VB2008 developed software.
I want to make a search button to search through all the tables in the database.
how can I do this?
I want to link a field in table one to a field in table 2 in the database so that they are the same ( whenever I change what is in table 1 table 2 changes to the same automaticaly )