ViewPersons Source Code

PersonInfo Example, source code file view-persons.aspx

<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>

// Create and populate DataSet object.
    DataSet ds = new DataSet( );    
    int n = da.Fill(ds, "Persons");

// Display data in DataGrid object.
    dgPersons.DataSource = ds;
    dgPersons.DataBind( );
}

public void btnClear_Click(object sender, EventArgs e)
{
    // Create and configure connection string.
    OleDbConnection c = new OleDbConnection();
    c.ConnectionString =
        "Provider=Microsoft.ACE.OLEDB.12.0;" +
        "Data Source=e:/ectserver/sjost/Database/persons-data.accdb;";

// Open connection.
    c.Open();

// Compose SQL command string.
    string sql = "DELETE * FROM Persons";

// Create command object and execute insert statement.
    OleDbCommand command = new OleDbCommand(sql, c);
    command.ExecuteNonQuery();

// Close connection.
    c.Close();   
}
</script>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>View Person Data</title>
<link rel="stylesheet" type="text/css" href="../examples.css" />
</head>

<body>
<h2>View Person Data</h2>