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).
I'm looking for a simple way of developing "System Notification" in an ASP.NET website, which will consist of two parts: Part 1 - The administrator with go to a special page and enter 3 elements for the notification:
Notification Text (e.g. "System will be down for maintenance next Sunday 11/26/2010 from 1:00 AM to 1:30 AM Pacific Time) Starting date/time when the notification should be displayed (e.g. 11/23/2010 6:00 AM) Ending date/time when the notification should be displayed (e.g. 11/26/2010 1:30 AM) Part 2 - Once the user logs into the website within the above timeframe, the system notification message will appear on the home page. What would be a good architectural location for this?
- A table? - An html page? - Part of web.config file? - A new notification.config file? - Where else?
i am using dot net open id for implementing openid in my website i want to redirect user to any of the open id provider site for sign up just like that of stack overflow provides for myopenid how to achieve this
I am trying to write a simple search form for our site. Here is my delima... I am trying to figure out that if there is nothing to search for in one textbox then search in the next textbox. The problem is that I dont know how to format my search string: For Example:
The database has been designed for a tradesman web site, i.e. Plumbers, Builders etc. The two main tables are tblCustomer and tblTrader which will stored data from two frontend web pages where the customer and trader can enter their personal details. After a customer enters their personal details (i.e. registers through the site) they will then be directed to a child page where they can progress to entering a specific job attached to a specific trade (i.e. Plumber) and trade type (i.e. Bathroom Installation), once a customer job has been entered I want these details to be emailed to all the trader_email addresses from tblTrader, from this email alert the traders will then enter the system and offer quotes to the customer through tblTraderQuote where the customer will then accept the best quote for them.
What I also want to implement is some sort of rating option that will allow the customer to rate their trader, either something like ebay's feedback or just a simple 1-5 rating option? How can I implement this into my database design or is this something that should be performed within the programming layer?
While going through MSDN I found that in button properties useSubmitBeheviour there is written that if useSubmitBeheviour is true then it cause the Button control to use the browser's submit mechanism and false then the ASP.NET page framework adds client-side script to the page to post the form to the server.
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.
i want to implement a simple client and server using asp.net.
Requirments: The client side will be a web application using asp.net where user can go on any common web browser (Firefox, IE...) and be able to use it without having to install any plug-ins or .NET. It will have a "Connect" button, once press it will connect to the server.
On the server side, which will just be a windows form or console application, once it detects a connection comin from the client, it accepts it, and send "Connected" back to the client side. The client side then respond back with "Hello world" to the server and display on the screen.
Should be able to work on LAN and over the internet WAN.
*Im trying to avoid tcp/sockets because it uses non-standard ports and usally it will be block by firewalls.
I have a very basic need in regards to membership and role management. I am having success with the membership and being able to use the [Authorize] filter, but the IsInRole() and all that goes along with it is failing. I am hoping someone can point out where I am going wrong.
1) Login action is called on the controller:
If I add a check to the site.master to show/hide a menu item based on role there are no roles listed for the user anymore. I have tried both Page.User.IsInRole("Role1") and HttpContext.Current.User.IsInRole("Role1") neither of which is true. I also receive a failure on [Authorize(Roles="Role1")] filter.
I want to simply search a database for a certain string, how can i accomplish this using linq and EF (if using these tools for it are not practical). I just want to take a string and search my usernames, the search should be able to handle things only parts of the username (using some sort of 'contains' function)
I am using a rich textbox in my website, i need to check the spelling in the content of richtextbox. That i need to implement the spell checking class to check the spelling. give me the idea or sample code to achieve this.
Is there an easy way to search all the columns in the database?
I was the user to input a search word in a textbox and then search all of my database. I then want an array full of the primary keys of all of the records that had the search word contained somewhere in the record (i.e in any of the record fields).
This sounds really simple to me but I can't figure out how to do this and can't find examples online.
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??
I did lot of R & D to implement website internal search in asp.net.
I have found a good article in code project
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.