在DataGrid里显示Excel文件数据

    using System.Data.OleDb;

private void Page_Load(object sender, System.EventArgs e)
        {
            // 在此处放置用户代码以初始化页面
            if(!IsPostBack) 
            {
                SetBind() ;
            }
        }


        protected void SetBind() 
        {
            try
            {
                string strConn; 
                strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" 
                    +"Data Source=c:\\abc.xls;" 
                    +"Extended Properties=Excel 8.0;"; 
                OleDbDataAdapter myCommand   = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn); 
                DataSet myDataSet = new DataSet(); 
                myCommand.Fill( myDataSet, "mobile"); 
                DataGrid1.DataSource = myDataSet.Tables["mobile"].DefaultView; 
                DataGrid1.DataBind();
            }
            catch (Exception ex)
            {
                Label1.Text = ex.ToString();
            }
        }

        private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
        {
            this.DataGrid1.CurrentPageIndex =   e.NewPageIndex;
            SetBind() ;
        }

        private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
        {
            if(e.Item.ItemType == ListItemType.Item | e.Item.ItemType == ListItemType.AlternatingItem )
            {
               
                e.Item.Attributes.Add("onmouseover","this.style.backgroundColor='Silver' ");
                e.Item.Attributes.Add("onmouseout","this.style.backgroundColor='white' ");
                        }
            }

参考:http://www.bjcan.com/hengxing/readlou.asp?id=1092