C# Corner

Resources  
  • Using Custom Document Template And Quick Parts To Get Column Values From SharePointNov 17, 2017. Quite often there is situation when user wants to save documents with metadata in SharePoint library and to accomplish this we can use document template, customize it and by using Quick parts in Microsoft office we can save Meta data in library and in Microsoft office documents.
  • How To Save Office 365 Email Attachment To OneDrive With Microsoft FlowNov 16, 2017. Microsoft Flow is a cloud-based service. It allows us to react to an event in one and do something with the data from that event into another one Service. It makes it practical and simple for line-of-business. The users build workflows that automatically do some business tasks and processes across applications and services.
  • Creating A Data Science Virtual Machine(DSVM) On The Azure PortalNov 16, 2017. This article describes what a Data Science Virtual machine is and demonstrates how to create it in the azure portal.
  • Build Intelligent Apps with Microsoft Data PlatformNov 16, 2017. Learn how to build intelligent apps using Microsoft data platform and tools.
  • Two Way Data Binding In Angular Without $scope Object Using MVCNov 16, 2017. Data binding is the most useful and powerful feature among any of the existing or upcoming software development technologies. It is actually a process that bridges a connection between the view and business logic of the application.Basically we will see one-way and two-way data binding with respect to AngularJS applications. But before we jump to that section we will try to learn something about the scopes in AngularJS.
  • Auto Complete with ngTagInput using Web API in AngularJSNov 16, 2017. AutoComplete,ngTagInput,Web API,AngularJS,AutoComplete in AngularJS using Web API
  • Building A Questionnaire Site With Node.jsNov 14, 2017. This was our first project with Node.js, and by God, it was a pain. Node.js is an excellent framework, with blazing fast speed, and an intuitive development framework. For those who are familiar with HTML, CSS and JavaScript, Node.js is one of the best alternatives to PHP, ASP.NET or other server-side scripting languages that require a language to be learnt. Node.js is light-weight, resilient and community-led and in-development framework. This article is primarily focused on teaching the beginners in Node.js development. You can expect to learn a few basics of Node.js setup, how to manage the databases in Node.js environment and a bit more (less too, maybe).
  • Server Side Custom Paging In Angular-UI Grid Using Web APINov 13, 2017. In this article, you will learn how to implement server side custom paging using Angular UI-Grid with Web API and SQL Server database and stored procedure. In this article, I will demonstrate server side paging and sorting only, Filtering we should learn in next article.
  • Custom Search Using Client Side CodeNov 11, 2017. The Custom Search functionality is achieved through JS. The Search produces live results for each key press. This search can be used to filter the data table or html table data dynamically based on the key words entered. The below code explains the search for html table.
  • Get Your Hands On Entity Framework Code First Workflow With New Database And Existing DatabaseNov 10, 2017. In this article we are going to learn how to create code first workflow with new database and existing database.
  • Upload/ Download Files In ASP.NET Core 2.0Nov 10, 2017. ASP.NET Core MVC model binding provides IFormFile interface to upload one or more files. The HTML form must have encoding type set to multipart/form-data and an input element with type attribute set to file.
  • Masking Sensitive Data With SQL Server 2016Nov 10, 2017. SQL Server 2016 has many features which you can use to make your data and application more secure, more maintained and easily retrieved as per your requirements. It has introduced both client side security such as Always Encrypted as well as server side security such as Data masking etc. In this post we’ll examine how Dynamic Data Masking can help secure our data.
  • How To Bind Data To Controls Inside Bootstrap Popup Using ASP.NET WebServicesNov 09, 2017. This article describes how to bind controls inside bootstrap popup using webservices in asp.net
  • Azure Data Factory - ETL Solution To Azure DB And To Azure SQL Data WarehouseNov 09, 2017. In this article we will learn how to use Azure Data Factory to Extract, Transform, Load (ETL) data especially for the data warehousing purposes.
  • Working With View Components In ASP.NET Core MVCNov 09, 2017. View component is newly introduced feature in asp.net core MVC. It is very similar to partial view but it very powerful compared to partial view. It does not use model binding but works only with the data we provide when calling into it.
  • Power BI And Excel File As Data SourceNov 06, 2017. Though we have several options for data sources to connect with Power BI in this blog, I am going to write about how we can use Excel data with Power BI and how to refresh the report when Excel data is changed.
  • Step By Step Guide To Setup Sample SSAS Multi Dimension CubeNov 06, 2017. Create one Windows account and give full access to that account to read OLTP database or add an account on which SSAS Service is running and give full permission to that account for OLTP Database.
  • If The Boot Configuration Data For Your PC Is Missing Or Contains ErrorsNov 06, 2017. The Boot Configuration Data (BCD) is a firmware-independent database for boot-time configuration data. It is used as new Windows Boot Manager. It replaces the "boot.ini" file that was used in the old Operating System. For more details check Windows startup process.
  • Power BI On-Premises Server Installation And ConfigurationNov 06, 2017. On October 31, 2017 Microsoft released the latest version of Power BI report server, in this version on-premises reports can connect to different data sources (SQL Server, Oracle, SAP HANA ...Etc.). Users can also use direct Query option or import data option and create schedule to refresh the imported data. This article will give the step by step process to install and configure a Power BI on premises server.
  • Retrieve User Profile Properties Using SPFx And PnP JS In SharePoint OnlineNov 05, 2017. SharePoint Framework is the new development model in which a lot of work has been going on since it went to General Availability on Feb 23, 2017. It is a page and web part model that provides full support for client-side SharePoint development, easy integration with SharePoint data and support for open source tooling. With the SharePoint Framework, you can use modern web technologies and tools in your preferred development environment to build productive experiences and apps in SharePoint.
  • Create An Azure SQL Database Using PowerShellNov 03, 2017. A resource group is a logical container into which Azure resources are deployed and managed as a group. So let's create a resource group for that using New-AzureRmResourceGroup command.
  • How To Create A SQL Database In AzureNov 03, 2017. In this article you will see how to create an Azure SQL Database in the Azure portal. Azure SQL Database is a relational database-as-a-service which provides high performance, reliable and secure database used to build data-driven applications and websites.
  • Implementation Of Stack And Queue Using Linked ListNov 02, 2017. In this article, I will be discussing two data structures - Stack and Queue and their implementation using another data structure - Linked List.
  • Introduction To ASP.NET MVC Model BindingNov 02, 2017. Asp.NET MVC model binder allow you to map http request data with model. HttpRequest data means when user makes a request with form data from browser to controller at that time model binder works as middle man to map the incoming http request with controller action method.
  • Populating A ListView With Data Using Kendo Listview And Entity Framework In ASP.NET MVC 5Oct 31, 2017. Here, I am going to demonstrate how to load the data from a database to Kendo listview in ASP.Net MVC5.
  • Create Charts In PowerPoint Using C#Oct 31, 2017. When it comes to PowerPoint presentation, charts are an import thing. Because charts can visualize large amount of complex data, which is helpful for data comparison and analysis. This article focuses on how to create most commonly used chart types (including column chart, pie chart and combination chart) by using .NET Presentation library in your C# applications.
  • Getting Started With Azure Cosmos DBOct 29, 2017. Azure Cosmos DB is a globally distributed database service designed to enable you to elastically and independently scale throughput and storage across any number of geographical regions with a comprehensive SLA. You can develop document, key/value, or graph databases with Cosmos DB using a series of popular APIs and programming models.
  • How To Use ServerSide Processing With jQuery DatatableOct 29, 2017. Create one WebService to Getdata(Here I am using asp.net WebService to get data). You can see my Solution Explorer . I have two web pages and one service, and the name of the service is webService.asmx.
  • One-Way And Two-Way Data Binding With Examples In AngularOct 27, 2017. In Angular 2, Data Binding is mainly classified in two ways, namely One-Way binding (i.e. unidirectional binding) and two-way binding (i.e. bi-directional binding).
  • How To Do 'LinkedIn Connection Analytics' Using Power BI Oct 26, 2017. Learn to use new free 'LinkedIn Connection Analytics' dashboard with Power BI.
  • Cloud Databases In Azure - Part ThreeOct 24, 2017. This is the third article in the “Azure Cloud Databases” articles series, which is in continuation of the previous two articles.
  • Generate PDF From An HTML Page Using AngularOct 24, 2017. In this article, I am going to explain how to generate PDF file from an HTML page using AngularJS in SharePoint. This is the effortless way to port the SharePoint list data or any other list data to carry, print, and make a hard copy.
  • How To Return A Pair Of Closest Birthdates Using API, Multi Threading And MVC 5 Using C#.NETOct 18, 2017. This article demonstrates how to use multi-threading to return the name of 2 customers who have the closest birthdate. I also include how create API to add\ retrieve customer details from SQL database using tasks and how to use MVC to call and API to add a new customer.
  • Basic Introduction To Power BIOct 17, 2017. In this article I will discuss the fundamental concepts of Power BI. So this article will cover basic knowledge on power BI, the need of power BI, the importance of data visualizations, the components of Power BI, the architecture of Power BI, the building blocks of Power BI & the cost of power BI tools.
  • Power BI - Get Data From SharePoint List / LibraryOct 16, 2017. In this article, we will explore two methods to get data from SharePoint List / Library in Power BI.
  • Cloud Databases In Azure - Part TwoOct 16, 2017. In the first article of this series, I explained about how to create SQL Database in Azure. I recommend you read the first article.
  • Let's Move 'On-Prem' Data Warehouse To 'Azure SQL Data Warehouse' With Redgate Data Platform Studio (DPS)Oct 13, 2017. In this article we will learn how to migrate ‘On-Prem’ data warehouse to the Cloud, specifically Azure SQL Data warehouse. I will share the lessons learned and some do’s and don’ts from my experience that may be helpful.
  • Get To Know The New Microsoft SharePoint Migration ToolOct 13, 2017. For many years SharePoint Migration has been a very challenging task for all the SharePoint professionals as it really requires a lot of planning, assessment and careful implementation to ensure that the data remains secure and it doesn’t get missed during the migration.
  • T-SQL - Retrieve Task Hierarchy In Project ServerOct 12, 2017. In this article, we will show how to get the Task Hierarchy for a Specific Project in Project Server Database using SQL
  • ASP.NET Core 2.0 CachingOct 12, 2017. Caching frequently used data can improve the performance of a web application. For applications hosted on multiple servers, using distributed caching means the application can access data regardless of the instance server. Caching should be considered an alternate to using Session State.
  • Getting Started With Entity Framework Core - Database-First DevelopmentOct 12, 2017. This article is the first part of the series on Getting Started with Entity Framework Core. In this post, we will build an ASP.NET Core MVC application that performs basic data access using Entity Framework Core. We will explore the database-first approach and see how models are created from an existing database. We will also take a look at how classes become the link between the database and ASP.NET Core MVC Controller.
  • Logging Exception in Database Using CustomFilter ExceptionOct 11, 2017. As per request from one of my followers I am writing this article, which will explain how we can handle Errors in an MVC application. In this article I am also going to explain how we can log our exception message in our Data Base.
  • Excel To XML Using LINQOct 11, 2017. In this article we will show you the easiest way to convert Excel data into Xml files. There is a certain way to convert Excel file to Xml, for example using Excel Library (Com Component)
  • Cloud Databases In Azure - Part OneOct 11, 2017. In my previous articles on Azure, I have explained about the IaaS features of Azure i.e. creating Virtual Machines, databases etc. In this article, we will see the Introduction of Cloud Databases i.e. PaaS side of Microsoft Azure.
  • Linked List Implementation In C#Oct 09, 2017. In this article, I will discuss one of the most important Data structures- Linked List.
  • How To Connect Facebook to Twitter With Microsoft FlowOct 08, 2017. Microsoft Flow is a cloud-based service. It allows us to react to an event in one place and do something with the data from that event in another one service.
  • How To Use DataList Control In ASP.NET With Example in C#Oct 08, 2017. In this article I’ll present a tutorial with an example, a way to use the DataList control in Asp.Net for the displaying of information/ records from the database with using SqlDataSource.
  • Managing Virtual Machine DisksOct 08, 2017. In this article, we will see how to add additional data disks and scale existing in a Virtual Machine.
  • How To Implement Dependency Injection In MVC ProjectOct 07, 2017. Here I am going to explain how to implement dependency injection in MVC Project in detail including separate layers for getting data through Services and Repositories.
  • ASP.NET - Connect to MySQL Azure DatabaseOct 07, 2017. Using MVC, Entity Framework, ASP.NET Scaffolding, and Azure MySQL you can create a web application that stores your information on an MongoDB Azure database. This demo shows you how to create a web application with MVC and Entity Framework 7, that communicate with a MySQL Azure database.
  • Xamarin.Forms - Create MVVM Data Binding Application Oct 07, 2017. Xamarin Forms Platform using Create MVVM Data Binding application using xml and c# code
  • How To Change/Switch The Database Dynamically In An ASP.NET MVC ApplicationOct 06, 2017. This is an example with code snippets to show how to switch or change the database (Connection string) dynamically while running a program in ASP.NET MVC 5 applications.
  • Always Encrypted In SQL Server 2016 - Step By Step Guide - Part OneOct 06, 2017. Lets say, we have a requirement to encrypt the PII data for an existing ASP.NET web application. Data needs to be encrypted at rest as well as on transit. Considering the existing PROD data, we need to identify an encryption approach that best suits the requirement. I'm going to share my experience in finding the encryption approach and implementing it on a sample database.
  • How To Log Messages (Information, Errors, Warnings) In ASP.NET CoreOct 04, 2017. Framework provides logging capability through ILoggerFactory, to which you could attach one or more providers. Providers act on the logged data in some form i.e., log it to file, database, Azure etc.
  • Create Power BI Report Using Twitter AnalyticsOct 04, 2017. In this article, we will learn how we can use Twitter analytics data and prepare Power BI Report. We can export Twitter analytics data in .csv format and consume that .csv file to prepare a Power BI report.
  • TextBox Validation Client Side And Server Side In ASP.NET WebFormOct 03, 2017. Validation is main thing to process the data. We store the textbox value into database table. Before moving to storing and storing data into database first we check the value of each textbox.
  • Read Data From Excel With Preview In ASP.NET MVC Using AngularOct 03, 2017. In this article we will see how to Read data from excel and show preview and after we can update to database with Asp.net Mvc using Angular.
  • How To Secure PII Data In SQL Server Using CLE (Column Level Encryption)Oct 03, 2017. PII (personally identifiable information) which is used to identify individual identity such as SSN, DOB, Bank Account Number etc. When you are working with financial application you face the scenario where you have to store the data in encrypted format, so no one can see the actual data.
  • Create Value Object In C#Sep 28, 2017. Create a class that abstracts away (encapsulate) ‘data’ in your domain and provide methods to work on it. Below is a class I don’t consider a good Value Object.
  • What's New In Entity Framework Core 2.0Sep 27, 2017. Entity Framework Core is a lightweight, extensible, and cross-platform version of the popular Entity Framework data access technology. Entity Framework 2.0 is the latest release of EF.
  • XAML Value Converter With A Simple ExampleSep 27, 2017. In this article, I'm going to show you how you can use value converter in XAML to convert one format of data into another format. In our case, we'll convert a string value (value in the textbox) to a Boolean value (checked status of a checkbox).
  • Consume Local File System As A Data Source In Power BISep 27, 2017. We all know Power BI is a very good business intelligence tool. Sometimes there is a situation when we need to prepare report using file system. Power BI provides a connector to consume data from folder structure. We can get all files from a specific folder. But there is one limitation with this connector.
  • WebGrid Custom Paging Links To Avoid Load On Server Using Stored Procedure And ASP.NET MVCSep 27, 2017. I will show you how to fetch the data dynamically from the database and bind to the WebGrid control, using the stored procedure in MVC 4.0. In this blog, today, I will show you how to write code in ASP.NET MVC for implementation of WebGrid Control using Static Data. In later sessions, I will show you the process of using GridView Dynamically, that means using SQL Server data source.
  • Azure NoSQL In ASP.NET Core 2.0Sep 26, 2017. The sample code will require you to set up an Azure account, NoSQL database and collection.
  • Understanding Cloud Storage In AzureSep 26, 2017. In this article, I will explain about Storage Accounts (Storage Accounts can hold hundreds of terabytes of data.) and we will see how we can use Azure Storage as a place to keep uploaded files for our web application and how we can allow users to download files from storage by creating and handling out what is known as a shared access signature (SAS).
  • Local Data Caching In ASP.NET Web ApplicationSep 24, 2017. In this article, you will learn some solutions about local data caching in ASP.NET Web Application .
  • Edit Or Remove Permission From Existing Data Source Connection From Power BISep 23, 2017. In this article, we will learn how we can remove our existing data source connection from Power BI Desktop.
  • Data Binding In XAML UWP Using ComboBoxSep 22, 2017. In this article, we'll learn about Combo Box Control in XAML and data binding of this control as well in UWP Applications.
  • How To Implement Angular Data Table With CRUD Using ASP.NET MVC And AngularSep 22, 2017. In this article, we will discuss how to implement Angular Data Table with (Insert, Update, and Delete) Short Form (CRUD) using Asp.net MVC + Angular JS in one page without any full page reloads. This table will be similar to JQuery Data Table and this one is implemented using Angular Data table.
  • Basic PDF Export Using JQuery In ASP.NET MVC RazorSep 21, 2017. Here i will show you after insert records how to export the record in pdf format using jquery.
  • How To Create To-Do CRUD Operation With ASP.NET MVC Core, Angular 4.0Sep 21, 2017. We want to create below single page application with CRUD operation, Add, Update and Remove functionality with in-memory TodoRepository Database.
  • How To Create WebAPI In ASP.NET MVC With C#Sep 21, 2017. This article demonstrates how to create and use an insert update and delete record using Web API in MVC with C# technology
  • How To Migrate Your On-Premises / Enterprise Data Warehouse Into Azure SQL Data WarehouseSep 21, 2017. I will share how you can start migrating your data into the Azure SQL Data Warehouse
  • How To Secure PII Data In SQL Server Using .NET AssemblySep 21, 2017. PII (Personally Identifiable Information) is used to identify individual identity markers such as SSN, DOB, Bank Account Number etc. When you are working with financial applications you face a scenario where you have to store the data in encrypted format, so no one can see the actual data.
  • Two Ways To Get Data From Entity FrameworkSep 15, 2017. In this article, you will learn about two basic ways to get data from Entity Framework and display data in angular UI-Grid using MVC application with Web API.
  • SQL Server DB Backup Using Stored Procedure In WinForm ApplicationSep 14, 2017. In this article we are going to learn how to get database backup using stored procedure in SQL server in C# Winform applications.
  • Create Immutable Type In C#Sep 14, 2017. A public constructor that accepts initialization data is required so that the client can pass-in minimum state for the type to be valid. Private constructor, on the other hand, is used by methods to construct a new object and set its entire state.
  • Azure SQL Data Warehouse - Why Enterprises Should Now Consider It SeriouslySep 14, 2017. Today we will explore some of the reasons why enterprise should choose Azure SQL Data Warehouse.
  • How To Insert Form Data In Multiple Table In DatabaseSep 13, 2017. In this article, we gonna learn about how to insert from data in multiple tables using jquery ajax in asp.net web application.In real time applications it is not a good practice to save all customer data in one table.They save data in multiple tables and link them using relations(using foreign keys).
  • ASP.NET Core 2.0 ConfigurationSep 11, 2017. ASP.NET Core has a simple mechanism to read application settings from various sources like JSON files, Environment variables or even custom data sources. It is also simple to use the settings, thanks to Dependency Injection.
  • Kickstart Azure Database For PostgreSQLSep 10, 2017. This blog post will walk you through creating an Azure Database for PostgreSQL in Azure Portal. PostgreSQL is a powerful, open source object-relational database system and has capability to handle workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users. Azure Database for PostgreSQL is a managed service which enables you to run, manage, and scale PostgreSQL databases in the cloud.
  • Frequent Pattern And Market Basket ImplementationSep 09, 2017. Frequent pattern mining is about the item sets and sequences which appear in a data set.
  • Data Science Machine Learning In R ProgrammingSep 09, 2017. In this article, I am going to describe what machine learning and data science are and then we will see how we can apply machine learning techniques in data science and then we will do some practical implementations in R language of data pre-processing.
  • Working With Azure Tables - Part TwoSep 09, 2017. Let us look at the basic sample, which retrieves the Azure table data into the applications using Node JS.
  • Data Mining And Market Basket ImplementationSep 08, 2017. This article talks about the major techniques which are used in data mining to extract raw data for the following steps like data cleaning, data pre-processing, etc. and constructing useful datasets which are used for prediction.
  • Azure Cosmos DB With SQL Query Cheat Sheet PDFSep 08, 2017. Microsoft Azure Cosmos DB supports querying documents using SQL (Structured Query Language) as a JSON query language. Cosmos DB is truly schema-free. By its commitment to the JSON data model directly within the database engine, it provides automatic indexing of JSON documents without requiring explicit schema or creation of secondary indexes.
  • Get Office 365 Data In Excel Using MS Graph APISep 08, 2017. In this article, I will show how you can quickly fetch Office 365 data of your organization in MS Excel using Microsoft Graph API.
  • How To Consume Web API Through SSIS PackageSep 07, 2017. In this article, I have illustrated the purpose of SSIS with Web API. It shows how SSIS can use Web API to do certain operations, like updating the database table based on Service response, and process the data, etc.
  • Find Out Creation And Modification Date Of Database Objects Like Tables And Stored ProceduresSep 07, 2017. Database Object refers to Table, Stored procedure, View, Function etc.; in other words, all the elements that are created for data storage and manipulation.
  • Use Wikipedia As A Data Source To Prepare Power BI ReportSep 07, 2017. Power BI is a business intelligence tool. It supports so many data sources to prepare a report. As we all know Wikipedia is a very good resource of useful information. We can consume Wikipedia data as a data source and prepare a Power BI report.
  • Where Can I Use Common Azure CosmosDB (Use Cases)?Sep 06, 2017. Azure Cosmos DB is Microsoft’s globally-distributed, multi-model database service for managing data at planet-scale. It builds upon and extends the earlier Azure DocumentDB which was released in 2014.
  • How Should We Store Images And Blob Files In SQL ServerSep 06, 2017. There is always a requirement from developers: How should I store images and BLOB files in SQL Server ? In this post let's explore the data types and methods used for storing Binary Large Objects also know as BLOBs, such as images and sounds, into SQL Server.
  • Understanding Bot Service In AzureSep 06, 2017. This article will give an overview about the MS bot framework. Open azure portal and click on add and choose category “Data + Analytics” and then select the option “Bot Service”.
  • The Basic Concepts Of Data ScienceSep 04, 2017. The basics concepts of data science can be separated two important parts. Maybe some people can argue with me because I have to tell you supervised learning and unsupervised learning and decision trees algorithms. But my intend is not explaining the concepts of Data science. This article is related to some knowledge about who wants to be started as data scientist.
  • Search Data From Xamarin.Forms List ViewSep 04, 2017. In this article, we are going to search some data from list view of xamarin forms. Firstly we can create a list in xamarin forms PCL application. Then add some data in list and make a search bar to search data form list.
  • Connecting To MySql Database In StrapiSep 04, 2017. This article helps you to create a connection to the My SQL database using the Strapi; this is an article for the beginners where the basic connection can be created with the existing MySQL database.
  • How To Perform Web Scraping Using Python ProgramSep 04, 2017. Web Scraping (also known as Screen Scraping, Web Data Extraction, Web Harvesting etc.) is a process to scrap (extract) data from web pages, web document, HTML document or XML document in a structured manner and then store in database, text file as a spreadsheet , as a XML , or in whatever file format we want to save in.
  • What Is Meant By Big DataSep 04, 2017. Big data is a term that describes the large volume of data - both structured and unstructured - that overload a business on a day to day basis.But it's not the amount of data that's important.It's what all the - organisations do with the data that matters big data can be analyzed for insights thats load to better decisions and strategic business moves "Big data" is similar to "small data",but it is bigger in size.Big data is the collection of both structured and unstructured data which are from different sources like social data,machine generated data and traditional enterprises.
  • How To Backup A Mirrored Database Using SQL AgentSep 04, 2017. Database mirroring is a primarily software solution for increasing database availability. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery model. The simple and bulk-logged recovery models do not support database mirroring. Therefore, all bulk operations are always fully logged. Database mirroring works with any supported database compatibility level.
  • How To Perform CRUD Operation Using JSON File With Sorting And Paging In Angular - Part TwoSep 02, 2017. Today, in this article, I will explain performing CRUD operations in Angulars j. In my previous article I have retrieved records from json files with sorting and paging in. Now I will explain how to Insert, Update and Delete in angular js, and also with required filed validation. So let us go through step by step.

About Insert-data-into-database

NA
File APIs for .NET
Aspose are the market leader of .NET APIs for file business formats – natively work with DOCX, XLSX, PPT, PDF, MSG, MPP, images formats and many more!