DataSource Controls :: Auto Complete - Get Keywords From Full Text Catalog?
May 30, 2010
This is my first time using autocomplete. I have everything up and running, but I want to return a list of more relevent keywords or phrases from my full text catalog, or the table that I search against. I have no idea where to start as far as my getcompletionlist goes.
So If I type in knee
a list appears
kneepads
here's my getCompletionList
Public Function GetCompletionList(ByVal prefixText As String, ByVal count As Integer) As String()
Dim items As New List(Of String)
Dim myConnectionString As String
myConnectionString = GetSQLConnString()
Dim mySelectQuery As String = "SELECT ShortDescription FROM ProductInfo WHERE FREETEXT(ShortDescription, @prefixText) OR FREETEXT(LongDescription, @prefixText) OR FREETEXT(ProductHTML, @prefixText) OR FREETEXT(PartNumber, @prefixText) ORDER BY RANK()
OVER (Order BY PartNumber, ShortDescription, LongDescription)"
[Code]....
View 2 Replies
Similar Messages:
Nov 26, 2010
how to do a search using a Full Text Search Catalog. I would also like to have the results on the page highlighted?
View 1 Replies
Aug 23, 2012
Code to achieve the autocomplete using json but i need to get the value of the text when the button is clicked.
View 1 Replies
Sep 17, 2010
i would like fetch data from db and bring it on to the text box using auto complete extender i have 2 column--- Emp_name and Emp_id in db. i want to see the name of employee when i type in the letters but when i select it from the selection of names, i would like emp_code to fill in the textbox
View 5 Replies
Feb 26, 2010
I have a longer text and some keywords. I want to highlight these keywords in my text. That is no problem with this code:
private static string HighlightKeywords2(string keywords, string text)
{
// Swap out the ,<space> for pipes and add the braces
Regex r = new Regex(@", ?");
keywords = "(" + r.Replace(keywords, @"|") + ")";
// Get ready to replace the keywords
r = new Regex(keywords, RegexOptions.Singleline | RegexOptions.IgnoreCase);
// Do the replace
return r.Replace(text, new MatchEvaluator(MatchEval2));
}
private static string MatchEval2(Match match)
{
if (match.Groups[1].Success)
{
return "<b>" + match.ToString() + "</b>";
}
return ""; //no match
}
But when the word"tournament" is in the text and the keyword "tour" it becomes <b>tour</b>nament. I want to it to highlight the complete word: <b>tournament</b>.
View 1 Replies
Jun 13, 2010
i have made fulltext index in 4 columns in a table ( 2 ARABIC columns (title,Desc(html) AND ENGLISH(title,Desc(html))it works fine locally when i use contains function in search but in sever arabic search doesnt work well .
View 2 Replies
Feb 16, 2010
I am using ContainsTable() to perform a full text search on a field (of type varbinary()) and am I wondering if there is a good way to return an excerpt of text around at least one location where the keyword matched the text in the field.Example:User searches for "computer science".The following sentence exists in the varbinary() field: "This book is about computer science and other IT related fields."I would like to return an excerpt around the words "computer science", something like: "...book is aboutcomputer science and other IT..."
View 1 Replies
Feb 13, 2010
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 Replies
Jan 27, 2010
I would like to do an attachment on my database but I lost the full-text catalogs file. Sql server won't let me attach the database without it. What do I need to do to overcome this issue? Is there a way to tell Sql Server to skip the missing catalogs? If not, how do I generate another full-text catalogs file to replace to lost one?
View 3 Replies
May 28, 2010
I'm new with all stored procs - but I have a very basic Full Text Search going on...I created a stored proc, and linked it up to my application using Linq to SQL. If I use Linq to SQL to call the stored proc without any parameters (hard coded search string) i get results back, as soon as I add a parameter - the result set is 0 for some reason.
The funny thing is that I run Profiler and execute both queries its trying to do - and it looks identical
Here is the working parameterless query:
[Code]....
and according to Profile this is what it looks like when its called as a stored proc
[Code]....
I get 2 results as expected.
Here is the NON-working stored proc that takes in 1 string parameter
[Code]....
and here is the query that gets called when profiling
[Code]....
declare @p4 int
View 3 Replies
Feb 7, 2010
I have a website which uses full text search. It was working fine on my web host. LAst month, I changed hosting to godaddy.com. They dont support full text search and now my website is not working properly. what change should i make in my stored procedures that they work same as they work with full text. what is alternative to full text search. I tried using LIKE but it doesnt work same way.
View 1 Replies
Jul 2, 2010
I am actually using 2 type of queries in my website e.g
These Queries are from my stored procedures
SELECT * FROM TblName WHERE FREETEXT(ColumnName, @parameter)
AND
SELECT * FROM TblName WHERE CONTAINS((Column1, Column2), @parameter))
I have enabled Full Text Indexing on my tables both local and on my hosting company MS SQL Server.
The above queries are working fine on my local database and return results but these queries return nothing when i try to run them on hosting company MS SQL Server.
I have identical data on both MS SQL Servers and both servers are 2008.
View 2 Replies
Mar 30, 2010
I have installed sql server 2008 express along with visual web developer 2008 express (latest sp1) using web installer now I downloaded this file:
'Microsoft® SQL Server® 2008 Express with Advanced Services' from here: [URL] but when I run the installer and choose add new features to existing instance of sql server I get no full text search feature option in the list, There are only a few options that are selected and greyed out (because they are installed previously) in the list of available features. Why I don't have full text search feature in the list and how to find and install it? (mine is the 64bit version)
View 2 Replies
Jan 12, 2011
I am having with the a full text index I am developing for a product catalog. It does all work to a degree I am just seeing some strange things happening.
From the database side I have a Products table that is being indexed on both the PartNumber and Description columns because I would like the users to be able to search either or using the search function.
Problem 1:
whenever I use multiple words in the search I don't always get the results I am looking for, this happens most notably when I am attempting to say put in a full part number (which for in this case would look like "I 10-9.2")
Problem 2:
I am not 100% sure that this is the most efficient way of completing what I am attempting to accomplish here since I have 2 columns that I need to perform the search on
Here is an excerpt from the click even when the user clicks the search button on the page:
[Code]....
And here is the search functions called from the click event to firstly check if there are any results and the second to display the results in a custom gridview:
[Code]....
View 1 Replies
May 9, 2010
I'm implementing an AJAX autocomplete feature where the user types into a textbox and the webpage generates suggestions (pretty much like how Google's search box works). I got the AJAX part to work right, but for some reason, my database query does not.Let's say I want to find "Chicago". Using the following query does not find it.SELECT TOP 10 citynames FROM city WHERE CONTAINS(citynames, 'chi*')But using this query does.SELECT TOP 10 citynames FROM city WHERE CONTAINS(citynames, 'chicago')By the way, "citynames" is an ntext type field and I'm using SQL SERVER 2008.Does anyone know why my first query can't find "Chicago"? I've been staring at that query for hours, yet can't find anything wrong with it. Something wrong with the database maybe?
View 2 Replies
Mar 11, 2010
I created a simple search form which populates a gridview from sql server. I use 'contains' on a varchar(max) field which has a full text index. I find if I do a search for "Mexico Argentina", I get multiple results, which is good.One thing my sql server stored procedure is doing is inserting the word 'AND' between words. I do this because I want all words to be found. So if the user inputs "Mexico Argentina", I am converting that to "Mexico AND Argentina"But if I have even one 'noise word' in the search string, I get no results at all. For instance, there might be a sentence in my database table saying "I prefer Mexico to Argentina" but if I put that sentence in, I get no results at all. The database is seeing my converted string:I AND prefer AND Mexico AND to AND ArgentinaAnd finds nothing.I also have another form, which does a more advanced search that allows 'exact phrase'. If the user chooses 'exact phrase', then I don't insert AND anywhere. Instead, I surround his phrase with 4 apostrophes - 2 before the phrase, and 2 after.So now the database sees:' ' I prefer Mexico to Argentina ' ' (I've put a space between apostrophes here to make it clearer to view.Now I not only get no results, I get an error message.
View 1 Replies
May 19, 2010
I am working on a website hosted with GoDaddy, SQL Server 2005. I have a table in my SQL Server database with a full-text index. On my website, a user can type in search terms and the terms are then passed to a stored procedure in the database which performs the search. The first search takes about 45 seconds to get results. Subsequent searches return results immediately. I found a description of this problem in a Microsoft knowledgebase article:http://support.microsoft.com/kb/915850/en-usGoDaddy tech support says I need to purchase a dedicated server to make the changes suggested in this article.Surely there is some other solution. Does anyone know how to avoid this delay without changing the server configuration?
View 1 Replies
Apr 25, 2010
I have created SQL CLR database project in 2010. when I try to deploy it to sql server 2008, it gives me error like Msg 6528, Level 16, State 1, Procedure UmAlQuraConverter, Line 2 Assembly 'SqlClassLibrary' was not found in the SQL catalog of database so, how to add SqlClasslibrary to sql catalog
View 1 Replies
Jan 27, 2010
I 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 Replies
Jan 25, 2010
I know about the benefits that full text indexing provides when indexing columns that contain LOB such as varbinary(max), varchar(max) etc. But is there an overhead involved when using full-text indexing and full text search on columns that contain a small amount of data, such as varchar(50)?
View 3 Replies
Sep 7, 2010
I tried Restart the service I tried restart the server But the number of row affected is still zero :(
View 2 Replies
Mar 29, 2010
I 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
View 1 Replies
May 7, 2015
I am unable to get it done as i have huge data in my table which is spoiling the standard look and feel of grid view..
if (row.RowType == DataControlRowType.DataRow) {
ViewState["description"] = e.Row.Cells[10].Text;
if (e.Row.Cells[10].Text.Length >= 25){
e.Row.Cells[10].Text = e.Row.Cells[10].Text.Substring(0, 30) + "...";
e.Row.Cells[10].ToolTip = ViewState["description"].ToString();} }
View 1 Replies
Mar 14, 2010
I'm trying to apply this example to my website.They use SQLServer in this link[URL]string sql = "Select * from Country Where Country_Name like @prefixText";i have to change the last part( like @prefix ) so that it wont give any errors for MySQL
View 12 Replies
Jan 20, 2010
I want to use auto complete in a textbox to display the item. I have a vague idea to do that. But the requirement need the company logos with the names in the auto complete.
View 1 Replies
