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
Loading
Bitini LumbetPosted Jun 11, 2012, 4:07 AM
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}";
}
}
}