How can I exclude a common keyword like "a,the,is,or.. etc.." from my search query ? If you do a search in Google or other search engine it says "the" is a very common word, and was not included in your search.Is there a list somewhere that I can get all the common keywords that need to be excluded from the search query?
View 3 RepliesI am creating a search function which searches a database for keywords in a selected field in FilmTable (name of table to be searched)
This is the SQL I am using:
CODE:
It is saying there is an error in the FROM syntax
I wanted to make a that searches a web page(ex: wikipedia.com) for certain keywords from textbox?
View 2 RepliesHow would I make a program that would search through a .txt file, and find certain predetermined keywords. Basically, I have a very simple keylogger on my son's laptop to keep an eye on him. My hope is that I would make a program that would go through the .txt file, and if one of the keywords is found, then I would have the program execute a little something I have cooked up to warn to stop. The only problem is, I do not know how to search through the .txt file.
View 1 RepliesI have a search page, which iam using to search the database fields which holds the technical articles. The fields that iam searching are varchar(max).
Everything is fine..., I want to show the results with the first found instance of searched keywords in bold and some 70 to 100 chars before and after.
I am in the process of creating a program, using Visual Basic Express, for a physics professor who has recently had to rename all 1500 questions for his course. I created a database that has the old names, new names, and the entire contents of each question. The program seemed an easy enough idea, but has proved to be very difficult for me. I am new to programming (this is only my third go at it) and have searched for an answer to my problem for at least 20 hours, and have yet to find anything that will work for what I need.
What I would like is to have a text box in which he can type in a keyword (such as "Sun", "ISS", "Force", etc) and for the program to search throughout the entire "questioncontents" column and pull out any questions that contain those words into the datagrid. As of yet the closest I have gotten is for it to search the first word of the column, which is not very useful since most of them start with "The". I had also thought of creating several keyword columns and then just having it search through those, but I couldn't figure out how to apply the filter to multiple columns.
I'm making a (F1) part for my application. I made a form with a Webbrowser-control and I made several .html files. Now I would like that the users enter a keyword and that they see all the files where that keyword is found in the metatag <keyword>. What is the best (and fastest) way to search for that?
View 6 RepliesI am currently building a search page, which includes a textbox and two drop-down lists, a search button, and a datagrid. If results are found and displayed, I would like a label to display:
(e.g.) "24 results found for 'blue sky clouds' "
...where the integer represents the results count, and the keywords and/or drop-down list selections are included in the string.If no results are found I would like the label to display:(e.g.) "No results were found that match your selection. Please try again"I would also like the label to be invisible until a search occurs.
i got a function that search for database data, is it possible that i make it search the nearest words or keywords? which mean if d name is TEST, n i key in TE then it will show those name wit TEST TESS TSST? [Code]
View 2 RepliesHi, I need to program a simple Web Browser that can search for keywords and store relevant data in another file.I am facing a problem with authentication, mainly cookies and maintaining a session.So I read that Web Browser Control is based on I.E.? So may I know how are cookies and session handled?Do I have to implement them manually or are they stored and retrieved from the same folder as the one used in I.E? If so, if I delete the I.E.'s cache, am I also deleteing the cache of any Web Browser I make using Web Browser Control?
View 2 RepliesDoes DirectCast, ctype, etc., are common function? Why it return type, and how do I used it? Is there others function where I need learn to be dot net expert?
View 3 RepliesI'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].....
Im making a search function for an application and they need to be able to search by any value in the DB in any of the three tables. Im wondering the best wayto about this. 2 of the 3 tables have the same columns while the last one is totally different. Below is what I kinda "thought" itd look like but no.
"SELECT * FROM cases, opencases, staff WHERE Crime ='" & txtsearch.Text.ToString & "'"
I need to query the results the user can search for anyterm and if it matches something in the columns it return it to the user. Im wondering if the best way to go about this is to maybe query all the tables and then put all the matching records in a seperate table and the dgv look at that table or how to exactly go about it.
I am trying to make a simple program that will have three texbox controls and it will have like a paragraph in textbox2 and I want to have key words that I type in TextBox1 and it will match the words from textbox1 and will find a line with the matching words. It will then show that sentence from TextBox2 in TextBox3.
This is what I have so far but cant seen to get it to work:
Dim search As String = txtSearch.Text
If txtMain.Contains(search As System.Windows.Forms.Control) Then
MessageBox.Show("Connection Activated")
End If
I am currently trying to create a search function on a page in VB.NET which will allow me to search a database for a customerID from a textbox called txtSearch and then present it into a datagrid.
So far I can display the customerID's manually by using
SELECT * FROM Customers WHERE CustomerID LIKE 'A%'
but cant figure out how to replace the A with data which will be inputted into the textbox.
im trying to implement a search function to my booking program, wich retrieves data from a SQL database. I have the screan all set up and all the variables at the ready, the only problem is, im not sure how to execute it in a sqlcommand line.
I've got all the fields that are required, such as date, time but i also have two optional options, Room Type and Room Capacity.
How would i write a sqlcommand to search for available rooms that meet the criteria for the room to be booked?
Heres the code i have so far;[code...]
I am trying to do a search function for a listbox and I have the search working but it is case-sensitive. How do you make it non?
For i As Integer = 0 To FrmMain.LstBxMovie.Items.Count - 1
If Not cancelled Then
If FrmMain.LstBxMovie.Items(i).ToString.Contains(sSearchString) Then
[Code].....
I am wondering how you would go about making a search function for a grid in VB.net. Right now, I have it so that the person clicks a button and they see the last 50 records they've looked up. This works fine. I also have a search button that works like this[code]...
View 2 RepliesTools; VB 2008, DGV queries to Access 2003 Objective; A simple find function to search the datagridview for any value. Not a query that filters the dataset. I have been able to make this many times in a simple notepad type project. Although how can i implement this in a DGV?
View 7 RepliesI have a VB .NET String. How can I search that string for a character string and replace it with another string?
For example:
Dim rValue As
String = sproc.ExecuteScalar()
' rValue now has the XML string <indracio fire height=23, width - 6>
/* This is the string that I want to search. Replace the words "indracio fire" with the word "lucion time"
How can I search this string for the words "indracio fire" , and replace with the word "lucion time" ?
how could i build a search function button which will access my database? as the search item match the database , there must be a window pop up to show the searched data from the database.
View 7 RepliesHow to Write Code in Vb.NET For Search Function having three item table?
View 1 RepliesI tried out the video tutorial from Beth Messi about how to create a search. The tutorial teaches us how to do it through query builder in which we just have to type LIKE@fieldname = '%' for each field we wish to appear on a toolstrip. A toolstrip menu will automatically be generated and placed underneath the form bar for us after we click ok.
Now, I would like to know how can I do this with code? I can use a code which will move the auto generated toolstrip into the tabcontrol but when I have more than 1 tabcontrol, that's when I start having problems - the toolstrips are starting to cover up the tabcontrol. I know I can move the datagridview lower but that is going to leave a big space above it.
I am using a datareader for a search function within my vb application.I have no problems with the columns of the database I know the column header of. However after the 7th column the header may change or more columns maybe added, so i want to use a loop to grab the headers of those columns, and add them to a listview - along with the information within the field:
[Code]...
I need help with creating a simple search function for an app im making. It shows recipes of various drinks.I want it like when I press "Search" on the main menu a new form should open containing all I need to search for a drink E.g if I search for "A night of passion" it should look through all the forms and then open the form containing the choosen drink.Could something like this be possible?
View 21 RepliesI've just started developing web applications for the first time. Im developing an ASP.Net Website. Ive started transferring code over from my windows application and found a few errors. In my windows application I had a search function in a form where on click the text in a text box would search the first list box and print any matches in the second list box. [code] In my website an error pops up highlighting the line "words = lstSearch1.Items.Item(a)" and says that the value of the list item cannot be converted to string. How do I go about fixing this or is there a different way of implementing a search function in an Asp.Net website?
View 2 Repliesi am trying to create a search function/filter for a list box basicly when i type a letter or letters into a text box i want the listbox items to be filtered so say i have 5 names in the list box as follows:
[Code]...
On my software , i have a function for search in the list a member . The function have more fields : Girls , Boy , Old , etc ... but the software doesn't work correctly. I want him to search with several conditions, adding AND. Here is the code :
Vb
For Each MemberALister As MemberInfo In _Listemember
If Me.Girl.Checked Then
If MemberALister.Nom.Contains(Me.Genre.Text) Then
[Code]....
How could I build a search function button which will access my database? As the search item match the database, there must be a window pop up to show the searched data from the database.
View 1 RepliesI am writing a program and I have the Read Function all written out. I need to have the write function. I think is I copied and pasted from the Read function I wrote.
I was able to Mass edit This:
Reader.Position = (&H)
NumericUpDown281.Value = Reader.ReadInt16()
Reader.Position = (&H)
NumericUpDown280.Value = Reader.ReadInt16()
Reader.Position = (&H)
[Code] .....
And there is at least 370 NumericUpDown's. Is there any way to search/find/replace all in one instead of typing:
Find what: NumericUpDown320.Value = writer.WriteInt16()
Replace with: writer.WriteInt16(NumericUpDown320.Value)
Each individually?
The write function will only write properly this way:
writer.Position = (&H)
writer.WriteInt16(NumericUpDown66.Value)
And not this way:
writer.Position = (&H)
NumericUpDown319.Value = writer.WriteInt16()