ADO Database ASP.Net

  1. Home
  2. ASP.Net
  3. ADO Database
  4. Writing data from the connection with try and catch (C#)
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>

  void Page_Load()
  {
    string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
//    strConnection += @"Data Source=C:\Northwind.mdb";
    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);
    try
    {
      objAdapter.Fill(objDataSet, "Employees");
      DataView objDataView = new DataView(objDataSet.Tables["Employees"]);
      dgNameList.DataSource = objDataView;
      dgNameList.DataBind();
    }
    catch (OleDbException objError)
    {
      if (objError.Message.Substring(0,21) == "Login failed for user")
      {
        divErrorReport.InnerHtml = "Problem with Log-in";
      }
      else if (objError.Message.Substring(0,19) == "Could not find file")
      { 
        divErrorReport.InnerHtml = 
                          "We could not find the MDB file that you asked for"; 
      }
      else
      {
        divErrorReport.InnerHtml =  "message - " + objError.Message;
        divErrorReport.InnerHtml += "source - " + objError.Source;
      }
    }
  }


  
  

Writing data from the connection
    
    to the DataGrid control with error checking.


   

  
  

           
       
EmployeeDatabase.zip( 10 k)