Catch-database-operation-exceptions-for-data-binding

ADO Database ASP.Net


            <%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.Oledb" %>

Sub Page_Load()
  Dim strConnection as String = "Provider=Microsoft.Jet.OLEDB.4.0;"
    strConnection += "Data Source=C:\Northwind.mdb"
    data_src.text = strConnection
  Dim strSQL as string = "SELECT FirstName, MiddleName, LastName FROM Employees;"
  Dim objDataSet as new DataSet()
  Dim objConnection as new OledbConnection(strConnection)
  Dim objAdapter as new OledbDataAdapter(strSQL, objConnection)
Try
  objAdapter.Fill(objDataSet, "Employees")
  
  Dim objDataView as New DataView(objDataSet.Tables("Employees"))
  
  dgNameList.DataSource=objDataView
  dgNameList.DataBind()
Catch objError as OledbException
  If Left(objError.Message,21)="Login failed for user" Then 
    divErrorReport.InnerHTML = "Problem with Log-in"
  ElseIf Left(objError.Message,19)="Could not find file" Then 
    divErrorReport.InnerHTML = "We could not find the MDB file that you asked for"
  Else
    divErrorReport.InnerHTML =  "message - " & objError.Message
    divErrorReport.InnerHTML += "source - " & objError.Source
  End If
End Try
end Sub


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

ADO Database ASP.Net

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

Writing data from the connection

to the DataGrid control with error checking.