web开发论坛系统报告

Web开发技术论坛系统目录：概述 (1)系统需求分析 (4)系统功能 (8)系统模块划分 (10)系统流程图 (10)数据库设计（ER图） (11)详细设计及实现 (12)（关键算法、方法，运行效果图，关键代码等）总结体会 (33)一、概述1、项目背景说明：a．论坛系统；b．实现普通论坛的操作，从而达到交流信息的效果；2、编写目的随着Internet的快速发展壮大，挨家挨户都已经习惯于计算机渗透自己的生活。

计算机处理信息的能力就成为计算机人期望提高的目标，以实现及时、准确的掌握信息。

计算机的作用已经在生活中各个方面体现出来，随着技术的发展，人们知识的拓展，使用计算机交流已经成为一个势必的主流。

本项目是一个以论坛为主题的项目，大家可以实现普通论坛的操作，从而达到交流信息的效果，下面将会详细介绍本项目的架构。

3、开发环境：1〉软件环境本次开发的系统采用sql server数据库管理系统作为后台，采用microsoft visual studio2010作为前台开发工具。

Visual Studio是微软公司推出的开发环境。

是目前最流行的Windows平台应用程序开发环境。

Visual Studio 2010版本于2010年4月12日上市，其集成开发环境（IDE）的界面被重新设计和组织，变得更加简单明了。

Visual Studio 2010同时带来了NET Framework 4. Microsoft Visual Studio 2010 CTP( Community Technology Preview--CTP)，并且支持开发面向Windows 7的应用程序。

除了Microsoft SQL Server，它还支持IBM DB2和Oracle数据库。

2〉硬件环境现在一般的兼容机完全可以满足系统的要求。

4、功能概述提供包括用户注册，帖子发布、评论以及后台管理等内容。

用户注册新用户注册，填写用户信息，检验用户信息的有效性，并将用户信息持久化。

用户可以凭借此账号实现与其他用户的互动。

登录提供用户凭证，验证用户信息是否合法，根据用户角色授权。

用户登录：对于注册用户，可以通过输入其注册名及密码进入系统。

管理员登录：对于管理员可以通过输入其注册名及密码进入系统，享有高级权限。

发表帖子用户发表一个讨论主题，内容包括标题，正文等。

查看帖子查看帖子列表及其详细信息，在详细信息页面中显示该帖子所有的回复。

回复帖子用户可以对帖子进行回复。

帖子管理管理员可以对帖子进行修改和删除。

用户信息修改对于用户可以修改自己的信息。

模块管理管理员可以新建模块，删除模块，修改模块。

BBS的总体功能图如下图所示：BBS论坛系统用户注册用户登陆查看帖子发表帖子用户信息修改帖子管理回复帖子模块管理二、需求分析系统主要业务操作流程：（1）用户注册业务流程图：（2）用户登录业务流程图：输入会员信息开始通过会员信息持久化结束不通过检验合法性正确错误开始输入用户信息检验用户名密码是否正确根据角色授权结束（3）帖子发表业务流程图（4）帖子查看业务流程图否是开始用户是否登录 发表帖子持久化 结束开始 浏览帖子 结束（5）帖子回复业务流程图（6）帖子管理业务流程图开始帖子回复持久化结束否是开始是否拥有管理员或版主权限帖子的管理操作结束（7）用户信息修改业务流程图否是（8）模块管理业务流程图开始是否登录 修改个人信息结束 否是开始是否管理员持有管理员权限管理版块结束三、系统功能用户注册功能：功能描述通过此功能用户可以注册一个账号成为论坛系统的会员输入用户名，密码，用户资料操作序列提交个人资料并注册输出将用户信息保存至数据库中补充说明未注册的用户可以注册，已注册用户不能重复注册登陆功能：功能描述通过此功能用户可以登录到该论坛系统上输入用户名和密码操作序列登录至论坛主页输出软件的操作界面用户信息修改功能：功能描述通过此功能读者可以修改自己的密码、个人资料输入用户名（原密码），新的个人资料操作序列登录至修改个人资料页面输出用户名和密码（联系方式等）发表帖子功能：功能描述通过此功能读者可以在论坛上发表新的帖子输入帖子的名称及内容操作序列读者在发表帖子页面上帖子的相关信息输出新的帖子页面查看并回复帖子：功能描述通过此功能读者可以查看所需要的帖子\回复帖子输入查看帖子的名称\需要回复的内容操作序列进入帖子列表页面\回复帖子页面输出帖子的详细信息及回复情况帖子管理：功能描述通过此功能管理可以删除帖子输入帖子的名称及内容操作序列进入帖子修改页面输出 帖子的详细信息及回复情况四、系统模块划分个人模块：注册：注册一个新的用户。

修改个人资料：修改用户资料。

发表帖子：发表一个新的帖子。

回复帖子：回复已存在的帖子。

帖子模块：帖子管理：管理员可以删除不符合规定的帖子。

主页显示：主页显示了所有帖子，并可以从主页进入帖子浏览界面。

五、系统流程图注册 游客访问六．数据库设计（ER 图）BBS 论坛系统论坛主页 用户管理员浏览帖子发表帖子回复帖子修改信息删除帖子登录真实姓名性别用户邮箱地址电话用户ID 密码密码问题问题答案用户E-R 实体图模块E-R 实体图帖子E-R 实体图评论E-R 实体图数据库设计：模块 模块名称 模块日期模块ID 评论评论ID评论时间评论内容 评论的帖子帖子帖子ID帖子状态帖子分类帖子名称帖子内容发帖日期 发帖人七、详细设计及实现标头组件：链接组件：菜单组件：论坛主页：using System;using System.Data;using System.Data.SqlClient; using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;public partial class Index : System.Web.UI.Page{DataOperate sqlBind = new DataOperate();SqlConnection sqlcon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);protected void Page_Load(object sender, EventArgs e){dlBind();string sqlstr = "select * from bbs_user";SqlDataAdapter ada = new SqlDataAdapter(sqlstr, sqlcon);if (!IsPostBack){try{labUserName.Text = Session["Name"].ToString() + "！";}catch { }}}public void dlBind(){int curpage = Convert.ToInt32(bPage.Text);PagedDataSource ps = new PagedDataSource();sqlcon.Open();string sqlstr = "select a.*,b.* from BBS_Card as a join BBS_Module as b on a.ModuleID=b.ModuleID";SqlDataAdapter MyAdapter = new SqlDataAdapter(sqlstr, sqlcon);DataSet ds = new DataSet();MyAdapter.Fill(ds, "BBS_Card");sqlcon.Close();ps.DataSource = ds.Tables["BBS_Card"].DefaultView;ps.AllowPaging = true;ps.PageSize = 2;ps.CurrentPageIndex = curpage - 1;this.lnkbtnUp.Enabled = true;this.lnkbtnNext.Enabled = true;this.lnkbtnBack.Enabled = true;this.lnkbtnOne.Enabled = true;if (curpage == 1){this.lnkbtnOne.Enabled = false;this.lnkbtnUp.Enabled = false;}if (curpage == ps.PageCount){this.lnkbtnNext.Enabled = false;this.lnkbtnBack.Enabled = false;}bBackPage.Text = Convert.ToString(ps.PageCount);this.dlContent.DataSource = ps;this.dlContent.DataKeyField = "CardID";this.dlContent.DataBind();}protected void lnkbtnOne_Click(object sender, EventArgs e){bPage.Text = "1";this.dlBind();}protected void lnkbtnUp_Click(object sender, EventArgs e){bPage.Text = Convert.ToString(Convert.ToInt32(bPage.Text) - 1);this.dlBind();}protected void lnkbtnNext_Click(object sender, EventArgs e){bPage.Text = Convert.ToString(Convert.ToInt32(bPage.Text) + 1);this.dlBind();}protected void lnkbtnBack_Click(object sender, EventArgs e){bPage.Text = bBackPage.Text;this.dlBind();}protected void dlContent_SelectedIndexChanged(object sender, EventArgs e){}}用户登录：using System;using System.Data;using System.Data.SqlClient;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;public partial class _Default : System.Web.UI.Page{protected void Page_Load(object sender, EventArgs e){}protected void Button1_Click(object sender, EventArgs e){HttpCookie cookie = Request.Cookies["CheckCode"];SqlConnection sqlcon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);sqlcon.Open();SqlCommand sqlcom = sqlcon.CreateCommand();mandText = "select count(*) from bbs_user where UserLoginName='"+txtUserName.Text+"'and UserPwd='"+txtPassword.Text+"'";int countAdmin = Convert.ToInt32(sqlcom.ExecuteScalar());if (countAdmin > 0){if (cookie.Value == TextBox3.Text){Response.Write("<script>alert('登陆成功');location='</script>");Session["Name"] = txtUserName.Text;Page.Response.Redirect("Index.aspx");}else{Response.Write("<script>alert('验证码错误');location='javascript:history.go(-1)'</script>");}}else{Response.Write("<script language =javascript>alert('用户名或密码错误！');location='javascript:history.go(-1)'</script>");return;}sqlcon.Close();}protected void Button2_Click(object sender, EventArgs e){txtUserName.Text = "";txtPassword.Text = "";TextBox3.Text = "";}}修改个人信息:using System;using System.Data;using System.Data.SqlClient;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;public partial class PersonInfo : System.Web.UI.Page{protected void Page_Load(object sender, EventArgs e){DataOperate sqloperate = new DataOperate();SqlConnection sqlconn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);string sqlstr = "select * from bbs_user";SqlDataAdapter ada = new SqlDataAdapter(sqlstr, sqlconn);DataSet ds = new DataSet();if (!IsPostBack){try{labUserName.Text = Session["Name"].ToString() + "！";}catch{Response.Write("<script>alert('您还没有登录，或是服务器超时，请重新登录！');location='Login.aspx'</script>");}}}protected void btnUpdate_Click(object sender, EventArgs e){DataOperate sqloperate = new DataOperate();SqlConnection sqlconn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);if (Session["Name"].ToString() != null){sqlconn.Open();SqlDataAdapter ad = new SqlDataAdapter("select * from bbs_user where UserLoginName='" + Session["Name"].ToString() + "'", sqlconn);DataSet d = new DataSet();ad.Fill(d, "bbs_user");try{string sex = ddlSex.SelectedValue;string photo = ddlPhoto.SelectedValue;string pwd = txtPwd.Text;string name = txtTName.Text;string quepwd = txtQuePwd.Text;string anspwd = txtAnsPwd.Text;string tel = txtTel.Text;string email = txtEmail.Text;string sqlupdate = "UPDA TE bbs_user SET UserSex='" + sex + "',UserPwd='" + pwd + "',UserName='" + name + "',UserQuePwd='" + quepwd + "',UserAnsPwd='" + anspwd + "',UserTel='" + tel + "',UserEmail='" + email + "',UserPhoto='" + photo + "' where UserLoginName='" + @Session["Name"].ToString() + "'";SqlCommand com = new SqlCommand(sqlupdate, sqlconn);com.ExecuteNonQuery();sqlconn.Close();Response.Write("<script language='javascript'>alert('修改成功');</script>");}catch{Response.Write("<script language='javascript'>alert('修改失败');</script>");}}}protected void ddlPhoto_SelectedIndexChanged(object sender, EventArgs e){imgPhoto.ImageUrl = "~/photos/" + ddlPhoto.SelectedValue + ".jpg";}protected void btnCancel_Click1(object sender, EventArgs e){txtPwd.Text = "";txtTName.Text = "";txtQuePwd.Text = "";txtAnsPwd.Text = "";txtTel.Text = "";txtEmail.Text = "";}}用户注册：using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;public partial class Register : System.Web.UI.Page{DataOperate sqloperate = new DataOperate();SqlConnection sqlconn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);protected void Page_Load(object sender, EventArgs e){}protected void btnRegister_Click(object sender, EventArgs e){string sqltest = "select * from BBS_User where UserName='" + this.txtLoginName.Text + "'";sqlconn.Open();SqlCommand sqlcom = new SqlCommand(sqltest, sqlconn);SqlDataReader read = sqlcom.ExecuteReader();read.Read();if (read.HasRows){if (this.txtLoginName.Text.Trim() == read["UserName"].ToString().Trim()){Response.Write("<script language='javascript'>alert('该会员已经注册过');localtion='Register.aspx'</script>");return;}}string sqlstr = "Insert into [bbs_User]([UserLoginName],[UserSex],[UserPWD],[UserName],[UserQuePwd],[UserAnsPwd], [UserTel],[UserEmail],[UserPhoto])values(@LoginName,@UserSex,@UserPwd,@UserName,@ UserQuePwd,@UserAnsPwd,@UserTel,@UserEmail,@UserPhoto)";mandText = sqlstr;SqlParameter para1 = new SqlParameter("@LoginName", SqlDbType.Char, 10);para1.Value = txtLoginName.Text;sqlcom.Parameters.Add(para1);SqlParameter para2 = new SqlParameter("@UserSex", SqlDbType.Char, 10);para2.Value = ddlSex.SelectedValue;sqlcom.Parameters.Add(para2);SqlParameter para3 = new SqlParameter("@UserPwd", SqlDbType.VarChar, 50);para3.Value = txtPwd.Text;sqlcom.Parameters.Add(para3);SqlParameter para4 = new SqlParameter("@UserName", SqlDbType.VarChar, 50);para4.Value = txtTName.Text;sqlcom.Parameters.Add(para4);SqlParameter para5 = new SqlParameter("@UserQuePwd", SqlDbType.VarChar, 50);para5.Value = txtQuePwd.Text;sqlcom.Parameters.Add(para5);SqlParameter para6 = new SqlParameter("@UserAnsPwd", SqlDbType.VarChar, 50);para6.Value = txtAnsPwd.Text;sqlcom.Parameters.Add(para6);SqlParameter para7 = new SqlParameter("@UserTel", SqlDbType.Char, 50);para7.Value = txtTel.Text;sqlcom.Parameters.Add(para7);SqlParameter para8 = new SqlParameter("@UserEmail", SqlDbType.VarChar, 50);para8.Value = txtEmail.Text;sqlcom.Parameters.Add(para8);SqlParameter para9 = new SqlParameter("@UserPhoto", SqlDbType.VarChar, 50);para9.Value = ddlPhoto.Text;sqlcom.Parameters.Add(para9);sqlconn.Close();sqlconn.Open();sqlcom.ExecuteNonQuery();sqlconn.Close();Session["regName"] = txtLoginName.Text.Trim();Response.Redirect("SuccReg.aspx");}protected void btnCancel_Click(object sender, EventArgs e){txtLoginName.Text = "";txtPwd.Text = "";txtTName.Text = "";txtQuePwd.Text = "";txtAnsPwd.Text = "";txtTel.Text = "";txtEmail.Text = "";txtLoginName.Focus();}protected void btnTest_Click(object sender, EventArgs e){if (txtLoginName.Text == ""){Response.Write("<script language='javascript'>alert('会员登录名不能为空！');localtion='Register.aspx'</script>");}else{string sqlstr = "select * from BBS_User where UserLoginName='" + this.txtLoginName.Text + "'";sqlconn.Open();SqlCommand sqlcom = new SqlCommand(sqlstr, sqlconn);SqlDataReader read = sqlcom.ExecuteReader();read.Read();if (read.HasRows){if (this.txtLoginName.Text.Trim() ==read["UserLoginName"].ToString().Trim()){Response.Write("<script language='javascript'>alert('该会员已经注册过');localtion='Register.aspx'</script>");return;}}else{Response.Write("<script language='javascript'>alert('您可以进行正常注册');localtion='Register.aspx'</script>");}read.Close();sqlconn.Close();}}protected void ddlPhoto_SelectedIndexChanged(object sender, EventArgs e){imgPhoto.ImageUrl = "~/photos/"+ddlPhoto.SelectedValue+".jpg";}}查看并回复帖子：using System;using System.Data;using System.Data.SqlClient;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;public partial class RevertCard : System.Web.UI.Page{DataOperate sqlBind = new DataOperate();SqlConnection sqlcon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);protected void Page_Load(object sender, EventArgs e){dlBind();string sqlst = "select * from bbs_user";SqlDataAdapter ada = new SqlDataAdapter(sqlst, sqlcon);if (!IsPostBack){try{labUserName.Text = Session["Name"].ToString() + "！";}catch { }string idStr = Page.Request.QueryString["CardID"];sqlcon.Open();string sqlstrbind = "select * from bbs_Card where CardID='" + idStr + "'";SqlCommand sqlcom = new SqlCommand(sqlstrbind, sqlcon);SqlDataReader tmpReader = sqlcom.ExecuteReader();if (tmpReader.Read()){labCardTitle.Text = "帖子标题：" + tmpReader["CardName"].ToString();labCardID.Text = tmpReader["CardID"].ToString();labCardDate.Text = "发帖日期：" + tmpReader["CardDate"].ToString();labCardContent.Text = tmpReader["CardContent"].ToString();}sqlcon.Close();}}protected void btnRevert_Click(object sender, EventArgs e){sqlcon.Close();sqlcon.Open();string sqlstr = "INSERT INTO bbs_RevertCard (CardID,RevertCardContent)"+ " values ('" + @labCardID.Text + "','" + @txtRevertContent.Text + "')";sqlBind.DataCom(sqlstr);SqlCommand com = new SqlCommand(sqlstr, sqlcon);com.ExecuteNonQuery();Response.Write("<script language='javascript'>alert('评论成功');</script>");}protected void btnCancel_Click(object sender, EventArgs e){Response.Redirect("Index.aspx");}public void dlBind(){string idStr = Page.Request.QueryString["CardID"];int curpage = Convert.ToInt32(bPage.Text);PagedDataSource ps = new PagedDataSource();sqlcon.Open();string sqlstr = "select * from bbs_RevertCard where CardID='" +idStr + "'";SqlDataAdapter MyAdapter = new SqlDataAdapter(sqlstr, sqlcon);DataSet ds = new DataSet();MyAdapter.Fill(ds,"bbs_RevertCard");sqlcon.Close();ps.DataSource = ds.Tables["bbs_RevertCard"].DefaultView;ps.AllowPaging = true; //是否可以分页ps.PageSize = 2; //显示的数量ps.CurrentPageIndex = curpage - 1; //取得当前页的页码this.lnkbtnUp.Enabled = true;this.lnkbtnNext.Enabled = true;this.lnkbtnBack.Enabled = true;this.lnkbtnOne.Enabled = true;if (curpage == 1){this.lnkbtnOne.Enabled = false;//不显示第一页按钮this.lnkbtnUp.Enabled = false;//不显示上一页按钮}if (curpage == ps.PageCount){this.lnkbtnNext.Enabled = false;//不显示下一页this.lnkbtnBack.Enabled = false;//不显示最后一页}bBackPage.Text = Convert.ToString(ps.PageCount);this.dlRevertCard.DataSource = ps;this.dlRevertCard.DataKeyField = "CardID";this.dlRevertCard.DataBind();}protected void lnkbtnOne_Click(object sender, EventArgs e){bPage.Text = "1";this.dlBind();}protected void lnkbtnUp_Click(object sender, EventArgs e){bPage.Text = Convert.ToString(Convert.ToInt32(bPage.Text) - 1);this.dlBind();}protected void lnkbtnNext_Click(object sender, EventArgs e){bPage.Text = Convert.ToString(Convert.ToInt32(bPage.Text) + 1);this.dlBind();}protected void lnkbtnBack_Click(object sender, EventArgs e){bPage.Text = bBackPage.Text;this.dlBind();}}管理贴子（管理员部分）：using System;using System.Data;using System.Data.SqlClient;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;public partial class ManageCard : System.Web.UI.Page{DataOperate sqlBind = new DataOperate();protected void Page_Load(object sender, EventArgs e){if (!IsPostBack){this.bind();}}protected void gvCardInfo_PageIndexChanging(object sender, GridViewPageEventArgs e) {gvCardInfo.PageIndex = e.NewPageIndex;this.bind();}protected void gvCardInfo_RowDeleting(object sender, GridViewDeleteEventArgs e){string sqlstr = "delete from BBS_Card where CardID='" + gvCardInfo.DataKeys[e.RowIndex].Value + "'";sqlBind.DataCom(sqlstr);Response.Redirect("ManageCard.aspx");}protected void gvCardInfo_RowDataBound(object sender, GridViewRowEventArgs e){if (e.Row.RowType == DataControlRowType.DataRow){((LinkButton)(e.Row.Cells[6].Controls[0])).Attributes.Add("onclick", "return confirm('确定要删除吗？')");}}public string SubStr(string sString, int nLeng){if (sString.Length <= nLeng){return sString;}string sNewStr = sString.Substring(0, nLeng);sNewStr = sNewStr + "...";return sNewStr;}public void bind(){string sqlstr = "select * from BBS_Card order by CardID asc";SqlConnection sqlcon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);DataSet myds = new DataSet();sqlcon.Open();myda.Fill(myds, "BBS_Card");gvCardInfo.DataSource = myds;gvCardInfo.DataKeyNames = new string[] { "CardID" };gvCardInfo.DataBind();for (int i = 0; i <= gvCardInfo.Rows.Count - 1; i++){DataRowView mydrv;string gIntro;if (gvCardInfo.PageIndex == 0){mydrv = myds.Tables["BBS_Card"].DefaultView[i];gIntro = Convert.ToString(mydrv["CardContent"]);gvCardInfo.Rows[i].Cells[4].Text = SubStr(gIntro, 6);}else{mydrv = myds.Tables["BBS_Card"].DefaultView[i + (5 * gvCardInfo.PageIndex)];gIntro = Convert.ToString(mydrv["CardContent"]);gvCardInfo.Rows[i].Cells[4].Text = SubStr(gIntro, 6);}}sqlcon.Close();}}查询帖子：using System;using System.Data;using System.Data.SqlClient;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;public partial class Search : System.Web.UI.Page{protected void Page_Load(object sender, EventArgs e){if (!IsPostBack){this.bind();}}protected void Button1_Click(object sender, EventArgs e){this.bind();}protected void gvCardInfo_PageIndexChanging(object sender, GridViewPageEventArgs e) {gvCardInfo.PageIndex = e.NewPageIndex;this.bind();}public string SubStr(string sString, int nLeng){if (sString.Length <= nLeng){return sString;}string sNewStr = sString.Substring(0, nLeng);sNewStr = sNewStr + "...";return sNewStr;}protected void gvCardInfo_RowDataBound(object sender, GridViewRowEventArgs e){if (e.Row.RowType == DataControlRowType.DataRow){}}public void bind(){string search = txtsearch.Text;string sqlstr = "select * from bbs_Card where [user]='" + @search + "' ";if (ddltype.SelectedValue.Equals("作者")){ sqlstr = "select * from bbs_Card where [user]='" + @search + "' "; }else if (ddltype.SelectedValue.Equals("标题")){ sqlstr = "select * from bbs_Card where CardName like'%" + @search + "%' "; }else{sqlstr = "select * from bbs_Card where CardDate like'%" + @search + "%' ";}SqlConnection sqlcon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);DataSet myds = new DataSet();sqlcon.Open();myda.Fill(myds, "bbs_Card");gvCardInfo.DataSource = myds;gvCardInfo.DataKeyNames = new string[] { "CardID" };gvCardInfo.DataBind();for (int i = 0; i <= gvCardInfo.Rows.Count - 1; i++){DataRowView mydrv;string gIntro;if (gvCardInfo.PageIndex == 0){mydrv = myds.Tables["BBS_Card"].DefaultView[i];gIntro = Convert.ToString(mydrv["CardContent"]);gvCardInfo.Rows[i].Cells[4].Text = SubStr(gIntro, 6);}else{mydrv = myds.Tables["BBS_Card"].DefaultView[i + (5 * gvCardInfo.PageIndex)];gIntro = Convert.ToString(mydrv["CardContent"]);gvCardInfo.Rows[i].Cells[4].Text = SubStr(gIntro, 6);}}sqlcon.Close();}}八、总结与体会这次web开发让我对网页设计产生了兴趣，在上传头像的时候本想完成上传文件的功能，但对于写入数据库还是比较生疏，所以仅仅做了头像的选择。