??????????????????

???????????? ???????[ 2013/4/28 10:17:24 ] ????????

??????excel????????????????????

?????????Excel 97-2003 Workbook(.xls)????????????project??bindebug?????

???????????????????

using System;
using CalculateSalaryProject;
using Microsoft.VisualStudio.TestTools.UnitTesting;

namespace TestProject
{
    [TestClass]
    public class UnitTest2
    {
        private TestContext testContextInstance;
        public TestContext TestContext
        {
            get { return testContextInstance; }
            set { testContextInstance = value; }
        }

        [TestMethod]
        [DeploymentItem("SalesAndSalary.xls")]
        [DataSource(
            "System.Data.Odbc"??
            @"Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=D:DataDrivenTestDemoTestProjectinDebugSalesAndSalary.xls;DefaultDir=."??
            "Sheet1$"??
            DataAccessMethod.Sequential)]
        public void GetSalaryBySalesDataDrivenTest()
        {
            int sales = Int32.Parse(TestContext.DataRow["sales"].ToString());
            Program program = new Program();
            double actualSalary = program.GetTotalSalaryBySales(sales);
            double expectedSalary =Double.Parse(TestContext.DataRow["expectedSalary"].ToString());
            Assert.AreEqual(expectedSalary?? actualSalary);
        }
    }
}

????????????????project?????????System.Data.

??????иò??????????????2???????