ASP.Net/ADO.net Database/OleDbDataReader
Use OleDbDataReader retrieve data from database by column name (C#)
<source lang="csharp">
<%@ 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.
";
objDataReader = objCommand.ExecuteReader();
while (objDataReader.Read() == true)
{
strResultsHolder += objDataReader["FirstName"];
strResultsHolder += " ";
strResultsHolder += objDataReader["LastName"];
strResultsHolder += "
";
}
objDataReader.Close();
objConnection.Close();
con_close.Text = "
Connection closed.
";
divListEmployees.InnerHtml = strResultsHolder;
}
catch (Exception e)
{
con_open.Text = "Connection failed to open successfully.
";
con_close.Text = e.ToString();
}
} </script> <html>
<body>
Reading data from the connection <asp:label id=data_src runat=server/> with the DataReader object.
<asp:label id=con_open runat=server/>
list will go here
<asp:label id=con_close runat=server/>
</body>
</html>
</source>
<A href="http://www.nfex.ru/Code/ASPDownload/EmployeeDatabase.zip">EmployeeDatabase.zip( 10 k)</a>
