SQL Server :: Minimum Search Engine - Add A Search Mechanism To The Site
Jan 19, 2011
I have a database filled with information about a bunch of different articles. I'm trying to add a search mechanisim to the site where you would type in what you are looking for, and it would search through the articles finding the most appropriate article. In my database I have a bunch of different fields that will help find the best article. For example, for each article, there is a title, description, category, a bunch of tags, Number of page views, number of votes, and the sum of all the vote scores. All this informaiton i believe can be used to gather the most relevent article based on the persons search terms. The problem is I don't know what to do with this information. What I would like to do is have a scoring system where the highest score is the first result and the lowest score is the last result. Where the first result is the most relevent.
So for example: The user types in "Korean War" it looks through all the articles, and gives all the articles with "Korean War" in the title + 1, all the tags with "Korean" or "War" + .1, then adds the number of views/1000, and then adds the average vote/4. (I just made that scoring system up on the spot, I would need to do some testing of course). Then it would sort the articles based upon the score it recieved. Is there anyway to do this with a select statement where I can run all of the calculations and then sort them with an "ORDER BY" command? Or would i have to have the server side code do the calculations store them in an array, and then sort them in the array? Or is there a better way of doing this that I might not know of (which is certainly possible).
Does Bing has an option similar to Google Custom Search or Yahoo where I can use Bing to power the search results on my site?
Couple requirements:
Works with an ASP.NET site (is a .NET project) Host the search box and results on my own website Ability to customize the look and feel of the results to match my site (Full control is ideal but I understand it's not possible with free solutions)
I did a search for Bing custom search and found this: [URL] but it's not exactly what I am looking for.
in my project i would like to save pdf files in database, how to save pdf files in database ? along with that i would like to create create a search page to search for pdf files with PDF file names , how to accoplish these things
I would like to create personal web site including search engine in my site content. I don't know algorithem how to build it yet. how to build my own search engine?
I want to know how can I build a simple search engine which search from specific websites, for example it should search codeplex and msdn only and show the result on my page?
The url stays the same for the french, english, polish, spanish, italian versions of the site since the content is located in seperate .resx files. and the code stays the same for all.
I need search engines to see all versions of my site.
And I need to stay on the same domain for all languages. No subdomains.
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.
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
I had gone thru many discussions re: search engine & didn't get the answer to what i intend to design. I intend to put the search textbox & button to the masterpage so that whatever page the user is within the website, he/she can do the search.
I've been following the example (SearchDotNet) in the developerfusion but I just can't figure how I'll make it to redirect to the searchsite from the page the user triggers the search. Do I put the codes in the masterpage?
I am trying to implement search in our various ASP.NET websites that are all located on a particular web server that we control. The server is running IIS7 and Windows Server 2008 R2 32bit. I do NOT want to go third-party by using Google/Bing/etc APIs. I want to have an in-house solution for JUST our website directories (and not worry about searching through other documents elsewhere).
I have looked at Search Server 2010 Express, but that won't work because it is 1) 64bit, and 2) too much overhead for the tiny bit of websites we are wanting to search on. There is a 2008 Express edition that is x86 compatible, but I still think its way too much to install and run for what we are wanting to use it for.
i am newer to asp.net and i am trying to make a search engine for my site like this one [URL]. i am able to get the SEO friendly URL like this with the keyword and redirected to the Search.aspx.
Now how can i get result like this, i need some assistance to start. i have used contain attribute in LINQ query and get results. but i want to split the search term and i don't know how and then want to search the each word using contain attribute and then want to get results like this guy. you can reffer me anything tutorial or any componenet which is made for asp.net c#.
I have a site where users can enter their profile and password-protect certain details. I would like search engines to crawl the 'unprotected' parts of the profile (which varies from user to user). Similar to how if you enter a user's name in facebook, their Facebook profile comes up in the search results. Do I have to do anything special to ensure that the bot doesn't crawl the password-protected sections, but still crawls the (always-public) username?I'm not sure if this is even an issue, but I'd like to update my robots.txt to allow for this.
Also, how do I ensure that the usernames are available to the bots (in a safe manner)? Do I have to create a separate directory with a list of names, or is there a better way?
I would love to create a search field on my master page that returns a page full of results.
It seems simple to me. I need it to search each of my tabels. aka(Customers, Loan Information, Real Estate, Vehicles) I want a repeater or datalist of sometype that hyperlinks to a details view page for each of the tables(easy to do).
I don't know the best way to tackle this. It is a local intranet application so I was thinking about possibly just passing the words or numbers in the textbox to a query string then running a sql command for each of the tables and returning data in a datalist for each table?
Would that work or is there a simple way to do this? It would be nice for it to highlight the match? What should my sql commands look like?
I'm doing custom-rolled view tracking on my website, and I just realize that I totally forgot about search bots hitting the pages. How do I filter out that traffic from my view tracking?
I need to create a search engine for my website that searches my entire content and files stored in a database.What is the best way and easy to accomplish this?If can, please provide a few samples or links.
not sure if I'm posting to the right thread or not.. but here is the questiondoes anyone know how to implement a best pratice on SEO?One of the example is: if the user types "brand new canon camera" then I want the system to find a sequence of string in the database that contains "new", "cannon", "camera". It is ok with or without the word "brand". However if the user types "HP laptop DV1000" and i want the system to find all HP laptop whether new or not but limited to specific series.
how to embed a search engine into all asp.net page? i want to add a search engine which allow user to input key words then display some title which has the keywords.
what I'm looking to do is to get a web site search function where I can enter the URLs and body text myself rather than running a spider unless the spider can handle my url querystring structure. Obviously, something automatic would be best but I'm not too choosy as long as it is free.
i have awebsite and i made all my steps to make it in the first links on the search of google (SEO) and now i want to go to google updates to make the steps that apply the website on google after one day almost. can any one tell me what i should begin with or do?
