Reading data from the OleDbConnection in C# : OleDbConnection « Database « ASP.Net

Reading data from the OleDbConnection in 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";
    DataSet objDataSet = new DataSet();
    OleDbConnection objConnection = new OleDbConnection(strConnection);
    OleDbDataAdapter objAdapter = new OleDbDataAdapter(strSQL, objConnection);
    objAdapter.Fill(objDataSet, "Employees");
    DataView objDataView = new DataView(objDataSet.Tables["Employees"]);
  <h4>Reading data from the connection 
  <asp:label id="data_src" runat="server"/> to the DataGrid control.</h4>
  <asp:datagrid id="dgNameList" runat="server" /><br />

       10 k)

Related examples in the same category

1.Working with Transactions with OleDbConnection (
2.Try to connect to access database through OleDbConnection (
3.Read data from OleDbConnection (