protected void food_drifters_menu(FoodDriftersdb db)
{
food_menu.InnerHtml = "";
string searchkey = "";
string query = "select * from foodblogpages";
if (searchkey != "")
{
query += " WHERE foodblogtitle like '%" + searchkey + "%' ";
query += " or chefname like '%" + searchkey + "%' ";
query += " or foodblogbody like '%" + searchkey + "%' ";
}
List <Dictionary <String, String> > rs = db.List_Query(query);
foreach (Dictionary <String, String> row in rs)
{
food_menu.InnerHtml += "<div class=\"listitem\">";
string foodblogid = row["foodblogid"];
string foodblogtitle = row["foodblogtitle"];
food_menu.InnerHtml += "<a href=\"ShowFoodBolg.aspx? foodblogid = " + foodblogid + "\">" + foodblogtitle + "</a>";
}
}
protected void Page_Load(object sender, EventArgs e)
{
foodblogs_result.InnerHtml = "";
string searchkey = "";
if (Page.IsPostBack)
{
searchkey = blog_search.Text;
}
string query = "select * from foodblogpages";
if (searchkey != "")
{
query += " WHERE foodblogtitle like '%" + searchkey + "%' ";
query += " or chefname like '%" + searchkey + "%' ";
query += " or foodblogbody like '%" + searchkey + "%' ";
}
var db = new FoodDriftersdb();
List <Dictionary <String, String> > rs = db.List_Query(query);
foreach (Dictionary <String, String> row in rs)
{
foodblogs_result.InnerHtml += "<div class=\"listitem\">";
string foodblogid = row["foodblogid"];
string foodblogtitle = row["foodblogtitle"];
foodblogs_result.InnerHtml += "<div class=\"col2\"><a href=\"ShowFoodBolg.aspx?foodblogid=" + foodblogid + "\">" + foodblogtitle + "</a></div>";
string chefname = row["chefname"];
foodblogs_result.InnerHtml += "<div class=\"col2\">" + chefname + "</div>";
string foodblogbody = row["foodblogbody"];
foodblogs_result.InnerHtml += "<div class=\"col2last\">" + foodblogbody + "</div>";
}
}