resolve the address to the Access database

 // resolve the address to the Access database
            string fileNameString = this.MapPath(".");
            fileNameString += "..\\..\\..\\..\\data\\chartdata.mdb";

            // initialize a connection string 
            string myConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileNameString;

            // define the database query 
            string mySelectQuery;
            mySelectQuery = "SELECT REGIONS.RegionName, Sum(REPS_SALES.Sales) AS SumOfSales ";
            mySelectQuery += "FROM REPS_SALES INNER JOIN REGIONS ON REPS_SALES.RegionID = REGIONS.RegionID ";
            mySelectQuery += "GROUP BY REGIONS.RegionName;";

            // create a database connection object using the connection string 
            OleDbConnection myConnection = new OleDbConnection(myConnectionString);

            // create a database command on the connection using query 
            OleDbCommand myCommand = new OleDbCommand(mySelectQuery, myConnection);

            // open the connection 
            myCommand.Connection.Open();

            // create a database reader 
            OleDbDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);

            // since the reader implements and IEnumerable, pass the reader directly into
            // the DataBind method with the name of the Column selected in the query 
            Chart1.Series["Sales"].Points.DataBindXY(myReader, "RegionName", myReader, "SumOfSales");

            // close the reader and the connection
            myReader.Close();
            myConnection.Close();