C# Corner

Resources  
  • 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.
  • 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.
  • 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
  • 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.
  • Delete A SharePoint Subsite By Using Angular And Rest APIOct 14, 2017. In this article I am going to explain how to delete a subsite programmatically using Angular js and rest API call.
  • 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.
  • Creating A Dynamic YearPicker Plugin Using JQuery And HTMLOct 14, 2017. We have seen many year pickers that allow you to select years from the dropdown. I have seen a requirement of selecting years from the year picker as we select date from the datepickers. Now I am going to create a dynamic Year picker plugin to select the year using jquery and html
  • 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.
  • 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.
  • Getting Started With SharePoint Framework For SharePoint 2016 On-PremisesOct 12, 2017. Once you have installed and upgraded the September 2017 Public Update for SharePoint 2016, you will be able to upload and deploy SharePoint Framework packages that contain web parts via the SharePoint App Catalog just as you would with SharePoint Add-ins.
  • 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
  • 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.
  • Create A Subsite By Selecting A Template Using AngularOct 11, 2017. In this article, I am going to explain how to create a subsite programmatically based on a selected template using AngularJS and REST API call.
  • 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.
  • 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.
  • 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.
  • 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.
  • CRUD Operation With ASP.NET Core MVC Web App Using ADO.NETOct 05, 2017. In this article, I am going to explain how to create a MVC web application in ASP.NET Core 2.0 using ADO.NET.
  • Create New Record To SharePoint List Using Angular With Rest APIOct 04, 2017. In this article, I am going to explain how to create SharePoint list item using Angular js. This will help to create a new record for long SharePoint lists which contain 100+ fields since we no longer specify field names in this code.
  • Azure Deployment Details And LogsOct 03, 2017. I am working on Microsoft Azure services from last 3-4 years. I always like to work on cloud platform provided by Microsoft. Microsoft always comes up with new services, features with their products. I have observed one thing with Azure that creating any resources or creating design is not big deal. There are lots of technical material and forums provided by Microsoft. Most challenging thing with azure is troubleshoot any issue till you actual route cause.
  • 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.
  • Razor Page Web Application With ASP.NET Core Using ADO.NETOct 03, 2017. In this article, I am going to explain how to create a web application in ASP.NET core using Razor pages and ADO.NET.
  • ASP.NET Core 2.0 Uses SignalR TechnologySep 30, 2017. I am using the current highest version in this example, of course the version number is likely to change every day, the latest version of the SignalR is not compatible with the .NET Core SDK 2.0 Preview 1 by default when creating the project Microsoft.AspNetCore.All l.
  • Software Design Principles DRY, KISS, YAGNISep 29, 2017. In this article, I am going to explore software design principles and their benefits and why design principle are useful for us and how to implement them in our daily programming. We will see DRY, KISS, and YAGNI software design principles.
  • Creating A Wave Audio Player Using WinMM The APISep 28, 2017. This is the part two of my three part trilogy concerning the use of windows mixer controls, playing an existing wave file through some available speaker, or recording and saving a wave file from an available audio input device such as a microphone. You might be wondering about the order I am presenting these tutorials. Simple, ...when my father taught me to play pool, we would often come upon a scenario where there are multiple shots available.
  • 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.
  • Unit Test In .NET Core Application Using MStestSep 26, 2017. In this article, I am going to explain how to perform unit testing in .NET core using MStest.
  • 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
  • Adding Check Box Functionality In An Android App Using Android StudioSep 21, 2017. In this article, I will show you how to create am Android app using Android Studio. Android Checkbox is a type of two state button, either checked or unchecked. There can be a lot of usage of checkboxes. For example, it can be used to know the hobby of the user, activate/deactivate the specific action etc.
  • 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.
  • CRUD Operation In ASP.NET Core MVC Using Visual Studio CodeSep 21, 2017. In this article, I am going to explain how to create a basic web application using ASP.Net Core MVC and Visual Studio Code in Windows System.
  • 35 Essential Basic-Advanced SQL Query-Questions Asked In Technical InterviewsSep 19, 2017. These are all query-based questions asked in tech interviews, including some simple looking tricky one liner SQL statements and joins.
  • Encrypt And Decrypt User Password In SQL Server DB Using C# Winform ApplicationSep 18, 2017. In this article we are going to learn how to maintain the user login details in sql server table with password encryption format and decrypt the user password and validate the credentials in login form.
  • Create Log Backup Maintenance Plan In SQL Server 2016Sep 17, 2017. In this article, we will explain how to take log backups frequently by creating a Log Backup Maintenance Plan in SQL Server 2016
  • If I Ran A Software Company - Part OneSep 17, 2017. I am sure most developers wished they could run a software company or development team in the hopes to do it better. I am one of these developers. I have lead teams before and even was Director of Development for a short time at Proflowers.com. But, I have never run a software company, except for my own consulting company called NicheWare that I started in the 90’s that only has one employee… me!
  • Convert Rows To Columns Using Dynamic Pivot In SQL ServerSep 17, 2017. In this article, we will show how to convert rows to columns using Dynamic Pivot in SQL Server.
  • 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.
  • 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.
  • Update Managed Metadata Field Using SharePoint Designer 2013 WorkflowSep 12, 2017. In this article, I am going to explain how we can update a managed metadata field using SharePoint 2013 Designer Workflow. This solution will work for both SharePoint 2013 On-Premise and SharePoint Online (Office 365). I tested the below solution in Office 365 environment.
  • 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.
  • How To Apply Disclaimer On External MailsSep 09, 2017. In this article, we are going to see how to add a disclaimer statement on external emails.
  • 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.
  • 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.
  • Create TableView In Xamarin.iOSSep 07, 2017. In this tutorial, I am going to share how to create a table view in Xamarin IOS applications using C# and how to use navigation controller in our application.
  • 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.
  • 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.
  • Swift Programming - Zero To Hero - Part FourSep 06, 2017. In this article, we will learn about arrays and accessing arrays using looping statements
  • New String Function In SQL Server 2017Sep 06, 2017. It requires one separator argument and a minimum of two arguments otherwise it raises an error. All the arguments are implicitly converted to string types and then they are concatenated.
  • Leadership Challenge 001 - Positive ReinforcementSep 06, 2017. I wanted to take a different approach for this leadership/coaching article. My goal is to get more participant involvement within the C# Corner community. I really enjoyed Mahesh Chand’s article “Mindset Of A Growth Community” and what really resonated with me were the sections covering courage, support, and engagement. In the spirit of his article, I am asking as many people as possible to participate in a Leadership Challenge. The goal is not to win as an individual but rather as a community.
  • 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.
  • I Am A Programmer And I Love To Exercise Sep 04, 2017. here I am going to talk about fitness and health. I will start with very basic things with which you can improve your health and business.
  • Construct Readable XML Output From SQL Query From Two Or More Tables Using “For XML PATH” StatementSep 04, 2017. In my previous article I discussed about how to get a XML format output from query and process that by using XML AUTO statement, and I give different types of “for XML”.
  • 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.
  • What Is New In Azure Portal UpdatesAug 29, 2017. In this article I am talking about a video in which Leon Welicki and Scott Hanselman introduce us to an update from Azure Portal.
  • Working With JSON In SQL Server 2016Aug 28, 2017. JSON (JavaScript Object Notation) is a lightweight data interchange format. It is language independent, easy to understand and self-describing. It is used as an alternative to XML. JSON is a very popular data interchange format nowadays. Most modern services return the data into the JSON text.
  • New Features In SQL Server 2017Aug 27, 2017. There are many new features introduced with SQL server 2017 and also there is some performance improvement in existing features. Using the following links, we can learn more details about the new features in SQL server 2017.
  • Creating Login Form For Users With Image Uploading For Password RecallAug 27, 2017. The article is an alternate method of creating a login form where the conventional way of giving a password hint will be given as a question. In this, you can add an image which can be your hint if you forget your password.
  • Understand Azure Cosmos DB - DocumentDB API (SQL)Aug 24, 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. It is schema-less and generally classified as a NoSQL database. In this article I am going to create an Azure Cosmos DB using SQL.
  • What's New In Android OreoAug 24, 2017. Android 8.0 Oreo was officially released on August 21, 2017. In this article, I am going to discuss some of the new features of Android 8.0.
  • Create Office Web Add-In Project Using Visual StudioAug 24, 2017. In this article, I would like to share the steps to create Office web add-in projects using Visual Studio. In this article, we have explored what Office add-ins are and how to create Office web add-in projects using Visual Studio 2015.
  • Custom Extension Method In C#Aug 23, 2017. Here, I am going to explain how to create and use the extension method.
  • How To Use Timer Control In PowerAppsAug 23, 2017. In this article, you will see how to create an app from a template and use Timer Control in PowerApps. Refer to getting started with PowerApps and Flow for more details. I am going to create an app using ”Employee Engagement Survey” template and set 30 second durations using timer control for each question.
  • How To Use Microsoft Graph Provider In Visual Studio Connected ServicesAug 22, 2017. In this article, I am introducing the newly added Microsoft Graph Provider in Visual Studio 15.3.1. This article demonstrates how a developer can use this feature to work with Microsoft Graph API.
  • Transform XML Output Of SQL Query To HTML Using "For XML" AUTO Statement With XSLT In C#Aug 21, 2017. Normally, we execute the query using ExecuteNonQuery statement and fill the output into data table. This article describes how to transform the XML output of SQL query statements using FOR XML AUTO to HTML using XSLT.
  • An Overview Of WPF ArchitectureAug 17, 2017. In continuation of my previous article “ABCs of WPF”, I am going to discuss the architecture of WPF.
  • Swift Programming - Zero To Hero - Part ThreeAug 17, 2017. Statements are the building blocks of any program. We can perform any function with the help of statements, such as checking values or declaring variables, calling methods, or even creating objects.
  • Deploying Traffic Manager On Azure PortalAug 17, 2017. In this article, I am going to describe what Traffic Manager is and how to deploy the Traffic Manager on the Azure portal.
  • Load Twitter Data Into SQL DatabaseAug 15, 2017. The requirement is to extract the data from Twitter and load extracted data into SQL Database. For this demonstration I am going to read the Indian Film actor Kamal Haasan's tweets and load that into SQL Server 2016 Database.
  • Connecting Login Form In C# With Database For User Type AuthenticationAug 15, 2017. This article describes how to connect a Login Form designed in C# with a database so that the user gets validated based upon the password given by the administrator who has created the login database.
  • Google OAuth 2.0 Authorization In Azure APIAug 13, 2017. Here, I am going to demonstrate how can we use Google OAuth 2.0 in Azure API. App Service Authentication/Authorization is exposed in the Azure Preview Management Portal.
  • Machine Learning In IoT By Node.jsAug 11, 2017. In this article, I am planning to tell you how to use Scikit-learn with Python scripts for iot applications by using Node.js. First to know ; you have to read my previous articles about IOT by Node.js.
  • Deploying Batch Services On Azure PortalAug 11, 2017. In this article, I am going to describe what Batch Services are and show how to deploy them on the Azure Portal.
  • Who Is An Enterprise ArchitectAug 10, 2017. Earlier, I wrote two posts on the basics of EA, but in this post, I am taking a step back and trying to explain the difference between an IT Architecture and an Enterprise Architecture and sequentially I will explain the difference between a Solution provider (often called as solutioner) and an Architect.
  • Implementing Firebase Invites On AndroidAug 09, 2017. In this article, I am going to demonstrate implementing Firebase invites on Android.
  • Accessing XML Data From XML Document In C# Console ApplicationAug 09, 2017. In this article, I am going to give the best way to access XML data from XML document and also how to find common record node counts.
  • Create SQL Server Database Project With Visual StudioAug 08, 2017. In this article, we’re going to learn about how to we can manage our database scripts using Visual Studio’s SQL server database project.
  • SQL Azure With Entity FrameworkAug 08, 2017. Exploring SQL Azure With Entity Framework
  • Swift Programming - Zero To Hero - Part TwoAug 08, 2017. This is part two of Swift Programming Zero to Hero. In this article we will see loops in Swift.
  • Understanding Azure Data Lake AnalyticsAug 07, 2017. This article will give an overview of Data Lake analytics account and create U-SQL job and execute this job to put data into the .csv file.
  • Phone Number Authentication Using FirebaseAug 06, 2017. In this article, I am going to explain how to use phone number authentication on android with google firebase, which allows users to sign in using their phone number by receiving a One Time Password SMS.
  • Understanding SQL Azure - Part OneAug 06, 2017. This article will give a idea about creating SQL DB in Azure and using it in Visual Studio
  • Understanding SQL Azure - Part TwoAug 06, 2017. This article will allow us to connect with SQL Azure and perform CRUD operations using EF.
  • How To Determine The Version And Edition Of SQL Server And Its ComponentsAug 06, 2017. For Business Intelligence features such as Integration Services, Reporting Services, and Analysis Services, you may have to install the latest service packs, cumulative updates, and hotfixes on the client-side computers to obtain the latest fixes while developing SSIS packages, SSRS reports, or Analysis Services cubes.
  • How To Work With Dropdown In Angular 2, 4 Using Visual Studio CodeAug 05, 2017. In this article, I am going to explain how to work with Dropdown in Angular 2 using Visual Studio Code.
  • Compare Azure SQL Database And Azure SQL Data WarehouseAug 05, 2017. In this article, I am going to compare both Azure SQL database and Azure SQL data ware house. I was reading many articles; below is the tabular compression of both.
  • Setup And Connect To Azure SQLAug 03, 2017. Microsoft Azure SQL Database (formerly known as SQL Azure) is a managed cloud database i.e. Software as a Service (SaaS) provided by Microsoft Azure. In simple words, Microsoft Azure SQL is a cloud database that runs on a cloud computing platform and access to it is provided as a Service.
  • How To Update Azure Virtual MachineAug 03, 2017. Here I am going to explain about Azure Update management solutions
  • Entity Framework CRUD Operation Performed With SQL Stored Procedure Using ADO.NET Entity Data ModelJul 31, 2017. You can see my pervious article for Entity framework with Ado.Net data Model connection and how to create a new entity framework project and sql database connection maintained with created entity framework project. Also you can see how to create a class in entity framework based on data table.
  • How To Use Visual Studio For Azure SQL DatabaseJul 31, 2017. This article demonstrates using Visual Studio step by step for Azure SQL Database operation.
  • Learn MVC : Using Angular And Web API And Deploy To IISJul 26, 2017. Open any MVC using Angular application in Visual Studio 2017. Here I am going deploy my previous application from “Learn MVC Using Angular Dynamic Control in DataTable”.
  • Combination Of Id-ParentId And HierarchyId Approaches To Hierarchical DataJul 26, 2017. How to combine the Id-ParentId and HierarchyId approaches to keep and fetch the data in hierarchical and alphabetical order.
  • Learn Web API : Using SQL Helper ClassJul 25, 2017. This article demonstrates how to use Web API Using SQL Helper Class with easy to use data base access in Visual Studio 2017.
  • How To Use Query Editor For Azure SQL Database In Azure PortalJul 24, 2017. Azure Portal provided Query editor for database operations, which is very good for us. We don’t need any software installation in our computer; we can access and perform the task online.
  • Creating An Azure SQL Database And Connecting Through SQL Server Management StudioJul 23, 2017. This article demonstrates how to create an azure SQL Database, setting the Firewall rule and connecting through the SQL Server Management Studio.
  • Taking Script From Database In SQL Server In Different ModeJul 17, 2017. This article explains how to take the script from database in SQL server in a different mode. Normally we take back up our entire database as “.bak, .mdf, .ldf” file but sometimes we need to alter, update or delete then create our database based on our database modification.
  • Preliminary Practices On Python ProgrammingJul 17, 2017. This article describes the basic concept of Python programming including program syntax, data types, looping & conditional statements and more
  • Create SSRS Drilldown ReportJul 17, 2017. Create SSRS drill down report, add link enable/disable based on specific condition, adding download links in reports.
  • Using PowerApps - Authoring Made Simple And PowerfulJul 16, 2017. I am glad to bring you up with the latest change in the PowerApps Studio, in the latest version (2.0.660), the enhanced capabilities are showed and discussed in this article, PowerApps Studio had changes in the Properties Panel, Viewing data with the edit form, global variables, and the reset function.
  • ABC Of WPFJul 15, 2017. Basically I am working on .Net/Sql. For the project requirements I went through the WPF. I visited so many online tutorials and videos to get the knowledge. In this article I am going to share my understanding with you.
  • Create A Content Type In SharePoint 2013Jul 14, 2017. Here I am going to explain how to create a content type in SharePoint 2013 or SharePoint online and use the same content type in SharePoint list .

About What-is-DDL-statement-in-sql

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!