C# Corner

Resources  
  • Remove Duplicate Rows In SQL Server Using CTEDec 11, 2017. In this article, you will learn how to remove duplicate rows in SQL Server using CTE.
  • Dock Panel Control In UWPDec 10, 2017. Reading this article, you can learn how to use DockPanel Control in Universal Windows Apps development with XAML and Visual C#.
  • Creating Server And Host HTML Page Using Node.jsDec 07, 2017. Today my mission is to explain about creating server in Node JS and hosting html pages on this server and accessing it from web browser.
  • Object-Relational Mapper For SQLite3 In Node.jsDec 07, 2017. Node.js is getting more popular day by day and many frameworks and platforms are supporting Node.js for its high-performance web server development. In this post, you will learn the database development in Node.js with the popular ORM library; Sequelize.
  • Login Window Xamarin.Forms UWP App With Blocking Feature If Incorrect LoginDec 07, 2017. In this article, we are going to create the login window application that will take UserId and Password as its credentials and prompt success if correct credentials are passed.
  • Audit Made Easy Without Audit Log - Part OneDec 07, 2017. In Microsoft SQL Server, the activity of each of the database table is tracked in the other table and that is called the Audit trail or Audit log of the database table.
  • DropDownList In ASP.NET MVCDec 06, 2017. In this article you will come know how to bind data and get dropdownlist selected value in Asp.Net MVC in Client Side and Server Side.
  • Creating A Chat Application In Node.js With Express, MongoDB, Mongoose And Socket.ioDec 05, 2017. In this article, we are going to create a chat application in NodeJS with the back end MongoDB. We will also be using Mongoose for creating the MongoDB models and Socket.io for making multi directional chats on multiple client window.
  • Building SPA With Angular And ReduxDec 01, 2017. In the current application development era, Single Page Application (SPA) is a great feature to develop modern web based applications. In these SPA applications we tend to move the data level dependency from the server side to browser level as much as possible to improve the application performance. So as much as application level functionality moves to the browser level the amount of the data and way to manage these data is also increased. Modern SPA application frameworks like Angular and React use component based architecture that divides our application into small-small sections. Each component contains its own HTML page, stylesheet and its own state(data). This approach is very efficient because it divides our application into small sections that we can manage very easily and also we can reuse these components in our application.
  • Building Windows 10 App Using UWPNov 30, 2017. Build a Windows 10 application that runs anywhere using the Universal Windows Platform
  • Mounting Azure File Share With WindowsNov 30, 2017. This article shows how to create an Azure Storage account
  • Getting Started With Kotlin - BasicsNov 29, 2017. Google announced Kotlin as an official language for Android Application development in Google I/O 2017.Kotlin is a statically-typed language, developed by JetBrains and Open source Contributors in the 2011, that runs on JVM(Java Virtual Machine) and is compiled to JavaScript source code. It is very suitable for server-side application development with full compatibility of Java frameworks. You can use multiple frameworks like - Spring, Vert.x, Ktor etc. for web application development.
  • A Beginner's Guide To Windows Server SetupNov 29, 2017. All developers must be familiar with how to interact with a server for various project requirements. This server interaction varies depends on the project requirements. Some of may be just connecting to an SQL Server database server through an application, some of you may be hosting your application to an IIS server.
  • Creating Custom Tag Helpers With ASP.NET Core MVCNov 29, 2017. The tag helper enables us to run server-side code to generate HTML, CSS, Javascript code in Razor view.
  • Creating A Windows Virtual Machine On The Azure Portal And Expanding The OS DiskNov 28, 2017. This article demonstrates how to create a Virtual Machine on the Azure portal and also how to expand the OS Disk for high space availability.
  • Filtering jQuery Data Table Server Side Using MVC And Entity FrameworkNov 27, 2017. This article explains how to work with jquery Datatable on the server side and how to use Search Textbox to do serverside filtering using MVC and Entity Framework
  • How To Build A Kubernetes Cluster On Azure Using KubesprayNov 26, 2017. The concept of sticking our compiled code into containers is becoming quite popular at the moment, and for very good reason. If you develop for the cloud, and don't use containers or similar technology now, then you should really take a look at whats involved. The huge benefits of using containerized infrastructure/deployment are being pushed by the cloud vendors, and also increasingly being recognized by mainstream enterprise as an all round good egg and something worth investing time and resources into embracing. Containers and 'server-less computing' are two technologies that most developers are going to have to embrace in the next short few years.
  • How To Create A Stored Procedure In SQL Server Management StudioNov 25, 2017. In this article you will learn about how to create store procedure in sql server’s SQL SERVER MANAGEMENT STUDIO and very informative information and interview questions and answers about store procedure.
  • Introduction To SSISNov 24, 2017. SSIS stands for SQL Server Integration Services. It is one of the services of SQL Server and was introduced for the first time in SQL Server 2005. It’s a powerful replacement for the legacy DTS (Data Transformation Services) that exists in SQL Server 2000.
  • Introduction To Suave With F#Nov 23, 2017. In this article, we will see how to construct a simple web application with the F# language and the Suave web server on Visual Studio Code.
  • Use SQL Server 2017 in Docker ContainersNov 21, 2017. How to use SQL Server 2017 on Docker containers to automate deployment using VSTS
  • Introduction To SQL Operations Studio And Connecting It With SQL ServerNov 20, 2017. Learn how to use SQL Operations Studio (preview) to connect to SQL Server, and then use Transact-SQL (T-SQL) statements.
  • 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.
  • ParallaxView Control In UWPNov 18, 2017. Reading this article, you can learn how to use ParallaxView Control in Universal Windows Apps development with XAML and Visual C#.
  • Dynamic Checkbox Functionality Using Angular In ASP.NET MVCNov 17, 2017. Checkboxes in AngularJS and asp.net MVC (server-side) application.
  • Radial Progress Bar Control In UWPNov 17, 2017. Reading this article, you can learn how to use Radial Progress Bar Control in Universal Windows Apps development with XAML and Visual C#.
  • 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.
  • ScrollHeader Control In UWPNov 16, 2017. Reading this article, you will learn how to use ScrollHeader Control in Universal Windows Apps development with XAML and Visual C#.
  • Auto Complete with ngTagInput using Web API in AngularJSNov 16, 2017. AutoComplete,ngTagInput,Web API,AngularJS,AutoComplete in AngularJS using Web API
  • Always Encrypted In SQL Server 2016 - Step By Step Guide - Part ThreeNov 15, 2017. This is part three of "Always Encrypted In SQL Server 2016 - Step By Step Guide" series. In this article, we are going to see how to search on encrypted column and how to deploy a certificate to a different environment.
  • Basic Introduction To ISAPI FiltersNov 15, 2017. In this article we will have a look on ISAPI filters in windows SharePoint services
  • Radial Gauge Control In UWPNov 15, 2017. Reading this article, you will learn how to use Radial Gauge Control in Universal Windows Apps development with XAML and Visual C#.
  • Everything You Want To Know About SharePoint 2016Nov 15, 2017. The new kid in town. Well, I hope you won’t mind when I say that SharePoint 2016 is the new kid in town considering the fact that it has been more than a year since Microsoft has released SharePoint Server 2016 and it has also announced the release of SharePoint Server 2019 a month back at Ignite Conference. However, there’s reason for me to still call SharePoint 2016 as the new kid in town because it still remains to be a cutting-edge platform for many SharePoint professionals out there and I’ve seen many organizations actively working on adapting SharePoint Server 2016 as the modern collaboration platform for their IT workspace.
  • 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).
  • Steps To Configure Xamarin.Android Emulator Performance - Part TwoNov 14, 2017. Xamarin is a cross-platform development tool. With Xamarin, you can use C# for iOS, Android, and Universal Windows apps. And with Xamarin Forms, interface design for all three platforms can be accomplished within its XAML-based framework.
  • SSMS 2016 - Enhanced ScrollbarNov 14, 2017. Detailed description with screenshots of the enhanced scroll bar introduced in SSMS (SQL Server Management Studio) 2016.
  • 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.
  • Learn Universal Windows Programming Via Modern C++ (ProgressRing)Nov 13, 2017. This article explains how to implement the Progress Ring Control.
  • DROP IF EXISTS In SQL Server 2016Nov 13, 2017. With this very small but handy tip, we’ll check the enhancement that has been made to DROP statement in SQL Server 2016. Earlier, we used to write additional checking logic to make sure that the object exists to drop. If we miss writing the check and if the object is not available, then we are being served with an error message. With SQL Server 2016, now we can check the existence of the respective object without any error being generated.
  • OrbitView Control In UWPNov 11, 2017. Reading this article, you will learn how to use OrbitView Control in Universal Windows Apps development with XAML and Visual C#.
  • Introduction To Serverless Architecture In AzureNov 11, 2017. In this article, we will see how to create logic apps in Azure.
  • 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.
  • Task Scheduling Through Quartz In C#Nov 10, 2017. In this article, we are going to learn about task scheduling through QUARTZ scheduler in C#. Here we are going to make a simple windows form application and schedule a job in it.
  • Introduction To Xamarin.Android Using C# - Part OneNov 10, 2017. Xamarin.Android will create native Android applications using modern language (C#), .NET Base Class Library Visual Studio. Xamarin is a cross-platform development tool. It solves dilemmas many developers face when developing cross-platform apps: separate coding languages and UI paradigms. With Xamarin, you can use C# for iOS, Android, and Universal Windows apps. And with Xamarin Forms, interface design for all three platforms can be accomplished within its XAML-based framework.
  • Introduction Of New Useful Features In SSMS 2016Nov 10, 2017. This article is an effort to list out a few exciting improvements that have been made to SQL Server Management Studio 2016. I believe, most of these new features can help improve the speed of our work and are more convenient to use the SSMS.
  • Loading Control In UWPNov 10, 2017. Reading this article, you will learn how to use Loading Control in Universal Windows Apps development with XAML and Visual C#.
  • Expander Control In UWPNov 09, 2017. Reading this article, you can learn how to use Expander Control in Universal Windows Apps development with XAML and Visual C#.
  • DropShadowPanel Control In UWPNov 09, 2017. Reading this article, you can learn how to use DropShadowPanel Control in Universal Windows Apps development with XAML and Visual C#.
  • Configuring SQL Server 2016 Express On LAN For C# Connection StringNov 08, 2017. In this article I will share my experience about configuring SQL Server 2016 Express on LAN for SQL connection using my C# application’s connection string
  • Learn Angular 4.0 In 10 Days - Day OneNov 07, 2017. HyperText Markup Language (HTML) was invented in the year of 1990 by Tim Berners-Lee—a famous physics and computer scientist—while he was working at CERN, the European Organization for Nuclear Research. He was motivated to discover a better solution to share information among the researchers of the institution in a very quick and easy way. To support that, he also created the HyperText Transfer Protocol (HTTP) and its first server, giving rise to the World Wide Web (WWW). At that time, HTML was used just to create static documents with hyperlinks, allowing the navigation between them.
  • ASP.NET Core 2.0 MVC Tag HelpersNov 07, 2017. Tag Helpers help generate HTML by attaching attributes to existing HTML elements or by creating new elements. Although they look like HTML elements and attributes, Tag Helpers are processed by Razor (server-side).
  • Retrieve SharePoint Lookup Field Value Via C#Nov 07, 2017. Get and set a SharePoint Lookup Field via SSOM C#. In this article, I have explained how to get & set SharePoint lookup field (single/multiple) values programmatically via Server Side Object Model in C#.
  • Carousel Control In UWPNov 06, 2017. Reading this article, you can learn how to use Carousel Control in Universal Windows Apps development with XAML and Visual C#.
  • 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.
  • 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.
  • SQL Server 2016 - How To Detect The Current Cumulative Update/Service Pack That Was InstalledNov 05, 2017. In this article, I will explain how to detect the current Cumulative Update / Service Pack installed on your SQL Server.
  • PersonPicture Control In UWPNov 03, 2017. Reading this article, you can learn how to use PersonPicture Control in Universal Windows Apps development with XAML and Visual C#.
  • Learn Universal Windows Programming Via Modern C++ (ProgressBar)Nov 01, 2017. ProgressBar indicates that some operation is going on in the background.
  • Learn Universal Windows Programming Via Modern C++ (DispatcherTimer)Nov 01, 2017. DispatcherTimer is a timer control, that is integrated into the Dispatcher queue, Timer event is called in a specific timer interval, the main advantage DispatcherTimer, it can run the code on the same UI thread.
  • Learn Universal Windows Programming Via Modern C++ (RelativePanel)Oct 31, 2017. Here, I have explained how to implement RelativePanel control in C++/WinRT.
  • Linux BASH Shell On Windows With 'Microsoft 2.0'Oct 31, 2017. We have come a long way from the days Steve Balmer declared Linux 'a cancer', and the culture of 'fear uncertinty and doubt' was tightly ingrained across Microsoft. I recall baulking when I heard it the first time... what a guy.... :/
  • SystemDataPaths In UWP (Windows 10 Fall Creators Update Features)Oct 31, 2017. This article explains about how to get system , app , user based path information. This SystemDataPaths, UserDataPaths, AppDataPaths class will be supported on Windows 10 Fall creators updated version build or greater and Windows 10 SDK 16999.
  • Image Copy And Paste Using Clipboard In UWPOct 29, 2017. Reading this article, you can learn how to perform Copy and paste Images using clipboard in Universal Windows Apps development with XAML and Visual C#.
  • Introduction To IIS Server, HTTP Request Life Cycle, And Introduction To Application PoolOct 29, 2017. This article will give basic knowledge on IIS server, Http request life cycle, hosting a website in IIS & an introduction to application pool. Before we start on this let's have a quick look at what is a website & how it’s related to servers.
  • Copy And Paste Text Content Using Clipboard In UWP With XAML And C#Oct 27, 2017. Reading this article, you will learn how to copy and paste the text content using clipboard in Universal Windows Apps development with XAML and Visual C#.
  • Debugging Tips - Part TwoOct 27, 2017. While working on complex classes/objects, it really takes two more clicks to either add that object to the Watch window or expand the object in visualizer and navigate to a specific property.
  • Setting Or Retrieving Geotag In Media File In UWP With XAML And C#Oct 25, 2017. Reading this article, you can learn how to set or retrieve Geotagging in Media File in Universal Windows Apps development with XAML and Visual C#.
  • Simple Single Side Traffic Controller Using Timer ControlOct 25, 2017. This is a simple article for beginners who are getting introduced to C# programming in which they will learn how to code using Timer control inside Windows form
  • ASP.NET Core MVC Project (Event Management)Oct 24, 2017. This Project is developed in Asp.net MVC Core 1.0.0 with Windows dependencies.
  • Security Credential Picker In UWP With XAML And C#Oct 24, 2017. Reading this article, we can learn how to use Credential Picker in Universal Windows Apps development with XAML and Visual C#.
  • Learn Universal Windows Programming Via Modern C++ (Grid Control)Oct 23, 2017. This article explains about Grid control in Modern C++/WinRT. Grid control is used to arrange the controls in multirow and multicolumn layouts (stackpanel is use arrange controls in horizontal or vertical).
  • Missing 'Manage Delegates' Option In PWA Setting In Project Server 2016Oct 23, 2017. In this article, we will be fixing the issue Missing 'Manage Delegates' option in PWA Setting.
  • Learn Universal Windows Programming Via Modern C++ (ContentDialog)Oct 22, 2017. This article explains about Content dialog in C++/WinRT. It forces the user to get the input (whether success or failure) until the user cannot interact with Parent windows.
  • .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.
  • Learn Universal Windows Programming Via Modern C++ (AutoSuggestBox Control)Oct 19, 2017. In this article we'll learn how to implement AutoSuggestBox and some of the important events and properties.
  • Automated Window LockOct 19, 2017. In this article, we are going to see the light intensity controlled window which automatically locks when it gets dark or light intensity is reduced.
  • ASP.NET Core 2.0 Response CompressionOct 16, 2017. When you’re unable to use the compression features of web servers (IIS, Apache, Nginx), ASP.NET Core provides an alternate option, Response Compression middleware. It’s performance won’t match server based compression features though.
  • How to use NPM Install (The Command) behind Corporate Proxy ServerOct 14, 2017. When you want to install packages for angular, angular CLI, typescript etc. via NPM using Command Prompt and you are working in an office environment where everything runs behind a corporate proxy server, you will most probably get the below exception.
  • Always Encrypted In SQL Server 2016 - Step By Step Guide - Part TwoOct 14, 2017. This is part two of "Always Encrypted In SQL Server 2016 - Step By Step Guide" series. In this article, we are going to see the sample queries on encrypted columns and Limitations of Always Encrypted feature. In case, if you have missed out the first part of the series.
  • ASP.NET Core 2.0 Response CachingOct 13, 2017. As you navigate between a controller with caching enabled (Home) and another one without it (Movies), you’ll notice that time isn’t been updated i.e. it's not coming from server but rather from cache.
  • User-Defined Types In SQL ServerOct 13, 2017. When we are working with any programming language, we create user defined types as per our requirement. It is a better idea to have this feature in the SQL server.
  • Read Excel File In C# WinFormOct 13, 2017. Here we are going to learn to read Excel files in C# windows form applications.
  • 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.
  • 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.
  • 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
  • Learn Universal Windows Programming Via Modern C++ (SplitView Control)Oct 11, 2017. In this article, we are going to learn about Splitview control in Modern C++.
  • How To Create Windows Local User Account Using C#Oct 11, 2017. Here, we are going to learn to make a Windows local user account using C#. Here we are going to make a c-sharp console application and write code in it to make user accounts via C#.
  • Custom Script Extension For WindowsOct 11, 2017. In this article, we will see how to work with custom script extension in Azure Virtual Machines.
  • Generate Access Token For Google Service Account Form JSON Or P12 Key In C#Oct 11, 2017. Service Accounts are used for server to server communication so users don't need to interact for Authentication. Let's learn to get access token for Google Service Account.
  • Learn Universal Windows Programming Via Modern C++ (CommandBar Control)Oct 11, 2017. In this article, we are going to learn about CommandBar control in Modern C++. The CommandBar control is a new control in Universal windows programming, it’s a like a Toolbar control, it has more features compared to Toolbar control.
  • Shared Storage Using Azure File ServiceOct 10, 2017. In most cases, the virtual disks we are creating for an Azure VM are connected to that particular VM with a 1:1 relationship which can’t be accessed by another VM at the same time. In case you need a shared storage by multiple VMs you should use Azure File Shares. Azure File shares can be mounted concurrently by cloud or on-premises deployments of Windows, Linux, and macOS. This is mostly used in case of any requirement of something like a shared application setting or if you need to share any tools or utilities between developers and administrators.
  • How To Use Ratings In Lists And Libraries Using Rating Settings, Server Side Coding And PowerShell CommandsOct 09, 2017. In this article I will discuss how to make use of ratings with your lists & libraries. Ratings are the features introduced by Microsoft which allow users to evaluate & rate the authors. Here I will explain how to use ratings on the lists & libraries.
  • Create Simple Azure FunctionOct 07, 2017. Azure functions allow up to run the code in a server-less manner. That means we do not have to create the VM to host the running code nor do we have to create a web application and publish code to web applications to run continuously.
  • Amazon SNS (Simple Notification Service) Using Visual StudioOct 07, 2017. This is the working example of the ASNS (Amazon simple notification service) you can follow the step and can implement the notification service, message service, email service using this.
  • Deploying A Virtual Machine Using Unmanaged DiskOct 07, 2017. In the previous article, we deployed a Windows VM using the managed disk. In this article, we are going to see how we can deploy a VM using an unmanaged disk. For demo purpose, I am using a Linux VM instead of windows here.
  • 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.
  • ColorPicker Control In UWP (Windows 10 Fall Creators Update Features)Oct 04, 2017. This article explains how to implement ColorPicker control in UWP application. A ColorPicker control is a new control in UWP programming
  • Deploying A Windows Virtual Machine In The Azure PortalOct 04, 2017. Azure Virtual Machine (VM) is one of the several types of on-demand, scalable computing resources that Azure offers. Typically, you choose a VM when you need more control over the computing environment than the other choices offer. Let's see how to create an Azure VM from the portal.
  • 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.

About Windows-Server-AppFabric

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!