using System;
using System.Collections.Generic;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.OleDb;
using System.Data;

public partial class Test_Default4 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
            string filename = @"D:\FrontierExcelCatalog_003.xls";
            string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;" +
                             "Data Source=" + filename + ";" +
                             "Extended Properties=Excel 12.0;HDR=Yes;";

            OleDbConnection conExcel = new OleDbConnection(strConn);
            DataSet myDataSet = new DataSet();
            OleDbDataAdapter dataAdapter = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", conExcel);
            conExcel.Open();
            dataAdapter.Fill(myDataSet);
            DataTable dataTable = myDataSet.Tables[0];
            var query = from r in dataTable.AsEnumerable()
                        select new
                        {
                            ClientName = r.Field<string>("Item_Number")
                        };

            Label1.Text = query.Count().ToString();

            //foreach (var item in query)
            //{
            //    Console.WriteLine(item.ClientName);
            //}
    }
}