tjdd.aspx.cs

visual stdio 2005

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;

public partial class Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        OleDbConnection cnA = new OleDbConnection();
        cnA.ConnectionString = "provider=Microsoft.Jet.OLEDB.4.0;data source=" + Server.MapPath("~/BDB/BookStore.mdb");
        string cmdtext = "SELECT BNum,BPrice1 FROM BookCar ";
        cnA.Open();
        OleDbCommand cmA = new OleDbCommand(cmdtext, cnA);
        OleDbDataReader dr = cmA.ExecuteReader();
        Int16 yynum = 0;
        Int16 yyprice = 0;
        int yyall = 0;
        while (dr.Read())
        {

            yynum = (Int16)dr.GetValue(0);

            yyprice = (Int16)dr.GetValue(1);

            yyall = yyall + (yynum * yyprice);

        }
        this.Label7.Text = yyall.ToString();

        cnA.Close();          

    }

}