voting-machine3.axpx Source Code

voting-machine3.aspx Source Code

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

public void btnClearTotals_Click(object sender, EventArgs e)
{
    // Create and configure connection string.
    OleDbConnection conn = new OleDbConnection( );
    conn.ConnectionString = 
        Provider=Microsoft.Jet.OLEDB.4.0; +
        Data Source=e:/ectserver/sjost/Database/vote-totals.mdb;
    conn.Open( );

// Update vote total.
    string sql = UPDATE Totals SET VoteTotal = 0;;
    OleDbCommand command = new OleDbCommand(sql, conn);
    command.ExecuteNonQuery();
    litResults.Text = Totals reset.;
    conn.Close( );
}

public void btnCastVote_Click(object sender, EventArgs e)
{
    // Create and configure connection string.
    OleDbConnection conn = new OleDbConnection( );
    conn.ConnectionString = 
        Provider=Microsoft.Jet.OLEDB.4.0; +
        Data Source=e:/ectserver/sjost/Database/vote-totals.mdb;
    conn.Open( );

// Update vote total.
    string sql = ;
    if (radMcCain.Checked)
    {
        sql = UPDATE Totals SET VoteTotal = VoteTotal + 1  +
              WHERE CandidateName = 'McCain';;
        litResults.Text = Vote cast for McCain.;
    }
    else
    {
        sql = UPDATE Totals SET VoteTotal = VoteTotal + 1  +
              WHERE CandidateName = 'Obama';;
        litResults.Text = Vote cast for Obama.;
    }
    OleDbCommand command = new OleDbCommand(sql, conn);
    command.ExecuteNonQuery();
    conn.Close( );
}

public void btnShowTotals_Click(object sender, EventArgs e)
{
    // Create and configure connection string.
    OleDbConnection conn = new OleDbConnection( );
    conn.ConnectionString = 
        Provider=Microsoft.Jet.OLEDB.4.0; +
        Data Source=e:/ectserver/sjost/Database/vote-totals.mdb;

// Create and configure SelectCommand object.
    OleDbCommand sc = conn.CreateCommand( );
    sc.Commandclass = Commandclass.Text;
    sc.CommandText = SELECT * FROM Totals;

// Create DataAdapter object.
    OleDbDataAdapter da = new OleDbDataAdapter( );
    da.SelectCommand = sc;

// Create and populate DataSet object.
    DataSet ds = new DataSet( );
    int nrows = da.Fill(ds, Totals);

// Write totals to Literal controls.
    DataRow r1 = ds.Tables[Totals].Rows[0];
    string name1 = (string) r1.ItemArray[0];
    int total1 = (int) r1.ItemArray[1];
    DataRow r2 = ds.Tables[Totals].Rows[1];
    string name2 = (string) r2.ItemArray[0];
    int total2 = (int) r2.ItemArray[1];
    litResults.Text = Total votes for  + 
        name1 + :  + total1 + .<br />;
    litResults.Text += Total votes for  + 
        name2 + :  + total2 + .;
}

</script>

<html>

<head>
<title>voting-machine3.aspx Example</title>
<link rel=stylesheet class=text/css 
                       href=examples.css />
</head>

<body>

<h2>voting-machine3.aspx Example</h2>

<h3>Keep track of vote totals in a database.</h3>

<table>

</form>
</body>
</html>