How to implement knowledge search page using visual studio 2010 quering from database (C#)

Question

How to implement knowledge search page using visual studio 2010 quering from database (C#)

I would like to set a knowledge base search page when user can search knowledge article and get list of articles with lynk to the specific page on the search result page.

I would like to use connection to database using Linq to Entities Framework.

But, I would like also to using query string to display article content when user click on the lynk to one of the article on the search result page.

Any help.

Bitini

Bitini Lumbet · Answer

Just a try. using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.Objects.DataClasses; using System.Data.Objects.SqlClient; namespace WebApplication5 { public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender EventArgs e) { } protected void Button1_Click(object sender EventArgs e) { var searchText = TextBox1.Text; using (DBResearchEntities query = new DBResearchEntities()) { //var Articlequery = from t in query.articles var Articlequery = from t in query.articles select t; // where t.Title == searchText // select t; if (searchText != ) { Articlequery = Articlequery.Where(t => t.Title.Contains(searchText)); } GridView1.DataSource = Articlequery; GridView1.DataBind(); GridView1.AllowPaging = true; } } protected void gdview_RowDataBound(object sender GridViewRowEventArgs e) { HyperLinkField hyp = (HyperLinkField)GridView1.Columns[0]; string[] items = new string[2]; items[0] = Id; items[1] = Title; hyp.DataNavigateUrlFields = items; hyp.DataNavigateUrlFormatString =~/About.aspx?Id={0}; } } }