SQL Server :: How To Save Pdf Files In Database And Create A Search Engine To Search For Pdf Files
Sep 28, 2010
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 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 have a directory folder with PDF images files: 1234567.pd, 7654321.pdf, 3212345.pdf, 9876321.pdf. Now, see my code below (everything in the code is working good), except that I am trying to search for the image file number doesn’t exist in that directory.
For example If the image file pdf number: 4455668.pdf doesn’t exist in that folder it will redirect or display error.I am getting an error that says: AspPDF. NET 188.8.131.5216 has generated error #110: [ Could not find a part of the path 'C:XXXX-Image4455668.pdf', which means the image file number doesn’t exist in the path directory. Yes, the error is correct, there is not image file number I type.
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 have a project to create a high traffic search engine similar to altavista.com. The windows .NET C# will be used for the project. I am looking for a good search engine database that can handle a very high load. I have taken a look at lucene and sql server 2008. I have read that lucene tends to get corrupt when the load is very high. So, I am considering sql server 2008 but I am uncertain sql server can handle a very high load over gigabytes of data.
The database will be given a chunk of data and needs to fetch similar data elsewhere in the table. it will act just the similar questions area on stackoverflow. It will need to search over millions of rows. Is sql server 2008 and lucene my only options
I have a simple database search engine set up on my company's intranet and I'd like to add auto-complete... Can somebody walk me through this? The database is Access. I'll need to make sure I'm using parameterized queries as well.
I have just deployed a MVC web application onto our intranet. The application is hosted on a Win 2003 R2 SP1 server and running on IIS 6.0. Everything works fine within the application. But our intranet uses the windows Indexing service for providing search functionality on our intranet website.The search brings up related links to files within the MVC web application. But the problem is the links don't work as MVC urls do not point to absolute files.Is there a way to resolve this?
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?
If in one form upload image form we enter ID in textbox againts ID label and upload an image file using fileuploadcontrol when we click on upload button image save in DB and in next form view image when we enter ID in textbox againts label enter ID. Images show in GRIDVIEW having columns (ID,images) ...