private void Page_Load(object sender, System.EventArgs e)
        {
            DataSet objds        = null;
            OleDbConnection conn = null;
            try
            {            
                if (File.Exists(Server.MapPath("UploadedFare/UploadedFare.xls").Trim()))
                {
                    gblConnSting = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath
                     ("UploadedFare/UploadedFare.xls").Trim() + ";Extended Properties=\"Excel 8.0;HDR=YES;\"";
                    conn    = new OleDbConnection(gblConnSting);;
                                    
                    conn.Open();
                    objds = new DataSet();
                    OleDbDataAdapter objAdp    = new OleDbDataAdapter("select * from [Sheet1$] where 
                                                                     [Airline] <> '' OR [Airline] <> null",conn);
                    objAdp.AcceptChangesDuringFill  = false;
                    objAdp.Fill(objds);        
                    dgExcelData.DataSource    = objds.Tables[0].DefaultView;
                    dgExcelData.DataBind();
                }
                else
                    Response.Write("<B>No Fare Is Uploaded !</B>");
            }
            catch(Exception ex)
            {
                new clsErrorLogging(ex);
            }        
            finally
            {
                dgExcelData.Dispose();
                objds.Dispose();
                conn.Dispose();
            }
        }

Datagrid

       <asp:datagrid id="dgExcelData" runat="server" HeaderStyle-Wrap="False" BorderColor="LightGray"
        BorderWidth="1px">
        <ItemStyle Font-Size="X-Small" Wrap="False"></ItemStyle>
        <HeaderStyle Font-Size="Smaller" Font-Names="Verdana" Font-Bold="True" Wrap="False" HorizontalAlign="Center"
         ForeColor="Black" VerticalAlign="Middle" CssClass="tableheadergrey2" BackColor="Gainsboro" ></HeaderStyle>
       </asp:datagrid>