using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
using System.Data.SqlClient;
using System.IO;

public partial class Default3 : System.Web.UI.Page
{
    string strConnString;
    string strConnString1;
    string x;
    string y;
    string connString = "Data Source=CMMM\\SQLEXPRESS;Initial Catalog=Oman;Integrated Security=True";
    protected void Page_Load(object sender, EventArgs e)
    {
    }
    protected void UploadButton1_Click(object sender, EventArgs e)
    {
        if (FileUpload1.HasFile)
        {
            try
            {
                if (FileUpload1.PostedFile.ContentType == "application/vnd.ms-excel")
                {
                    if (FileUpload1.PostedFile.ContentLength < 102400)
                    {
                        string filename = Path.GetFileName(FileUpload1.FileName);
                        FileUpload1.SaveAs(Server.MapPath("~/") + filename);
                        x = Server.MapPath("~/") + filename;
                        if (System.IO.File.Exists(x))
                        {

                            Label1.Text = "A file with the same name already exists.Your file was saved as " + filename;
                        }
                        else
                        {
                            // Notify the user that the file was saved successfully.
                            Label1.Text = "Your file was uploaded successfully.";
                            FileUpload2.SaveAs(Server.MapPath("~/") + filename);
                        }

                    }
                    else
                    {
                        Label1.Text = "Upload status: The file has to be less than 100 kb!";
                    }
                }
                else
                {
                    Label1.Text = "Upload status: Only Excel files are accepted!";
                }
            }
            catch (Exception ex)
            {
                Label1.Text = "Upload status: The file could not be uploaded. The following error occured: " + ex.Message;
            }
        }
    }
    protected void UploadButton2_Click(object sender, EventArgs e)
    {
        if (FileUpload2.HasFile)
        {
            try
            {
                if (FileUpload2.PostedFile.ContentType == "application/vnd.ms-excel")
                {
                    if (FileUpload2.PostedFile.ContentLength < 102400)
                    {
                        string filename = Path.GetFileName(FileUpload2.FileName);
                        
                        y = Server.MapPath("~/") + filename;


                        if (System.IO.File.Exists(y))
                        {

                            Label1.Text = "A file with the same name already exists.Your file was saved as " + filename;
                        }
                        else
                        {
                            
                            Label1.Text = "Your file was uploaded successfully.";
                            FileUpload2.SaveAs(Server.MapPath("~/") + filename);
                        }
                     
                    }
                    else
                    {
                        Label1.Text = "Upload status: The file has to be less than 100 kb!";
                    }
                }
                else
                {
                    Label1.Text = "Upload status: Only Excel files are accepted!";
                }
            }
            catch (Exception ex)
            {
              Label1.Text = "Upload status: The file could not be uploaded. The following error occured: " + ex.Message;
            }
        }
    }

       

    private DataTable  GetTable()
        {

             strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
                         "Data Source=C:\\Projects\\Test\\Book3.xls;" +
                         "Extended Properties=Excel 8.0;";
             strConnString1 = "Provider=Microsoft.Jet.OLEDB.4.0;" +
                                    "Data Source=C:\\Projects\\Test\\Book4.xls;" +
                                    "Extended Properties=Excel 8.0;";

            OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConnString);

            DataSet myDataSet = new DataSet();
            myCommand.Fill(myDataSet, "ExcelInfo");


            OleDbDataAdapter myCommand1 = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConnString1);

            DataSet myDataSet1 = new DataSet();
            myCommand1.Fill(myDataSet1, "ExcelInfo");


            myDataSet.Merge(myDataSet1);

           
      
            DataTable dTable = new DataTable();
            try
            {
                dTable = myDataSet.Tables[0].DefaultView.ToTable("Accounts", true, "ID", "Name");
                CopyDataToDestination(connString, dTable);
            }
            catch (Exception ee)
            {
                // lblMessage.Text = ee.Message.ToString();
            }
            finally
            {
               // p = null;
            }
            return dTable;
       


        }



    private void CopyDataToDestination(String connectionString, DataTable table)
    {

        SqlBulkCopyColumnMapping mapping1 =  new SqlBulkCopyColumnMapping("ID", "ID");
        SqlBulkCopyColumnMapping mapping2 =  new SqlBulkCopyColumnMapping("Name", "Name");
        SqlBulkCopy bulkCopy = new SqlBulkCopy(connectionString);
        bulkCopy.BatchSize = 100;
        bulkCopy.BulkCopyTimeout = 5;
        bulkCopy.ColumnMappings.Add(mapping1);
        bulkCopy.ColumnMappings.Add(mapping2);
        bulkCopy.DestinationTableName = "Test_Excel";
        bulkCopy.SqlRowsCopied += new SqlRowsCopiedEventHandler(bulkCopy_SqlRowsCopied);
        bulkCopy.NotifyAfter = 200;
        bulkCopy.WriteToServer(table);
    }
    void bulkCopy_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e)
    {
        Label1.Text = "Data copied";
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        FetchValue();
    }
    private void FetchValue()
    {
        DataTable dTable = GetTable();

    }
}


 <form id="form1" runat="server">
    <div>
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns=true>
        </asp:GridView>
   
    </div>
        <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
        <asp:FileUpload ID="FileUpload1" runat="server" />
        <asp:Button runat="server" id="UploadButton1" text="Upload" onclick="UploadButton1_Click" />

         <asp:FileUpload ID="FileUpload2" runat="server" />
         <asp:Button runat="server" id="UploadButton2" text="Upload" onclick="UploadButton2_Click" />
<asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" />
    </form>