在session状态中保存数据库数据
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="SessionDataView.aspx.cs" Inherits="WebApplication1.SessionDataView" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Web.Configuration" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title></title>
<script runat="server">
DataView sName;
void Page_Load()
{
sName = (DataView)Session["class"];
if (sName == null)
{
string conString = WebConfigurationManager.ConnectionStrings["class"].ConnectionString;
SqlDataAdapter dad = new SqlDataAdapter("select * from class", conString);
DataTable dtblMovies = new DataTable();
dad.Fill(dtblMovies);
sName = new DataView(dtblMovies);
Session["class"] = sName;
}
}
protected void grdMovies_Sorting(object sender, GridViewSortEventArgs e)
{
sName.Sort = e.SortExpression;
}
void Page_PreRender()
{
grdMovies.DataSource = sName;
grdMovies.DataBind();
}
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="grdMovies" AllowSorting="true" EnableViewState="false" OnSorting="grdMovies_Sorting" runat="server" />
<br />
<asp:LinkButton ID="lnkReload" Text="Reload Page" runat="server" />
</div>
</form>
</body>
</html>
posted on 2016-05-26 11:10 Floatbarrier 阅读(218) 评论(0) 编辑 收藏 举报
