Use OleDbDataReader retrieve data from database by column name (C#) : OleDbDataReader « ADO.net Database « ASP.Net





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 += "&nbsp;";
       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>

           
       










EmployeeDatabase.zip( 10 k)

Related examples in the same category