【三层架构】一个aspx页面读取server 2008不同表里面的数据

实例：点击搜索按钮，跳出搜索出来的信息。

多建立几个bll实例-读取数据。Over

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Drawing;
using System.Data;
using System.Data.SqlClient;
using System.Text;

namespace helios.Web
{
    public partial class sousuo : System.Web.UI.Page
    {
        helios.BLL.sousuo bll = new helios.BLL.sousuo();//实例化适用于微课程的BLL层
        helios.BLL.wenjian.MiroLctsDiscuss bllTaolun = new helios.BLL.wenjian.MiroLctsDiscuss();//讨论
        helios.BLL.wenjian.Users  bllChengyuan = new helios.BLL.wenjian.Users();//成员
        helios.BLL.wenjian.Lctstag bllBiaoqian = new helios.BLL.wenjian.Lctstag();//标签
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {

                TextBoxsearch2.Text = Session["guanjianci"].ToString();
                Session.Remove("guanjianci");
                //TextBoxsearch2.Text = Request.QueryString["guanjianci"];


                GridView1.BorderColor = ColorTranslator.FromHtml(Application[Session["Style"].ToString() + "xtable_bordercolorlight"].ToString());
                GridView1.HeaderStyle.BackColor = ColorTranslator.FromHtml(Application[Session["Style"].ToString() + "xtable_titlebgcolor"].ToString());

                BindData();
            }
        }
        public void BindData()
        {
            #region
            //if (!Context.User.Identity.IsAuthenticated)
            //{
            //    return;
            //}
            //AccountsPrincipal user = new AccountsPrincipal(Context.User.Identity.Name);
            //if (user.HasPermissionID(PermId_Modify))
            //{
            //    gridView.Columns[6].Visible = true;
            //}
            //if (user.HasPermissionID(PermId_Delete))
            //{
            //    gridView.Columns[7].Visible = true;
            //}
            #endregion
            DataSet dsWeikecheng = new DataSet();//新建一个叫做ds的dataset实例，用于存放从数据库中读取的数据。
            DataSet dsTaolun = new DataSet();
            DataSet dsChengyuan = new DataSet();
            DataSet dsBiaoqian = new DataSet();
            StringBuilder strWhere = new StringBuilder();//新建一个strWhere 语句。就相当于string的高级版，操作多个字符串的时候使用，效率比string高
            StringBuilder strTaolun = new StringBuilder();
            StringBuilder strChengyuan = new StringBuilder();
            StringBuilder strBiaoqian = new StringBuilder();
            if (TextBoxsearch2.Text.Trim() != "")//trim,一个string类特有的属性（方法），使得去掉文本框中两边输入的空格只剩下输入的字符或数字
            {
                strWhere.AppendFormat("kcBiaoti like '%{0}%' or kcLeixing like '%{0}%'", TextBoxsearch2.Text.Trim());//AppendFormat是使用类似String.Format方式追加具备一定格式的字符串。Append是直接添加字符。
                strTaolun.AppendFormat("tlBiaoti like '%{0}%'", TextBoxsearch2.Text.Trim());
                strChengyuan.AppendFormat("yonghuming like '%{0}%'", TextBoxsearch2.Text.Trim());
                strBiaoqian.AppendFormat("biaoqian like '%{0}%'", TextBoxsearch2.Text.Trim());

                dsWeikecheng = bll.GetList(strWhere.ToString());//将strWhere这个实例字符串语句传递到已经被实例化的bll层的GetList方法里面。获得一个实例化过的真真正正的dataset
                dsTaolun = bllTaolun.GetList(strTaolun.ToString());
                dsChengyuan = bllChengyuan.GetList(strChengyuan.ToString());
                dsBiaoqian = bllBiaoqian.GetList(strBiaoqian.ToString());

                GridView1.DataSource = dsWeikecheng;//gridView里面的数据源从哪里来呢，就从一个实例化过的真真正正的dataset里来，它的名字叫做ds.
                //数据源已经有了，但是还没有绑定啊，那还不赶紧绑定啊。
                GridView1.DataBind();//将数据源绑定到在designer.cs里面声明过的aspxGridView 控件中。没有？赶紧在你要显示的页面里面建一个啊。

                gvTaolun.DataSource = dsTaolun;
                gvTaolun.DataBind();

                gvChengyuan.DataSource = dsChengyuan;
                gvChengyuan.DataBind();

                gvBiaoqian.DataSource = dsBiaoqian;
                gvBiaoqian.DataBind();


            }
            else
            {
                ltishi.Visible = true;
            }

        }
    }
}