求救。。。老大们进来帮帮小弟。。。
<%@ Page Language= "C# " AutoEventWireup= "true " CodeFile= "Default4.aspx.cs " Inherits= "Default4 " %>
<%@ Import Namespace= "System.Data " %>
<%@ Import Namespace= "System.Data.OleDb " %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN " "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd ">
<script language= "C# " runat= "server ">
OleDbConnection MyConn;
public void Page_Load(Object src, EventArgs e)
{
string MyConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + Server.MapPath( "db1.mdb ");
MyConn = new OleDbConnection(MyConnString);
MyConn.Open();
if (!Page.IsPostBack)
{
BindGrid();
}
}
ICollection CreateTable()
{
string strSel = "select * from Score ";
DataSet ds = new DataSet();
OleDbDataAdapter MyAdapter = new OleDbDataAdapter(strSel,MyConn);
MyAdapter.Fill(ds, "Score ");
return ds.Tables[ "Score "].DefaultView;
}
public void BindGrid()
{
DataView dv = (DataView)CreateTable();
usrGrid.VirtualItemCount = dv.Count;
usrGrid.DataSource = dv;
usrGrid.DataBind();
}
public void DataGrid_PageChanged(Object sender, DataGridPageChangedEventArgs e)
{
usrGrid.CurrentPageIndex = e.NewPageIndex;
BindGrid();
}
</script>
<html xmlns= "http://www.w3.org/1999/xhtml " >
<head runat= "server ">
<title> 无标题页 </title>
</head>
<body> <