How to Search Text field from SQL Server database by Keywords.

Question

0.00/5 (No votes)

See more:

Hello friends
My name is Sarfaraz. I am learning ASP.Net and i have an article table with fields ArticleID, Title, Keywords, Image and Contents.
I wanted to design a search page where by typing keywords and click search button it should display all the articles having that keyword with only 2 or 3 lines of contents with a read more link and when clicking that read more it should display the whole text of that article just like we search in a blog.

Also, i wanted to know any video series of ASP.Net which teaches how to create a dummy website from start to finish with Master pages.

Please help me
Thanking you.

Posted 23-Feb-14 2:12am

sarfarazbhat

Updated 26-Mar-21 20:46pm

Add a Solution

Comments

[no name] 28-Jan-20 2:24am

Is acquiring outstanding Biology Writing Services seems arduous for you? Seek our Custom Biology Writing Help from Best Biology Writing Service company..
https://www.meldaresearch.com/biology-writing-services/

3 solutions

Solution 1

Are your keywords are stored in a database>>>? or you want to store it in database?

Posted 23-Feb-14 2:28am

Pranav-BiTwiser

Comments

sarfarazbhat 23-Feb-14 8:31am

Keywords are stored in Article table with ArticleID, Title, Keywords, Image and Contents as columns. And I want to show title, image and contents to be displayed but after clicking the read more link.

CHill60 23-Feb-14 14:32pm

Please use the "Have a Question or Comment?" link next to a post if you want to ask the OP anything. Posting a comment as a solution removes the question from the Unanswered Questions list

Solution 2

you can display on grid view....with visible propery as false....and after clicking on read more link make the visible property of grid view to true...:)

Posted 23-Feb-14 3:43am

Pranav-BiTwiser

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

JoCodes · Accepted Answer · 2014-02-23T04:21:00

Solution 3

Refer

Implement-Search-Engine

http://msdn.microsoft.com/en-us/expression/dd571513.aspx[^]

Posted 23-Feb-14 4:21am

JoCodes

Comments

sarfarazbhat 23-Feb-14 10:49am

Thank you sir for your help. One last thing about this tutorial is that when i search any keyword it displays thw whole content how to restrict to display only first 2 lines and then after clicking the title it should display the whole content(full text) on our show.aspx page .
Thank you

JoCodes 23-Feb-14 10:58am

Refer this , you can use css for this

http://stackoverflow.com/questions/6972728/how-do-you-show-just-the-first-line-of-text-of-a-div-and-expand-on-click

[no name] 28-Jan-20 2:24am

Finding Religion and Theology Writing Services and Theology Writing Services to suit all your academic medical research requirements can be essay if you need Custom Religion and Theology Writing Services.
https://www.meldaresearch.com/religion-and-theology-writing-services-2/