My site (ASP.NET + C#) has FAQ data pull from another site's web service in XML format. The data size is pretty small (just about 50 faqs). I want to implement a keyword search for the FAQ and highlight the search keyword. What could be a fast and easy approach to do this?
My first thought is just using a C# string search or any XML search method. I know this is not scalable. But consider the FAQ is little, it may not need to index the FAQ. I could be wrong.
I would like to set up a keyword search with and/or wildcards which searches across a rather large tables with around 10,000 rows and growing.What would be the best to set this up ? I heard a lot about indexing etc, im using a SQL2005 DB.And I do not wish to purchase 3rd party software.
In one of my column have a comma separated list of keywords.I have to build a query that will return the matching rows whenever user enters the keyword.for ex.if my keywords are java,.net,sql,php,ajax then on search of java OR java,sql OR php,java should return the above row.
I am searching for products out of my database: AND (CONTAINS(P.name, @contains_key) OR CONTAINS(P.description, @contains_key) OR P.sku like '%' + @Keywords + '%')
As you can see I'm using the CONTAINS statement and searching against the name and description fields.I would like to give the results a weight (or score) based on how often the word shows up and in what field.Example:if the word shows up in the name field -- give it 2 points every time the words appears.if the word shows up in the description field -- give it 1 point every appearance.Then ORDER the query based on the Score. And, perhaps add a where clause that the Score > 1 or some value.I realize, I will probably have to re-write my query and this "point" system may not be possible, but I know there is a way to weight results, but can't find any help online. I would also assume, this would be done in temp tables and select statements and directly in the where clause.
i have a sql server database which has a table name tourheader.in this there are some fields named as follows--Id, name, city, description, tourcode. on the page i have two text box destination and keyword. I want to search the database according to the destination and keyword. in the tourheader the fields contain description and keyword are name and city.
i have make aquery---- string queryString = "SELECT Id , name " + "FROM TourHeader WHERE name like'%" + key + "%'AND city like'%" + key + "%' AND city like'%" + destin + "%'AND name like'%" + destin + "%'";
i am developing a web site in Asp.Net using Visual Studio 2008.i want to know that how can i search a keyword that will be entered by the user, i want the key word should be searched in complete database(all the tables)using a single query.I am using sql database. how can the keyword be searched using like parameter...
I have a search screen where there are total 15 search fileds...one among them is amount range (money datatype)...using Between keyword i am trying to filter the search results...problem is it is taking more time to fetch the records...if i comment only money range in where condition and all other remain same..then it is returning in 2 seconds for 25 records...otherwise it is taking around 31 seconds to return 25 records..
I have heard alot about sql injection and how it is normally caused. Mostly sql injection in my opinion is caused through search boxes. Now my question is quite simple. Is it advisable to store the search keyword in a session variable to prevent sql injection? I don't want to expose the keyword through the querystring as it is prone to attacks. So in short there is no harm in using session variables to store the keyword right?
So, one of my end-users would like the option to search for a keyword and have all of the records that contain that keyword show up in a gridview. Is this possible? How would I do this? Are there tutorials somewhere?
I basically want to do a reverse 'search in all files', so it returns files that don't contain "keyword".Does anyone know how to do this, or the regex used, etc?
what are the ways of handling multiple web forms data for saving into database after last form or editing data and saving back to database after last form is submitted.Previously I have used wizard & panels in a single form and also has cached data from multiple form to save when last form is submitted. Are there some better way to handle multiple web forms data for saving and editing ?
I have a requirement in my asp.net web application, to send emails that are marked as "Follow up" with the "Reply By" property set. I was able to set both these parameters as explained in the article below:
http://www.asp101.com/tips/index.asp?id=142
And the Outlook is showing the email as "Flagged" with the reply by time as set in the code. But the problem is that the outlook doesn't show any alert as the "reply by" time approaches.
This alert appears properly when any "Flagged" email is sent from microsoft outlook, so I am not sure why the emails sent from the web application dont' show the alert?
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 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:
As a newbie coming from a Java background with tag libraries I wonder if there is a simple possibility to render areas depending on backend values.For example if I have search form I do not want to render the table for the search results as long as the user hasn't pressed the search button. Of course I can iterate over the model containing an empty list but this does not allow to suppress rendering the whole table.Using web forms I would just control the visibility of the affected tag(s) in the code behind file but how do I do this with ASP.NET MVC?Can I use a partital view for a case like this? But I think I would have the same problem. How can I determine if a partial view is rendered (e.g. the whole result table with header)?
