delete_oledb.aspx font size:
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>

<html>
<head>
<title>Removing a Row of Data (OleDb)</title>
<link rel="stylesheet" href="/shared/netdemos.css">

<style type="text/css">
#zap {
   background:lightgreen; border:thin inset}
</style>

<script language="C#" runat="server">
OleDbConnection myConn = new OleDbConnection ( "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=|DataDirectory|dbtutor.mdb" );
OleDbCommand myCmd = new OleDbCommand ( );
String id;

protected void Page_Load ( object src, EventArgs e ) {
   myCmd.Connection = myConn;
   id = Request.QueryString [ "id" ];
   if ( id == null || IsPostBack ) {
      if ( id == null ) bindGrid ( );
      loadPanel.Visible = true;
      zapPanel.Visible = false;
   }
   else {
      getMessage ( id );
      loadPanel.Visible = false;
      zapPanel.Visible = true;
   }
}

public void bindGrid ( ) {
   myCmd.CommandText = "SELECT * FROM Messages ORDER BY MessageDate desc";
   myConn.Open ( );
   myGrid.DataSource = myCmd.ExecuteReader ( CommandBehavior.CloseConnection );
   myGrid.DataBind ( );
   myConn.Close ( );
}

public void getMessage ( String id ) {
   myCmd.CommandText = "SELECT * FROM Messages WHERE MessageId='" + id + "'";
   myConn.Open ( );
   listDetails.DataSource = myCmd.ExecuteReader ( CommandBehavior.SingleRow );
   listDetails.DataBind ( );
   myConn.Close ( );
}

public void zapMessage ( object src, EventArgs e ) {
   myCmd.CommandText = "DELETE FROM Messages WHERE MessageID=" + id;
   myConn.Open ( );
   myCmd.ExecuteNonQuery ( );
   myConn.Close ( );
   bindGrid ( );
}
</script>
</head>

<body>
<div class="header"><h2>ADO.NET Primer: <b>Removing a Row of Data (OleDb)</b></h2></div>
<!-- #include virtual="~/shared/viewsrc_top.inc" -->
<hr size=1 width=92%>

<br>
<center>
<form runat="server">
<asp:panel id="loadPanel" runat="server">
   <h5>Select a Record to Delete</h5>

   <asp:datagrid id="myGrid" runat="server" 
      width=90% cellpadding=5 gridlines="vertical"
      bordercolor="black" borderwidth=1
      font-size="10pt"
      backcolor="ghostwhite"
      alternatingitemstyle-backcolor="lightgray"
      autogeneratecolumns=false>

      <headerstyle backcolor="darkslategray" 
         forecolor="khaki" height=25 font-bold />

      <columns>
         <asp:boundcolumn headertext="Date" 
            datafield="MessageDate" 
            dataformatstring="{0:d}" />
         <asp:hyperlinkcolumn
            headertext="From"
            datanavigateurlfield="MessageID"
            datanavigateurlformatstring="delete_oledb.aspx?id={0}"
            datatextfield="MessageFrom" />
         <asp:boundcolumn headertext="Subject" 
            datafield="MessageSubject" />
      </columns>
   </asp:datagrid>

   <p align="center"><a href="#top"><img alt="Back to top" border=0 height=32 onmouseover="status='Back to top of page'" src="/shared/top.gif" width=32></a></p>

</asp:panel>

<asp:panel id="zapPanel" runat="server">
   <h5>To remove this record, press Delete.</h5>

         <asp:datalist id="listDetails" width="85%" runat="server"
         <itemtemplate>
            <table id="zap" width=100% cellspacing=1 cellpadding=5 border=0>
            <col width=35% align="right">
            <tr>
               <td>Date:</td>
               <td><b><%# Eval ( "messageDate", "{0:d}" ) %></b></td></tr>
            <tr>
               <td>Name:</td>
               <td><b><%# Eval ( "messageFrom" ) %></b></td></tr>
            <tr>
               <td>Email:</td>
               <td><b><%# Eval ( "Email" ) %></b></td></tr>
            <tr>
               <td>Subject:</td>
               <td><b><%# Eval ( "messageSubject" ) %></b></td></tr>
            <tr>
               <td>Message:</td>
               <td><b><%# Eval ( "messageBody" ) %></b></td></tr>
            </table>
         </itemtemplate>

      </asp:datalist>

      <p>
      <input type=submit value="Delete" runat="server" 
         onServerClick="zapMessage">
      <input type=reset value="Cancel"
         onClick="self.location.replace ( 'delete_oledb.aspx' )"></p>

      </center>

</asp:panel>

</form>
</center>

<hr size=1 width=92%>
<!-- #include virtual="~/shared/viewsrc.inc" -->

</body>
</html>