<%@ Import Namespace="System" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script Language="c#" runat="server">
void Page_Load()
{
string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += @"Data Source=\\genfs1\www11\etning\xml\Northwind.mdb";
string strSQL = "SELECT * FROM Employees ";
DataSet objDataSet = new DataSet();
OleDbConnection objConnection = new OleDbConnection(strConnection);
OleDbDataAdapter objAdapter = new OleDbDataAdapter(strSQL, objConnection);
objAdapter.Fill(objDataSet, "Employees");
DataView objDataView = new DataView(objDataSet.Tables["Employees"]);
dgNameList.DataSource=objDataView;
dgNameList.DataBind();
}
</script>
<html>
<body>
<h4><%=Request.QueryString["id"]%></h4>
<asp:datagrid id="dgNameList" runat="server"
BackColor="#ffffff"
CellPadding=2
CellSpacing="0"
ShowFooter="true"
Font-Name="?聬I"
Font-Size="10pt"
HeaderStyle-BackColor="#eeaadd"
EnableViewState="false"
AutoGenerateColumns="false"
AllowCustomPaging="false"
>
<HeaderStyle BackColor="#00eeaa"></HeaderStyle>
<FooterStyle BackColor="#aaaadd"></FooterStyle>
<PagerStyle Mode="NumericPages" HorizontalAlign="Right"></PagerStyle>
<SelectedItemStyle BackColor="blue"></SelectedItemStyle>
<ItemStyle BackColor="#ffffee"></ItemStyle>
<AlternatingItemStyle BackColor="#6699ff"></AlternatingItemStyle>
<Columns>
<asp:HyperLinkColumn
HeaderText="Title"
DataNavigateUrlField="Title"
DataNavigateUrlFormatString="datareadasp.aspx?id={0}"
DataTextField="Title"
DataTextFormatString="{0:c}"
/>
</Columns>
</ASP:DataGrid>
</body>
</html>