<%@ Import Namespace="System.Data"%> <%@ Import Namespace="System.Data.OleDb"%> <mce:script Language="c#" runat="server"><!-- void Page_Load() { string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;"; strConnection += @"Data Source=Northwind.mdb"; data_src.Text=strConnection; string strSQL = "SELECT * FROM Employees"; string strResultsHolder = ""; OleDbConnection objConnection = new OleDbConnection(strConnection); OleDbCommand objCommand = new OleDbCommand(strSQL,objConnection); OleDbDataReader objDataReader = null; try { objConnection.Open(); con_open.Text="Connection opened successfully.<br />"; objDataReader=objCommand.ExecuteReader(); while(objDataReader.Read()==true) { strResultsHolder += objDataReader["FirstName"]; strResultsHolder += " "; strResultsHolder += objDataReader["LastName"]; strResultsHolder += "<br />"; } objDataReader.Close(); objConnection.Close(); con_close.Text = "<br />Connection closed.<br />"; divListEmployees.InnerHtml = strResultsHolder; } catch(Exception e) { con_open.Text ="Connection failed to open successfully.<br />"; con_close.Text = e.ToString(); } } // --></mce:script> <html> <body> <h4>Reading data from the conneciton<asp:label id="data_src" runat="server" />with the DataReader object.</h4> <asp:label id="con_open" runat="server" /><br /> <div id="divListEmployees" runat="server">list will go here</div> <asp:label id="con_close" runat="server" /><br /> </body> </html>