＜html＞
＜head id="headl" runat="server"＞
＜title＞chapter 2 tio #4 connection failure to access in c#＜/title＞
＜/head＞
＜body＞
＜h3＞chapter 2 tio #4 connection failure to access in c#＜/h3＞
＜form id="forml" runat="server"＞
＜asp:label id="message" runat="server"/＞＜br/＞＜br/＞
＜asp:gridview id="gridviewl" runat="server"
datasourceid="accessdatasourcel"
autogeneratecolumns="true"
emptydatatext="no data records were returned" /＞
＜asp:accessdatasource id="accessdatasourcel" runat="server"
selectcommand="select * from products"
datafile="~/app_data/northwind.mdb"
onselected="accessdatasourcel_selected"
/＞

＜/form＞
＜/body＞＜/html＞

＜%@ page language="c#" %＞
＜script runat="server"＞

void accessdatasourcel_selected(object sender, sqldatasourcestatuseventargs e)
{
　if (e.exception != null)
　{
　　if(e.exception.gettype()==typeof(system.data.oledb.oledbexception))
　　{
　　　message.text = "there was a problem opening a connection to the
　　　database. please contact the system administrator for this site.";

　　　//optionally set gridviewl.visible = false;

　　　e.exceptionhandled = true;
　　}
　}
}

＜/script＞
＜html＞ ...

＜%@ page language="vb" %＞
＜!doctype html public "-//w3c//dtd xhtml 1.1//en"
"http://www.w3.org/tr/xhtmlll/dtd/xhtmlll.dtd"＞

＜script runat="server"＞
sub accessdatasourcel_selected(byval sender as object, byval e as
sqldatasourcestatuseventargs)
　if (not e.exception is nothing) then
　　if typeof e.exception is system.data.oledb.oledbexception then
　　　message. text = "there was a problem opening a connection to the database. please contact the system administrator for this site."

　　　' optionally set gridviewl.visible = false
　　　e.exceptionhandled = true
　　end if
　end if
end sub

＜/script＞
＜html＞ ...