protected void ListFeaturedPageCMS(PagesCMSDB db) { //query to select all of pages from table string query = " SELECT * from pagecmsinfo "; List <Dictionary <String, String> > rs = db.List_Query(query); foreach (Dictionary <String, String> row in rs) { //displays the page titles using user control //string stores pagecmsid to be used later string pagecmsid = row["pagecmsid"]; //show all pages on page //grab page using pagecmsid url, then grab the pagecmsid from the string we did above then show the page title - seperated by | featured_pagecms.InnerHtml += "<a href=\"ShowPageCMS.aspx?pagecmsid=" + pagecmsid + "\">" + row["pagecmstitle"] + " | " + "</a>"; } }
protected void Page_Load(object sender, EventArgs e) { pagecms_result.InnerHtml = ""; string searchkey = ""; if (Page.IsPostBack) { searchkey = pagecms_search.Text; } // query for MySQL to search for page title from database string query = "select * from pagecmsinfo"; if (searchkey != "") { //annying little space between the " and WHERE was making it not work. //ahhhh so annoying. I have to remember that c# is very case sensitive and //a strongly typed language. Have to really be careful. query += " where pagecmstitle like '%" + searchkey + "%' "; } //displays query result sql_searcher.InnerHtml = query; //lists pages populated from database var db = new PagesCMSDB(); List <Dictionary <String, String> > rs = db.List_Query(query); foreach (Dictionary <String, String> row in rs) { pagecms_result.InnerHtml += "<div class=\"listitem\">"; string pagecmsid = row["pagecmsid"]; string pagecmstitle = row["pagecmstitle"]; pagecms_result.InnerHtml += "<div class=\"col2\"><a href=\"ShowPageCMS.aspx?pagecmsid=" + pagecmsid + "\">" + pagecmstitle + "</a></div>"; string pagecmsbody = row["pagecmsbody"]; pagecms_result.InnerHtml += "<div class=\"col2last\">" + pagecmsbody + "</div>"; pagecms_result.InnerHtml += "</div>"; } }