I wants to implement free text search utility for my web project,
to implement greate search utility for free text.
Also i have some knowledge of SQL SERVER 2005's FULL Text utility.
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 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 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 am looking for Backup and Restore . mdf file utility. Is there any opensource application/code available?
View 12 RepliesI would like to create a webpage that collects a users search criteria. Then when they click a button, send the parameters to the Windows Explorer Search utility and run it. Can this be done? If so, how? I am using asp.net to create my webpages.
View 1 RepliesI'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
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 Repliesload bcp utility from C# code? I need to do that for .NET 1.1.
I need to move data from a flat file to a database, I was suggested to use BCP. Are there any other options in .NET 1.1?
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.
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)
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]....
I am using xsd /c book.xsd to generate the a cs file. THe default cs file will be book.cs. I am wondering what swtich I can add so that i can name the generated cs file as document.cs instead of the default one. I attached the book/xsd and book.cs file, I am wondering why it generated two partial class? Should i name the generated file to match one of the partial class like BookForm.cs?
book.xsd:
[Code]....
Book.cs:
[Code]....
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 RepliesI 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 Repliesi have contineous data stream and saving in database. database size is growing. as per out data retention policy we have to archieve data and only keep last 6 month data on server.
if archieve data is required in future in current/live database so how do i bring it back.
I'm looking for a free ASP.NET 2.0 ListBox control that supports display of items in two columns. It also needs to support selecting multiple items.
I really prefer not to have to use a monospaced font and mess with formatting my ListBox items into columns.
what free website can i upload my asp.net pages for testing?
View 4 RepliesI need to take an HTML page in Arabic and convert it to a PDF. itextsharp doesn't work. Here is some example HTML with Arabic in it.
[code]....
i use itextsharp to convert this content which is stored in DB to pdf file to be downloaded to the user
find a free 3-Tier Code Generator for asp.net .
View 2 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 tried Restart the service I tried restart the server But the number of row affected is still zero :(
View 2 RepliesI am using FTB on my aspx page. is there any way I can have Toggle Full screen feature in FTB, is this feature availble in FTB? it is available on TinyMCE, but I don't want to switch to TinyMCE since I am already using FTB in most of the pages in my application.
View 1 RepliesI have SQL Server Standard 2008 installed on my machine, alongside Visual Studio 2008.
My current hosting provider (not a huge fan) requires me to access my db's remotely via SQL Server Management Utility. To date, I've been doing it by connecting remotely in VS2008. Their troubleshooting documentation/steps, though, are for the SQL Server Management Express 2008, and i'm having a lot of connectivity issues with them.
I followed the steps here: [URL] to "add additional features to an existing installation" - but when I did so, the setup wizard indicated that the Management Tools-Basic were already installed.
A year ago I did some design work for an ASP.NET 3.5 website that uses an SQL Server database hosted by my ISP. This website is only really active around this time of year for an annual photographic competition. Last year, I installed SQL Server 2008 Development Edition together with a trial copy of VS2008 Professional and the trial period lasted long enough for me to do what was needed back then. My intention was to buy VS2008 Pro around now in time for our current competition. In the meantime, I have reverted to
using VWD 2008 Express.
However, that purchase decision has been put on hold while I check out the economic and practical impact of waiting until VS2010 becomes available (in late March?). I'm guessing that it would be much cheaper to wait for VS2010 rather than buy VS2008 and then upgrade. Money is short because we are a non-profit organisation.
The practical issue is that I need access to SSIS Designer to update a DTSX file I created last year and I need that now. March is too late. The SSIS Designer is part of Business Intelligence Development Studio (BIDS) but BIDS is no longer available to me because it appears to have been provided with the trial copy of VS2008 rather than with SQL Server 2008 Development Edition. When I try to run BIDS I am told the evaluation period has ended. Is there is any way for me to gain free access to BIDS 2008 while I wait to buy VS2010?