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

来源：互联网发布：vb combo1 编辑：程序博客网时间：2024/05/22 13:57
实例：点击搜索按钮，跳出搜索出来的信息。

多建立几个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;            }        }    }}
0 0