Implement A Fulltext Search For A MVC Application?
Sep 29, 2010
I've built an ASP.NET MVC application with MVC 2.0 and Fluent NHibernate (hided behind repositories for some reasons). The application represents a quite complex domain with some different objects like users, messages, comments, files and appointments.
Now I want to implement a fulltext search which is enabling the user to find easily all types of content by simply entering a search phrase. When handling all that types of different objects in the application seperately, I now have to put them "together" for the search. That means the user makes no distinction between the different types, he just enters "xyz" and wants to get results in a list, comments mixed up with messages etc.
Option 1 is to create a search service which fetches the search result from the different repositories and prepares the combined output (sorting, paging etc.). But that's really, really expensive when the data behind grows (and it will grow).
So I am looking for an alternative solution. Currently I am working with SQL Server 2008. What I have found is lucene.net [URL], but I didn't invest much time yet.
View 3 Replies
Similar Messages:
Mar 1, 2011
Currently I am working on an MVC 2 project and we are trying to implement fulltext search. Originally we were going to take advantage of SQL Server fulltext search capabilities but we are aware that the project will be moving to Azure within 6 months.I understand that SQL Azure does not support fulltext search currently. What are the possible solutions to implement full text search in Azure? The solutions we've come across seem to point to Azure Library for Lucene.Net but I want to make sure we aren't overlooking any better solutions.
View 1 Replies
Mar 29, 2011
I have a table in SQL Server with structure:
Students
(
StudentId bigint,
FullName nvarchar(100),
DegreeId smallint,
Articel nvarchar(max)
)
i have created a full text index and enabled it for "students" table.
in my asp.net page ,users type words and i call a stored proc filter students using these words.
Create Procedure GetStudents(@Article nvarchar(200)=typed words)
AS
BEGIN
SET NOCOUNT ON
SELECT StudentId,FullName,DegreeId,Article
FROM Students
WHERE WHERE FREETEXT(Article,'''+ @Article+''')
END
The search works fine ,now i need to highlight(yellow background)the "articles" of returned stuents in my asp.net page(by jquery,or asp.net).
View 3 Replies
Apr 1, 2010
I am a noob in ASP.NET and building a website currently... I want the site to have a search feature.. How can I add this to my site? Is there a good tutorial out there ?
View 5 Replies
May 28, 2010
i have some text boxs in a page and in the same page there will be a table 'grid' like for holding the search result.When the user start editing and of the textbox above, the search must start by sending all textboxs values to the server 'ajax', and get back with the results to fill the below grid.
Notes:This grid should support paging, sorting by clicking on headers and it will contains some controls beside the results such as checkboxs for boolean values and links for opening details in another page.
I know many ways to do this some of them are:1- updatepanel around all of these controls and thats it "fast dirty solution"
2- send the search criteria using ajax request using JQuery post function for example and get back the JSON result, and using a template will draw the grid "clean but will take time to finish and will be harder to edit later".
3- ....My question is:What do you think will be the best choice to implement this scenario? because i face this scenario too much, and want to know which implementation will be better regarding performance, optimization, and time to finish.
View 3 Replies
Jan 13, 2010
I am trying to get a clue on how to implement a search page using asp.Net mvc. My search page has several fieds such as drop down list and Date. The end result should be display in a table/GridView. How should I apporch this issue and send the controller the search request paramters and then how should I return the query result to the view??
View 3 Replies
Apr 8, 2012
How to implement search engine Within a Partucular website that I supposed to build using asp .net C#.......
View 1 Replies
Jun 7, 2010
i had a situation in which i want to implement a search within my website, to search information of my wbsite only and giving the list of pages which contain the information requested for seach.
View 5 Replies
Nov 3, 2010
I did lot of R & D to implement website internal search in asp.net.
I have found a good article in code project
[URL]
It has some limitations
Search with special characters is not working.
Pdf and word documents are not searching.
Not able to high light the searched text.
If I am implementing this in master page then child title is not displayed in result page.
Requirement:
I need to implement search result should be like this [URL] In description the search text must be highlighted.
Note: I need to implement this with coding not any 3rd party tool (I know lots of 3rd party website which do free hosting but they will post there adds and logo). Moreover i dont want to use any database for this internal searching.
View 2 Replies
Oct 21, 2010
I have two tables:
Orders
OrderProducts - An order can have 1 to many orderProducts records associated with it.
What I am trying to do (unsuccessfully) is to implement a GridView search using a LinqDataSource wherein the search returns Order results where any of the OrderProduct.Manufacturer columns contain a search query. I was hoping the following would work, however it seems lambda expressions do not work within a Where clause of a LinqDataSource (in VB):
<asp:LinqDataSource ID="dsOrders" runat="server" ContextTypeName="myDataContext" TableName="orders"
Where="orderProducts.Any(Function(op) op.Manufacturer.Contains(@searchTerm))">
<WhereParameters>
<asp:ControlParameter Name="searchTerm" ControlID="txtSearchTerm" DefaultValue="" />
</WhereParameters>
</asp:LinqDataSource>
In C# it would look like:
<asp:LinqDataSource ID="dsOrders" runat="server" ContextTypeName="myDataContext" TableName="orders"
Where="orderProducts.Any(op => op.Manufacturer.Contains(@searchTerm))">
<WhereParameters>
<asp:ControlParameter Name="searchTerm" ControlID="txtSearchTerm" DefaultValue="" />
</WhereParameters>
</asp:LinqDataSource>
The error I am getting is:
No property or field 'op' exists in type 'orderProduct' Any clues as to how to get this working within the LinqDataSource definition, or will I have to handle and set up a custom OnSelecting event?
View 1 Replies
Jun 5, 2010
implementing yahoo search for my website. A link to sample code can be very helpfull. My website hosts on ASP.Net 2.o plan
View 1 Replies
Oct 9, 2010
Iam working on internal Website search as user can search any thing in the website
Now i dont have idea from where i can get start ?? how search will work .it should be whole database search or pages only???
View 6 Replies
Feb 7, 2010
How to implement search features in ASP.NET MVC applications
I have a program designed using Asp.net MVC and c#
I want a simple way to implement a search for the data that I have using the models and Controllers
I did it by doing a script in a page itself but I want it by using Models for example I have a table with ( Mean, STD, Parameter , etc )
I want to put these in a dropdownlist and there is a text box to write the value also, there is a flexibility in adding more than one dropdownlist <<< not important
View 1 Replies
May 7, 2015
how to implement search in dropdown list.
View 1 Replies
Aug 18, 2010
I want to display records based on the Prod ID entered by the user in the text box. Where can I find a tutorial to do that?
I can't find a simple one. I am completely new to .NET, and hardly know anything about grid view, SQL connections and stuff.
I need a step-by-step tutorial that explains how to do it. I want to learn about all of this.
Oh, BTW, I did establish an SQL connection and was successful in displaying my table on the web page. I want to learn how to search from that table and display records.
View 1 Replies
Dec 23, 2010
Anyone can help providing some code/suggestion on how to implement Search and displaying results on same page using MVC and simple way to implement paging with Ajax.
Below are the search parameters(search Page looks like below) i need to pass to db to get results. We are using MVC2 with entity framework.
Search Criteria- Last Name Course Name Status
View 6 Replies
Feb 3, 2011
I want to implement full text search in C# using linq.
View 1 Replies
Nov 26, 2012
I want to create a seach box as used in this website for searching topics and other information for my asp.net website.
How may I implement this.
I do not want to use google custom search.
View 1 Replies
Jul 17, 2015
I have a traffic rss feed which I want to filter when a user enters some text in the text box. For example, if the user enters “Leicester” in the search box then only data containing “Leicester” in the “Tile” OR “Desscription” with be displayed.
<asp:DataList ID="dl_traffic" runat="server" DataSourceID="Xml_1" style="font-family:Arial;font-size:14px;margin-left:2px">
<FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
<SelectedItemStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
<AlternatingItemStyle BackColor="White" />
<ItemStyle BackColor="#EFF3FB" ForeColor="Black" />
<HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
<ItemTemplate>
[CODE]
View 1 Replies
Mar 19, 2011
how to implement Search and displaying results on same page using ASP.net webform and simple way to implement paging with Ajax. The top of the page should have the search criteria and once button clicked, it should display the result below with checkbox so that user can select and delete any / all of the search result.
View 4 Replies
Apr 27, 2016
How I can convert web page (CS.aspx) to ASCX file.
Link is below.
[URL]
View 1 Replies
Feb 4, 2014
How to do image search like google...
View 1 Replies
Sep 16, 2010
I have a search textbox in the web page. When the user presses enter key after entering text in that textbox then the search function should get executed. How to do this?
View 5 Replies
Jan 12, 2010
Now i'm currently trying to code a basic website as a project and i've run into problems regarding a search video function. having searched through the forum i still could not find a solution.What i intend to do is to have a video search web service in my website, perhaps something like this:http://www.google.com/uds/solutions/...rch/index.html. however from my limited understanding the codes provided is unable to work with VS2005? Is there a basic template that i could follow and implement for a video search function for youtubes video?
View 8 Replies
Sep 30, 2010
I'm trying to implement the google instant like search in my project but I dont have any ideas where to start it off.. Something like when I enter a character or start typing at the textbox, the list box will be populated every character I type.. anyone who can give me a heads up?
View 3 Replies
