ADO Database ASP.Net

  1. Home
  2. ASP.Net
  3. ADO Database
  4. Reading data from the OleDbConnection in C#
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>

  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"]);
    dgNameList.DataSource=objDataView;
    dgNameList.DataBind();
  }


  
  

Reading data from the connection 
   to the DataGrid control.


  
  

           
       
EmployeeDatabase.zip( 10 k)