i have table contain two column id and word .word column may contain one word or two or three ex ( computer , computer software , computer software computer )i want search the text if it contain any word in that table .
View 2 RepliesI want a word search i doing the search like this , but it is giving character wherever there is in the string,if i give two character like ok it is searching for a full string where ever Ok is there select * from table1 where textfield like '%word%' this query would match word but also wordabc how can i make it aware of delimitions
View 3 RepliesI need to search some words or text in word document through programming.
View 1 RepliesI´m currently programming a web search application in ASP.Net and having problem with full text searching. My requirements are:
1. Save a byte array from SQL server to word document as a temp file in a server side?
2. How to highlight the string I am currently searching in the Word document and return to the user the sentence with the highlighted string (like on Bing or any other search engines)? Is it possible to fullfill this requirement with full-text search integrated in SQL Server 2008?
I am trying to search a list box by adding a text box next to it.
in the textbox_textchanged I added below code
'Retrieve the item's listindex
Dim i
As Integer = List1.FindString(Text1.Text)
'highligting the matched ones
List1.SelectedIndex = i
But I am getting Below error
Error 1 'FindString' is not a member of 'System.Web.UI.WebControls.ListBox'
I'm building a small website using ASP.net/C# and I wanted to know how to implement a simple search feature using a text box and a dropdown.
The datasource is a products table and in the text box I enter the product's name and in the dropdown are the categories. (I have managed to populate the dropdown with the available categories already)
It must follow these conditions:
If both text box and dropdown are blank all products must be listed;
If a category is chosen all products from that category must be listed;
If only text is filled, all products that match are shown;
How i can make the normal search string to sql server full text search parse, because when we are user enyer search text "how to run windows schedule in C#", in database we have article to to this, but data not returning and sometime is say error in key word and etc.
View 1 RepliesI have a form where i want to view all columns from a table.I have a textbox and differeent radio button having values of each column.On click of button.I want to view all the columns as per selected row/rows from value given
View 1 Replieshow to do a search using a Full Text Search Catalog. I would also like to have the results on the page highlighted?
View 1 RepliesI am using SQL Server 2008 and Full Text search.
Its working fine for PDF / doc files but not working for .JPG files.
Basically i have some document scanned and stored it in varbinnary datatype in DB.
I am able to search for .doc /.xml /.pdf files .. but not able to search .jpg.
also i am not getting ".jgp" extension in result of following query
SELECT document_type, version, manufacturer
FROM sys.fulltext_document_types order by document_type
I wanted to a window to pop up when the user clicks on an image. In the pop window, i want to display a text box to search and a button to submit the search. Also on the same pop up, i want to use a radiobutton list to give the option of choosing to search by first name or last name.on searching, i want to display a list of employee names matching the search and give a radio button next to each of them to select the record. On selection, the user will click an OK button below the records. On clicking OK, the pop up window should close and the employee id of the employee selected should be visible in the text box next to the image.Does anyone have an idea of how to do this, because i am not too sure that i have explained it properly.
View 5 Repliesi want to store a word documents (.doc) in the database and i need to provide search over a collection of Word documents and highlight the words too.
I m using VS2005 --> ASP.NET, C#.NET, SQL Server.
I am not that good in SQL syntax and need some help. I am trying to create some search functionality for my website. Basically it just has to search for product names. Now I have a simple statement like SELECT * FROM Products WHERE ProductName LIKE '%' + @ProdName + '%' This statement does not fit to my requirements.I have 2 issues:
1. Assuming someone searches for "blocks". The result that I get is product names with the word "blocks" in it, however I would also like to display results with product names the have the word "block" in it i.e without the "s" In short I want to match the possible product names from the keyword e.g block, blocks, blocking etc I dont want it to search the exact name but may be just partially. If the keyword contains the exact word from the product name, well and good but it should also display the products where the keyword is partially matching.
2. Assuming someone searches for the words "concrete blocks". I get the result with products that have the words "concrete blocks" only. But I would also like to get the result with say "Louvre Blocks" in the total results displayed.So can someone kindly help me sort out my issues. Sorry if im repeating words but im just trying to make an understandable point.
I've a problem with the listsearch extender.
My dropdownlist have serveral values with:
Companyname ----- City
Firstname ------- Lastname
The extender now search in the first word but is it possible to search also in the second word?
I need to have search form in my web app . I want visitor input text in textbox control and when he click on Search button it check DB table for his input text.
I dould like if user input "Windows 7" and I have the sentence in DB Records as "My be Some Windows Generation .." it list this record.
in other word I want to search for any word that users entered in DB.
Could any one tell me efficient way instead of split input text to words and then execute search query per word?
I have text box ...If i type in textbox like
"C,C++,ASP.net,4-5Years" then every word should be checked by database whether that name exits or not in table field of the database..It should be check separately of every word ..It just like Search engin...How can i do in asp.net
How to search a word for spelling correction in c#. Below is the code which i used,
Its not working, for words less than three 5 letters.
public string _dictionary(string word)
{
string[] wordArray = new string[125896];
string reading;
int nwords = 0;
FileStream fs = new FileStream(@"C:Documents and Settingsharsha.limayeDesktopspelling.txt", FileMode.Open, FileAccess.Read);
StreamReader s = new StreamReader(fs);
while((reading=s.ReadLine())!=null)
{
if (reading == word)
return word;
char[] TextboxPos=reading.ToLower().ToCharArray();
char[] readingPos = new char[20];
readingPos = TextBox1.Text.ToLower().ToCharArray();
if (TextboxPos[0] == readingPos[0])
{
if(readingPos.Length<=5)
{
if (TextboxPos[1] == readingPos[1] && TextboxPos.Length-1 == readingPos.Length-1)//[readingPos.Length])// && TextboxPos[TextboxPos.Length-1] == readingPos[readingPos.Length - 1])
{
// return reading;
TextBox1.Text = "Search for " + reading + " instead of " + TextBox1.Text;
break;
}
}
else
{
if (TextboxPos[1] == readingPos[1]&& TextboxPos[2] == readingPos[2] && TextboxPos.Length == readingPos.Length && TextboxPos.Length-1 == readingPos.Length - 1&& TextboxPos.Length-2 == readingPos.Length - 2)
{
//return reading;
TextBox1.Text = "Search for" + reading + "instead of" + TextBox1.Text;
break;
}
}
}
wordArray[nwords] = reading;
nwords++;
}
fs.Close();
s.Close();
return reading;
I am developing the Home page of a Client. Apart from various things on this home page I have a text box and search button. Having said that, I have a database in which I have almost 12 tables with varying number of columns. Now my question is,Is there anyway to search a word typed by a user in the textbox to search it in all the tables(all columns) of the database.
View 2 RepliesHow can I search a word in all the columns of a table?
View 4 Replieshow can i separate words in db column separated by enter key. I am entering data in a multi line textbox directly to db, and i want to search a word in that column. Since the words are seperated by enter key, how can i separate the words to search. If i use like i can't search the exact word is there..
View 2 RepliesI have a textbox and what I would like to implement is basically a situation similar to what you have in google when you type in a word. In otherwords,
in the textbox when you type in J, it should generate a list of names that starts with O in alphabetical order, then next when you type in o, so that now you have Jo, it should generate a list of names instead that now starts with Jo in alphabetical order, then again when you type in h, it should generate a list of names that starts with Joh and so on.
I can easily create a search that will allow a user to input a single word (or a portion of a single word) into a text box that will search a database column.
But what I want is for the user to be able to type two or three words into the textbox and produce results where just one of the words have to match the contents of the columns cell.
I don't need to be able to do a multi column or table search, and I'm using C# and MS Access.
I imagine this question would have been asked more than a couple of times - but I can't find a decent answer.
How to multiple search in single textbox using autocomplete extender.. or may use an other method.Â
View 1 RepliesI am trying to export a gridview that is returned from a search form. The gridview also has paging enabled. In order to export the records from all pages in the gridview I had to turn off paging and do a databind, but instead of only exporting the search results it exports all the records in the gridview.
How can I only export the records from the search results, but also the make sure the records on the different pages export also?
How to use pattern replacement in the RTF?. For example you can add a placeholder like {USER_FIRST_NAME} in the RTF document. When the user clicks the download button, your application can take the information from the database and replace every instance of {USER_FIRST_NAME} with the data from the database....
View 1 Replies