ASP.NET

public static void insertdata()
       {
   string strfilename = "~\\Documents\\" + ViewState["MissionCat"];
    string strexcelConnectionString=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath(strfilename) + "; Extended Properties=\"Excel 8.0;HDR=YES;IMEX=1;\"";
    string strsqlConnectionString = ConfigurationManager.ConnectionStrings["conn"].ToString();

       using (OleDbConnection connection = new OleDbConnection(strexcelConnectionString))
           {
               connection.Open();
               OleDbCommand command = new OleDbCommand("Select [Mission] ,[Civilian] ,[Military] ,[Police],[Unknown] ,[Non-UN] ,[Total] FROM [Sheet1$]", connection);
               //truncate the table before inserting new data.
               SqlConnection cnntrunc = new SqlConnection(strsqlConnectionString);
               //open the connection.
               cnntrunc.Open();
               //begin the transaction.
               SqlTransaction myTrans = cnntrunc.BeginTransaction();  //New a transaction
               SqlCommand truntble = new SqlCommand();
               truntble.Transaction = myTrans;
               truntble.Connection = cnntrunc;
               try
               {
                   //Create DbDataReader to Data Worksheet.
                   using (DbDataReader dr = command.ExecuteReader())
                   {
                       truntble.CommandText = "DELETE FROM MissionCatReport";
                       truntble.ExecuteNonQuery();
                       //commit the transaction.
                       myTrans.Commit();
                       //Bulk Copy to SQL Server.
                       using (SqlBulkCopy bulkCopy = new SqlBulkCopy(strsqlConnectionString))
                       {
                           bulkCopy.DestinationTableName = "MissionCatReport";
                           bulkCopy.WriteToServer(dr);
                       }
                   }
               }
               catch (OleDbException ex)
               {
                   myTrans.Rollback();
                   throw ex;
               }
               catch (InvalidOperationException ex)
               {
                   myTrans.Rollback();
                   throw ex;
               }
               finally
               {
                   cnntrunc.Close();
               }
           }
       }