ASP.Net/ADO.net Database/OleDbDataReader
Use OleDbDataReader retrieve data from database by column name (C#)
<%@ 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="+MapPath("EmployeeDatabase.mdb");
data_src.Text = strConnection;
string strSQL = "SELECT FirstName,LastName FROM Employee";
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();
}
}
</script>
<html>
<body>
<h4>Reading data from the connection
<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>
<A href="http://www.nfex.ru/Code/ASPDownload/EmployeeDatabase.zip">EmployeeDatabase.zip( 10 k)</a>
