oledbdataadapter.aspx

asp.net技术内幕的书配源码

<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>

<script runat=server>
void Page_Load(Object sender , EventArgs e) 
{
	DataSet dstAuthors;
	OleDbConnection conAuthors;
	OleDbDataAdapter dadAuthors;

	dstAuthors = new DataSet();
	conAuthors = new OleDbConnection( "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=c:\\Authors.mdb" );
	dadAuthors = new OleDbDataAdapter( "Select * From Authors", conAuthors );
	dadAuthors.Fill( dstAuthors, "Authors" );
	Response.Write("Authors Table added to DataSet!");
}
</script>