Home
Browse all 647 examples
Download all 647 examples
Download sample chapters
Reviews
Errata
Acknowledgments
Links on .NET
Paradoxal Press
Buy directly from Paradoxal Press at $33.99 (Save 43%)
Category: Programming
Level: Beginner to seasoned
900 pages
ISBN-10 097661322-0
ISBN-13 978-097661322-0
$59.99 USA
$79.99 CANADA
|
Listing 23-54 extracted from chapter ASP.NET 2
Listing 23-53< > Listing 23-55
Example_23_54.aspx
<%@ Page Language="C#" %>
<%@ Import Namespace ="System.Data" %>
<%@ Import Namespace ="System.Data.Common" %>
<%@ Import Namespace ="System.Data.SqlClient" %>
<script runat="server">
protected void Page_Load(object sender, EventArgs e) {
DataView dv = Cache["Employees"] as DataView;
if ( dv == null ) {
using ( DbDataAdapter dAdapter = new SqlDataAdapter(
"SELECT * FROM EMPLOYEES",
"server = localhost ; uid=sa ; pwd =; database = ORGANIZATION") ) {
DataSet ds = new DataSet();
dAdapter.Fill( ds );
dv = ds.Tables[0].DefaultView;
dv.AllowDelete = false;
dv.AllowEdit = false;
dv.AllowNew = false;
Cache["Employees"] = dv;
} // end using dAdapter.
}
else Response.Write( "Loaded from cache!" );
MyList.DataSource = dv;
MyList.DataTextField = "SurName";
DataBind();
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<body>
<form id="Form1" runat="server">
<asp:ListBox ID="MyList" runat="server"/>
</form>
</body>
</html>
Copyright Patrick Smacchia 2006 2007
|