I 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 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 am trying to filter the results of a datagridviw using the bindingsource.filter method.
Dim filters(2) As String
...
If Me.txtPartIDFilter.Text = "" Then
[code]....
The issue is in the last line. ID_Part is an Int64 data type filters(0) is a string so the system returns a "Can't perform 'Like' operation on System.Int64 and System.String" error message.As you can see I tried converting the data type, but that failed since it is encased in String.Format()- it's going to be a string no matter what, I suppose.It's almost 1:00 a.m. so I'm not firing on all cylinders.
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 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.
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'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 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 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
Hi, 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 RepliesUsed the BindingSource. . :: . Filter Property description to verify how filters work.
The example uses the following filter source1.Filter = "artist LIKE 'Dave Matthews'" If I change the filter to source1.Filter = "artist LIKE 'Dave%M%'" by using 2 wildcards I run into a EvaluateException How do I use a filter with more then one wildcard?
need a quick reply looking for code that will filter my datagrid with all the results between 2 dates in 2 datatimepickers. My table is not bound to the database. I'm looking for code that will work when the search button is pressed.
View 3 RepliesI have a data bound datagridview on my form. I need the datagridview to sort by oldest date, and then return only the 150 oldest. The goal is to export the 150 rows with the oldest date to a .csv file and then update the date column to the current date for only those 150.
Here is what I have so far:
Dim appPath As String = Path.GetDirectoryName(Application.ExecutablePath)
Dim tdate As Date
tdate = Today.Date
'sort datelastemailed by oldest to be emailed first
DataGridView1.Sort(DateLastEmailedDataGridViewTextBoxColumn,
[Code] ....
I can get it filter by the column "status" and then sort by "datelastemailed". I can also get it to export only those 150 to the .csv file. My issue is that I need only those 150 to have their date column updated to today's date and then saved to the database. The only way I can see to get that done is to set a max number of rows for my databound datagridview and then loop through each row in the date column. How I can create a filter that limits results?
I'm trying to create a Windows form application which uses a few data grid views to pull data back from a SQL Server database. I've managed to get the data back okay from the tables but what I want to do is filter that data dynamically based on values input by the user from a combo box and a date time picker. Each of the data grids display production data for a machine but the combo box and date time picker will allow the data to be filtered by shift and date respectively - how to I pass the values of these to the SQL query returning the data?
View 4 RepliesI would like to search for a member using a text box. i have connected my vb form to an MS access database.I have the following command so far however i would like to search for the forename or the surname, not just the forebame.
View 2 RepliesI'd like to add a generic search feature to my WinForm application (Visual Studio 2010). I want the users to type in a value (for instance john), and then display a list of any company, contact, or student records that contain the search value in the name[code]...
View 3 RepliesIm creating a filter/search for a datagridview in VB. I have a two comboboxes and one textbox. combobox1 selects a field, combobox 2 selects criteria, textbox is for values. After I select my field and criteria and enter in my value, I hit a Go button and run the following code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Me.TblSpeedStudyBindingSource.Filter = "select * from tblSpeedStudy where " & "'"
[Code].....
I get a syntax error: Missing operand after 'tblSpeedStudy' operator.
I am new to programming and especially VB and I am trying to make a CSV reader where I can filter all of the content with a single search box. Here is the code I used to load my CSV file into a datagrid:
[Code]...
I have a search engine on my ASP.net 4.0 VB site that in which I need to link the search results with their individual pages. I understand that this can be done simply with a submit button after the search textbox but a submit button wouldn't fit next to the search bar on my page, plus it wouldn't look right.
[Code]...
I'm trying to creat a search form so far ive looked EVERY wher with no luck ive been doing this for a week now ands its really ratteling me that i cant do it.
So i want to populate a combo box with data from my database in access and ive been able to do this ill show the code below, but then i want to be able to click someones name for example "Christopher" and once i click "christopher" i want the textbox's on the form to be filled with the correct information eg address age phone number[code]...
I'm using visual studio 2010 and sql server 2005 to store my data. I'm creating a system that will allow me to find/search for records that are stored within the database. Thing is, i have 2 separate forms for this - one is the find/search page which allows you to enter in as many fields as you want (the more you enter, the more efficient the search is) and the second one is the find/search results page which will show the results from the search.
I'm not using a datagrid as i've already created these forms myself. I'm on a tight schedule because i've spent so much time already trying to get this to work. Do i need to create another dataset and tableadapter and bind the text boxes? how will i code the find/search button so the search will be carried out and the results will appear in the other form?
i'm working with a sql (2005) database and using visual studio 2010. I've created a system where one of the forms is a find/search form. A user can enter in for example, a customerID and once they click on "find/search" the customerID will be searched in the database and if found, all relevant information about the customer will be retrieved and displayed in another form (find/search results page). I realise that this can be done using an SQL statement like follows
searchStr = "SELECT * FROM Customer WHERE CustomerID LIKE CIDTextBox.Text%"
What i'm unsure about is how to execute this SQL statement once the "find/search" button has been clicked and how to display the founded results in another form.
Here is a part of the code:
Try
Dim allelements As HtmlElementCollection = WebBrowser1.Document.All
For Each webpageelement As HtmlElement In allelements
Dim Name As String = webpageelement.GetAttribute("Name")
[code].....
I let the program search in the "element" parts of the html code,now the last ting I need to do is: I need to get the ID number of every part of the search results.
I would like to have an option to pin the window that contains search results. Currently our application has a search for for instance sales order. Then, when the end user opens a sales order, the search screen is closed, and the sales order is opened for view or edit. However, the users is complaining (with good reason) that they want an option to keep the search window open. Thus, something like a push pin/thumbnail that I can test the state before I open the sale order. If it is pinned, then leave the screen open. If not, close the search screen. I've seen a couple of 3rd party controls like this, but we like to stick to built in/native components only.
View 4 RepliesJust when I was thinking that I had Linq To Xml sussed I'm faced with yet another error! I think if I was to understand the linq search process in general better I might have more success, so any good links regarding that are also welcome. To my problem however; using the code below:
[Code]...
I'm trying to make a form where the user enters a customers account info and then saves it to a file. the user should then be able to search for a customer by their last name and when it is found it display the customers info[code]...
View 6 RepliesI (think I) want to develop a custom control for my program in VB .net where I type into a textbox and simple search results will then be displayed underneath it (from a predefined set of items). Like auto suggest in google search.I believe the combobox does something similar to this but I think it only works on prefixes.At the moment I have a separate search form from which I use to filter a lot of possibilities and then use drag-and-drop to get the desired item into a TextBox.So ideally I want to combine this with a TextBox into which one can start typing at which point some results will be displayed and a user can select the item they want. (Say, an item from a list of products)
View 1 RepliesHow do I search and filter records in the database?Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
View 4 RepliesI want to enter records into an sql database but before i do so i would like to load data from the sql database to a dataset and test if the record i want to enter is already in the database. if yes it does not add the record - preventing duplicated records...for examplename | grade | subjectleo | 7A | mathsi knw how to load the database to a dataset but cant rap my mind around the test to see if the record is already there..
View 11 Replies