引言:
前文已经介绍了用gridview做为显示的三层架构实例,增删改查作为针对数据库的基本和所有操作,很显然有必要给大家说下,gridview这个控件是怎样完成这些操作的。
正文:
类文件用上一篇我所提到的三个类文件,先给出代码:
using
System;
using System.Data;
using System.Configuration;
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)
{
if (!this.IsPostBack)
{
int num = new SLogic().GetNum("select count(sid) from student");
//数据库中的表中没有记录
if (num == 0)
{
Session["pgnum"] = 0;
Session["pg"] = 0;
}
else
{
int pgnum = (num % 3 == 0) ? num / 3 : num / 3 + 1;
Session["pgnum"] = pgnum;
Session["pg"] = 1;
}
GridView1.DataSource = new SLogic().GetList("select top 3 * from student");
GridView1.DataBind();
}
}
//=======================自定义分页==========================
protected void LinkButton1_Click(object sender, EventArgs e)
{
int pgnum = int.Parse(Session["pgnum"].ToString());
int pg = int.Parse(Session["pg"].ToString());
//有数据才能分页
if (pgnum > 0)
using System.Data;
using System.Configuration;
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)
{
if (!this.IsPostBack)
{
int num = new SLogic().GetNum("select count(sid) from student");
//数据库中的表中没有记录
if (num == 0)
{
Session["pgnum"] = 0;
Session["pg"] = 0;
}
else
{
int pgnum = (num % 3 == 0) ? num / 3 : num / 3 + 1;
Session["pgnum"] = pgnum;
Session["pg"] = 1;
}
GridView1.DataSource = new SLogic().GetList("select top 3 * from student");
GridView1.DataBind();
}
}
//=======================自定义分页==========================
protected void LinkButton1_Click(object sender, EventArgs e)
{
int pgnum = int.Parse(Session["pgnum"].ToString());
int pg = int.Parse(Session["pg"].ToString());
//有数据才能分页
if (pgnum > 0)