DataSource Controls :: Implementing "Google - Esque" Search Functionality In App
May 31, 2010
I've started some preliminary work on getting a Google-like search functionality into my app - ive never done anything like this before so i thought id be a good idea to run by what im thinking of doing at a high level
1) Using MS SQL 2008 w/ Full Text Search Enabled
2) ASP.NET MVC 2 app is using the Repository pattern, with Linq to SQL for data access I'd like for the user to put in one giant text search value, and the full text to do a search over multiple tables and return a mixed result (Employees, Organizations, Offices, etc)
3) I have a simple stored proc that does a Full Text Search on *one* table that looks like this:
[Code]....
4) My Linq to SQL datacontext calls this SP and which works well enough, i have no inflection or ranking going on but ill add that in later...
Q: How do i handle searching over *multiple* tables, doing some digging around it looks like Full-Text doesnt really allow for searches to span over more than one table - which kinda sucks..although ive seen some workarounds
Q: Is it ok to do a Full Text Search for every table i plan on searching through, and combining the results at the business layer (maybe using rank as sort)? I've heard of things like LUCENE but id really not like to do that at this time.
View 1 Replies
Similar Messages:
Aug 23, 2010
I 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.
View 5 Replies
Feb 17, 2011
how could I include the functionlaity in my ASP.NET MVC site to allow users to search and download image from Google. Basically, I am planning to build the search interface where user can type image name and click search. It should then return the image set and user should be able to select any of them.
View 2 Replies
Apr 3, 2011
I want to implement a forgot-password feature in asp.net mvc that allows users to reset their password, and have some questions in this regard: Lets say that before allowing users to reset their password, I want to verify some extra information such as their first and last name. This info is not stored by default in the table created by aspnet_regsql. What is the recommended approach to address such issues?
Should I store this kind of info in a separate table, and use table joins to verify OR should i modify the schema of the table generated by aspnet_regsql (how?) so that I don't have to use joins? Do I need to write a custom provider OR would that not be necessary? I have read at places e.g. in this post that instead of emailing a temporary password, an alternative is to email a URL that when clicked allows users to change their password. How is this done? How to ensure that the URL expires after 1 hour?
View 1 Replies
Jan 13, 2011
I'm considering going at this myself because my requirements are particular and highly customized:
The grid is bound to a collection of complicated objects, each of which may contain child and grandchild objects. Depending on data and context, the template'd cells vary from TextBoxes to ComboBoxes to Calendars to a combination of controls.TextBox cells have Google-style auto-complete functionality. Also each TextBox cell can expand into a small TreeView pane that allows hierarchy-navigating selection of a value should auto-complete be insufficient.Values from other controls can be drag-and-dropped into cells.Columns are re-sizable and re-orderable. Clicking their headers sorts data.All of the above is AJAX / client-side / Web 2.0 of course.
Has anyone built anything similar from scratch? Or used an effective tool to accomplish this goal? How well would Telerik meet my specs? Is it right to have the hunch that something this specific is best done by taking a Microsoft GridView and extending it myself?
View 5 Replies
Jan 26, 2010
I created a website. I would like to include a search box that searches the whole website and returns the results.
View 2 Replies
Sep 26, 2010
I want to have an upload functionality for uploading large files -- as large as 1GB. I see some sites successfully implementing reliable upload functionality without using any upload clients e.g. ActiveX, Java, etc. Some suggest, the secret is sending the large file in smaller and more manageable chunks to the server. If that't the case how do I handle that?
View 4 Replies
Apr 28, 2010
i want to implement sign in using Google feature so that users do not have to remember multiple passwords.
Are there any ready to use controls for this? Links to tutorials will also be helpful.
View 2 Replies
Mar 21, 2011
am newbie to asp.net 3.0 ,req: is like ...whn user enters id in the textbox,the query has to run against the sql server DB and has to generate the result inside a gridview with a chkbox field by default chked,now in the DAL layer ,is it better option to use datareader(think not,since it has to always maintain connection)..or webservice or WCF or are there any other simple optios available??
View 2 Replies
Oct 13, 2010
I want to give search functionality in grid view. To implement this i am following the below link [URL] but I am getting following error
The name 'MSCD' does not exist in the current context Iam using the following code
if (MSCD.Utilities.Validation.IsDateTime(_newValue) == true)
{
DateTime dtValue = DateTime.Parse(_newValue);
_newValue = sfield + " " + _operator + " #" + dtValue.ToShortDateString() + "#";
}
Can anyone tell me why iam getting this error and what is the use of this MSCD.Utilities.Validation sysntax
View 5 Replies
Sep 17, 2010
Firstly, This question may be asked. But I could not get the information i am looking for.
I am creating a website which should take to [URL] where the user enters his account information and it redirect back to my website similar to how stack over flow is doing when we click on gmail image.
I am trying to implement a website in .net.
list a step by step procedure to implement it or suggest some documentation to follow.
I clearly dont want other types of openID implemention where u enter the open id and pick ur open id provider.
View 2 Replies
May 2, 2014
I'm struck at editing the row which is displayed after search operation being performed. I've a table that has User_ID, Name, Status. I would like to bind data and display in gridview. I've implemented a search box to search fr the name and edit the status of the person. But if I'm trying to implement edit option on the searched entry it is not working as how I needed .
<asp:Content ID="Content2" ContentPlaceHolderID="Dresses" Runat="Server">
<div>
<table>
<tr>
<td>
Search
</td>
<td>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
[Code] ....
View 1 Replies
May 5, 2010
I am implementing an eCommerce application using ASP.Net. I would like to know if custom Google search is sufficient enough or if we plan to go implement our search functionality.. how do we go about doing it?
View 3 Replies
Nov 8, 2010
I am trying to implement a search solution for my website and was wondering whether there are other good search solutions I can use apart from adding a Google search box
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
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
Mar 19, 2011
I am unable to paste the content to a textbox whose property "Textmode"is multiline this issue is happening in google chrome and safari browsers
View 1 Replies
Jan 27, 2010
I have the following code where i enable the user to insert their password to retrieve their username.
[Code]....
But nothing happens, it doesnt work. I want it to do the check and then do something. I am just testing with a label for the time being.
But why does this not work?
View 1 Replies
Oct 26, 2010
I am using ASP.NET MVC and jquery. I would like to implement preview functionality to a form. i.e. I have a form with number of fields for example name, address etc.. Before the user submits the info, he/she can preview it as to how it will appear on the site. how I could implement this in a cleaner way? I have tried regenearting the html on click.. but it's very messy.
View 3 Replies
Oct 6, 2010
i want that while writing some text in an asp.net textbox, a listview page should open which will show the related topics containing that text just below that txtbox .
i want to implement something as in stackoverflow title txtbox how it it showing related topics
View 2 Replies
Mar 7, 2014
how to display large amount of data in griedview with serach funcationality.(the data should be 20 L)with example in asp.net.
View 1 Replies
May 27, 2010
How to impliment search functionality in static web application developed in c#, asp.net
View 2 Replies
May 31, 2010
we deliver micro-site content for our client. Our content is injected into a wrapper that is supplied by another developer.
To deliver our content we host the wrapper as well as the content. The user can access this at
[URL]
For the other content that is not ours, the other developer hosts a similar (though slightly different) wrapper and delivers the content. the user accesses this here:
[URL]
The wrapper contains a search box, which does not work for us but it works for the other developer. I took a look at the network traffic with FireBug but it appears that when I do the search from the wrapper that we're hosting, I'm getting a "407 Proxy Access Denied" error. My guess is their proxy has a problem with the fact that the search is being conducted from a page hosted outside the scope of their proxy.
It was also suggested that there were javascript errors on the page that were preventing the search from executing but I can't see any. Also, I don't think I'd get as far as the proxy error if that was the case.
View 2 Replies
Aug 10, 2013
how to search the node from tree view . if search is succesful it should display as default selected node in windows application using C#
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
