How to import excel sheet into gridview using c# code in asp.net

.aspx page

1. <table width="100%" cellpadding="0" cellspacing="0">  
2.                     <tr>  
3.                         <td align="left" class="text" style="width: 114px;">  
4.                            Import Data from Excel File  
5.                         </td>  
6.                         <td align="left">  
7.                             <asp:FileUpload ID="uploadExcel" runat="server" />  
8.                             &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  
9.                             <asp:Button ID="btnImport" runat="server" Text="Import Data" OnClick="btnImport_Click" />  
10.                         </td>  
11.                     </tr>  
12.                     <tr>  
13.                         <td>  
14.                             <asp:GridView ID="GridView1" runat="server">  
15.                                 <Columns>  
16.                                     <asp:TemplateField HeaderText="First Name">  
17.                                         <ItemTemplate>  
18.                                             <asp:Label ID="lblFirstName" runat="server" Text='<%# Bind("first_name") %>'></asp:Label>  
19.                                         </ItemTemplate>  
20.                                         <ItemStyle HorizontalAlign="Left" />  
21.                                     </asp:TemplateField>  
22.                                     <asp:TemplateField  HeaderText="Last Name  
23.                                         <ItemTemplate>  
24.                                             <asp:Label ID="lblLastName" runat="server" Text='<%# Bind("last_name") %>'></asp:Label>  
25.                                         </ItemTemplate>  
26.                                         <ItemStyle HorizontalAlign="Left" />  
27.                                     </asp:TemplateField>  
28.                                     <asp:TemplateField  HeaderText="Gender">  
29.                                         <ItemTemplate>  
30.                                             <asp:Label ID="lblGender" runat="server" Text='<%# Bind("gender") %>'></asp:Label>  
31.                                         </ItemTemplate>  
32.                                         <ItemStyle HorizontalAlign="Center" />  
33.                                     </asp:TemplateField>  
34.                                 </Columns>  
35.                             </asp:GridView>  
36.                         </td>  
37.                     </tr>  
38.                 </table>  

.cs file code

1. using System;  
2. using System.Collections.Generic;  
3. using System.Web;  
4. using System.Web.UI;  
5. using System.Web.UI.WebControls;  
6. using System.Data.OleDb;  
7. using System.Data;  
8. using System.Data.SqlClient;  
9. using System.Data.Common;  
10. using System.Configuration;  
11.   
12. protected void btnImport_Click(object sender, EventArgs e)  
13.     {  
14.         try  
15.         {  
16.             string path = uploadExcel.FileName;  
17.             uploadExcel.SaveAs(Server.MapPath("~/Upload/" + path));  
18.             OleDbConnection oconn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath(path)+";Extended Properties=Excel 8.0");                  
19.             oconn.Open();      
20. //Getting records from Sheet1 of excel file. As you know one excel file may have many sheets                      
21.             OleDbCommand ocmd = new OleDbCommand("select * from [Sheet1$]", oconn);  
22.             DataSet ds = new DataSet();  
23.             OleDbDataAdapter odapt = new OleDbDataAdapter(ocmd);  
24.             odapt.Fill(ds);  
25.             GridView1.DataSource = ds;  
26.             GridView1.DataBind();  
27.             oconn.Close();              
28.         }  
29.         catch(Exception exp)  
30.         {  
31.             throw exp;  
32.         }              
33.     }