C# Corner

Resources  
  • Xamarin.Forms - Camera AppNov 22, 2017. In this we will learn how to create your own camera application and showing the last captured image.
  • Creating An Azure Storage In Microsoft AzureNov 22, 2017. This article shows how to create an Azure storage in the Azure portal and also performing some basic operations like creating Storage accounts and containers and managing the access keys in it.
  • How To Track Facebook Wall Messages In An Excel Table Using Microsoft FlowNov 22, 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 service. It makes it practical and simple for line-of-business. The users can build workflows that automatically do some business tasks and processes across applications and services.
  • Implementation Of Face API Using Microsoft Azure And Visual StudioNov 22, 2017. This article shows how to create the Face API using Microsft Azure and Visual Studio,
  • Xamarin.Android - Working With MongoDBNov 21, 2017. Today, I will show you how to create MongoDB and how to use MongoDB using Xamarin.Android.
  • Creating A Data Science Virtual Machine(DSVM) For Linux In The Azure PortalNov 21, 2017. In this article, I am going to demonstrate how to create the Data Science Virtual Machine for Linux on the Azure Portal and connect the DSVM to visualize the VM using X2Go Client Software.
  • Xamarin.Android - QR Code Reader AppNov 21, 2017. In this article, I shall show you how to make a QR code reader app in Xamarin.Android.
  • Make A Text Recognition App Using Xamarin.AndroidNov 20, 2017. Today, I shall show you how to create a Text Recognition app using Xamarin Android. I shall used Xamarin Google-Play-Services Vision for text recognition.
  • Creating A SQL Database And SQL Server On The Azure PortalNov 20, 2017. This article shows how to create a SQL Database and Server on the Azure Portal and also the process of configuring the threat protection to our Database.
  • Creating An Azure Data Lake Store And Data Analytics Account In Azure PortalNov 20, 2017. This article shows how to create an account on Azure Data Lake and Data Analytics in the Azure portal.
  • Simplest WPF Dependency Property For Beginners On Background ColorNov 19, 2017. Dependency property is not wrapped over any private members unlike CLR properties, and it is also stored in Key-Value pairs inside the DependencyObject host instance. You must use Dependency properties if you need to create and apply properties on custom usercontrols, or change properties based on external inputs like Theme, Style, animation etc, or while applying data binding or set with a resource (static/dynamic) .
  • Automation Configuration Using JenkinsNov 18, 2017. In this article, I am going to show you the automation configuration using Jenkins.
  • 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.
  • Building A Reminder Application In Xamarin.AndroidNov 17, 2017. This is simple Reminder Application that will remind the particular things (eg: Remind for shopping, remind for particular office work/meeting, remind for go to particular place etc etc). This application will take three input ( Date, Time and the Content that will need to remind). On the particular date and time it will notify you in the notification bar and when you click on notification it will show you the content that need to remind.
  • Build Intelligent Apps with Microsoft Data PlatformNov 16, 2017. Learn how to build intelligent apps using Microsoft data platform and tools.
  • Monitoring S3 With Events And SNSNov 16, 2017. This is Muhammad Habib Jawady in a new DevOps hands-on tutorial. In my first Amazon Web Services tutorial, I will be showing you how to leverage the S3 events feature and Simple Notification Service In order to monitor actions taken on certain assets .
  • 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.
  • 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
  • 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.
  • 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
  • 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.
  • 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.
  • MS Visual Studio Code - Guide To GitNov 06, 2017. Hello guys again, this is Muhammad Habib Jawady and today I will be showing you how to use MS visual Studio Code in order to work with git properly. This will be a hands on tutorial, I hope you will find this useful as the number of users of ‘Code’ has grown dramatically throughout the year and the need for a full tutorial on how to use it has became an urge to help people master its enormous number of features.
  • 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.
  • 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.
  • 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.
  • Showing Forms Page In Xamarin NativeNov 05, 2017. Yes, you heard right -- now you can display forms page in Xamarin Native
  • 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.
  • Using Perfect Scrollbar In Angular v2 And AboveNov 01, 2017. In this article, I am going to show you the usage of perfect-scrollbar using ngx-perfect-scrollbar package.
  • 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.
  • 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.
  • Angular 2+ Filter Pipes And Custom Filter PipesOct 30, 2017. In this article, I am going to show you the predefined filter pipe usage as well as show you how we can create our own custom filter pipe and its usage.
  • ASP.NET Core 2.0 MVC Model BindingOct 30, 2017. In a previous post on Routing, I showed how MVC maps URLs to Controller and actions to execute. We touched on the topic of the model binding mechanism through which MVC binds routing template tokens to action parameters.
  • Building WordPress Theme From Scratch - Part OneOct 30, 2017. Hi all, I am writing a series to create a theme in WordPress with all functionalities like show blog post and add widgets on the front page. I will create this series for absolute beginners who want to improve his skills in php so here you can learn to build your own theme with all those functionalities you want in your own theme.
  • Getting Started With Receipt Card Design Using Microsoft Bot FrameworkOct 29, 2017. The Bot Framework supports different type of rich cards and provides a richer interaction experience to the user. In this article, I will show how to integrate Receipt card UI design in a Bot Application. If you are developing a shopping card Bot chat application; receipt card is very important. Receipt card class has property as a list of items, total, tax, vat, title and image. We can re-use all receipt card properties and add tab action event for navigating to original invoice website.
  • 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 Read CSV File In ASP.NET With Example C# and VB.NETOct 26, 2017. In this articleI'll explain a way to upload, read/browse and show CSV file (Text File) information in ASP.Net GridView using C# and VB.Net.
  • How To Do 'LinkedIn Connection Analytics' Using Power BI Oct 26, 2017. Learn to use new free 'LinkedIn Connection Analytics' dashboard with Power BI.
  • Debugging Tips - Part OneOct 24, 2017. A cool attribute to save some debugging time is DebuggerTypeProxy (Namespace: System.Diagnostics). Using this attribute, you can write your own logic to interpret the object at debug time. Meaning, if you have a list of class objects then you can project on certain properties and force debugger to show the value off of this proxy class. This attribute is applicable to Structures, Classes and Assemblies.
  • 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.
  • Angular 2+ Logger Using ng2.loggerOct 23, 2017. In this article I am going to show you the process to log messages in Angular 2+ applications with examples. Ng2 Logger is a simple logging module for Angular 2+ applications. This allows you to log messages based on the log level setup.
  • .NET Highcharts With ASP.NET MVCOct 22, 2017. This article will demonstrate how to implement DotNet Highcharts with Asp.Net MVC application. Highcharts is a JavaScript library to implement charting functionality like line chart, bar chart, column chart etc. We can create different types of charts using highcharts. Today with this article, I will try to show you how to create Highcharts in Asp.Net MVC from server side.
  • Enable And Disable Wi-Fi In Android Application Using Android StudioOct 20, 2017. In this article, I will show you how to Enable and Disable WI-FI in android App using Android studio. The information that an application can access includes connected network's link speed, IP address, negotiation state, other networks information. Applications can also scan, add, save, terminate and initiate Wi-Fi connections.
  • 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.
  • T-SQL - Display Decimal Numbers As MoneyOct 17, 2017. In this article, we will show how to display decimal numbers as money with and without cents
  • 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.
  • Sharing A Solution To Generate BillcodeOct 16, 2017. Many of systems we use will generate plenty of billcodes everyday , and most of them include date(datetime) or a prefix to show their signification , such as specifying a billcode belongs to a special day or a special type .
  • Getting Started With Entity Framework Core 2.0 ASP.NET Core 2.0Oct 13, 2017. This article shows how to create Entity Framework Core 2.0 MVC Web application using Visual Studio 2017 Asp.Net Core and how to create CRUD operations.
  • 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.
  • Using Client Side Response Routing In Voice Of The CustomerOct 13, 2017. This article is about using client side response routing. We need to show/hide survey question based on the selection in previous questions. In this article we are going to share steps to implement same.
  • What Is The Easiest And Quickest Way To Test An Application's Web APIsOct 12, 2017. The easiest way to test an application's API is the use of Windows PowerShell or Visual Studio Package Manager Console. I will show you step-by-step how to use PowerShell or PM(Package Manager Console) to test an application's Web APIs.
  • 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.
  • 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 Adaptive Card Design Using Microsoft Bot FrameworkOct 12, 2017. The Bot Framework supports different types of rich cards and provides a richer interaction experience to the user. In this article, I will show how to integrate adaptive card UI design in a Bot Application. The Adaptive Card contain a combination of text, speech, images, buttons, and input controls.Adaptive Cards are created using the JSON format specified in the Adaptive Cards schema and Microsoft provided Microsoft.AdaptiveCards NuGet package for .Net Developer to building cards and handles the serialization.
  • 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
  • Create SharePoint 2016 Solutions In Visual Studio 2015Oct 12, 2017. In this article, I will explain how to show the SharePoint 2016 Project Template in Visual Studio 2015.
  • 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)
  • Getting Started With Thumbnail Card Design Using Microsoft Bot FrameworkOct 10, 2017. The Bot Framework supports different types of rich cards and provides a richer interaction experience to the users. In this article, I will show how to integrate Thumbnail card UI design in a Bot application.
  • Getting Started With Hero Card Design Using Microsoft Bot FrameworkOct 10, 2017. The Bot Framework supports different types of rich cards and provides a richer interaction experience to the users. In this article, I will show how to integrate Hero Card UI design in a Bot application.
  • Work Item Rule In Visual Studio Team ServiceOct 10, 2017. In this article, I’m going to show you how to create a work item rule in VSTS and how it will work effectively in day to day processes
  • Broadcasting Message From ASP.NET Core To Angular Client Using SignalROct 10, 2017. Recently, the .NET team has announced SignalR for ASP.NET Core. So, in this article, I am trying to show how we can use SignalR with ASP.NET Core for an Angular client.
  • 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.
  • 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.
  • ASP.NET - Connect To Azure Cosmos DBOct 07, 2017. This article will show how to configure and use CosmoDB on an ASP.Net MVC web application, The tasks will be stored as JSON documents in Azure Cosmos DB.
  • 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
  • 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 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.
  • 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.
  • Selecting Lookup View Dynamically Using JavaScript In Dynamics CRM/ 365Oct 03, 2017. Lookup Views are shown when user clicks on Look Up More Records in any Lookup Field. In Dynamics CRM/365, Lookup Views are available in almost all entities, In newly created custom entities also it will be available by default. Lookup View of Account Entity is shown.
  • 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 Sensor Android App Using Android StudioOct 03, 2017. In this article, I will show you how to create a Sensor Android App using Android studio. we are going to create a sensor application that changes the background color of an activity when a device is shaken.
  • 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.
  • 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).
  • 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.
  • 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.
  • RatingBar Android App Using Android StudioSep 27, 2017. Android RatingBar can be used to get a rating from the user. The rating returns a floating-point number. It may be 2.0, 3.5, 4.0 etc. Android RatingBar displays the rating in stars. In this article, I will show you how to create RatingBar Android App using Android Studio.
  • 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 .
  • Auto-Complete Text View Android App Using Android StudioSep 23, 2017. In this article, I will show you how to create an Auto Complete Text view Android App using Android studio.
  • Toggle Button Android App Using Android StudioSep 23, 2017. Android Toggle Button can be used to display checked/unchecked (On/Off) state on the button. It is beneficial if user have to change the setting between two states. It can be used to On/Off Sound, Wifi, Bluetooth etc. In this article, I will show you how to create Toggle Button android App using android studio.
  • 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.

About How-to-show-data-from-JSP

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!