C# Corner

Resources  
  • Create A Website Having Azure Active Directory Authentication Using Visual StudioSep 19, 2017. Azure Active Directory (Azure AD) is Microsoft’s multi-tenant, cloud based directory and identity management service. Azure AD combines core directory services, advanced identity governance, and application access management. Azure AD also offers a rich, standards-based platform that enables developers to deliver access control to their applications, based on centralized policy and rules.
  • Gallery Android App Using Android StudioSep 19, 2017. In this article, I will show you how to create an Android App using Android studio. Gallery is either in a building or on the internet, where photographs are on display.
  • 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.
  • AVPlayer In Xamarin iOSSep 19, 2017. In this article, you will learn how to play videos using AVPlayer in Xamarin iOS, using Xamarin Studio.
  • Exposing Local Web Server To Internet Using NgrokSep 19, 2017. I was recently working on some bot framework applications where I wanted to test if my bot application was working properly with different available channels like Facebook messenger, Skype etc. But there was one problem. Before I could integrate my bot with different channels, I needed to publish my bot application and register it on http://dev.botframework.com/ site. Also the endpoint should support HTTPS. This is where ngrok comes into play.
  • 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.
  • Introduction To Tag Helpers In ASP.NET CoreSep 18, 2017. Tag helper is a new feature in ASP.net MVC. It enables server-side code to create and render HTML elements in Razor View. It is feature of Razor View engine. They are the C# classes which participate in view generation by creating the HTML elements. Using the tag helper, we can change the content of HTML element and add additional attributes to the HTML element. It is very similar to HTML helper in ASP.net MVC.
  • Serve Static Files In ASP.NET Core Using Visual Studio 2017Sep 18, 2017. This article explains about static files and how to set default page using static files in ASP.NET using Visual Studio 2017 in a step by step way.
  • Missing Security Section In PWA Settings In Project Server 2016Sep 18, 2017. In this article, we will discuss and solve the issue of Missing Security Setting in PWA Settings in Project Server 2016 / 2013.
  • App That Changes Background And Audio Player In Android, Using Android StudioSep 17, 2017. In this article, I will show you how to change background and audio player Android App using android studio.
  • 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
  • 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.
  • Android Application To Set Silent Mode, Ringer Mode, And Vibrate Mode In A PhoneSep 15, 2017. Android is one of the most popular operating systems for mobile. In this article, I will show you how to set silent mode, ringer mode, vibrate mode in an Android application using Android studio.
  • Change Android Application Icon Using Android StudioSep 15, 2017. In this article, I will show you how to change the Android application Icon using Android studio. Icons are part of the graphical user Interface of the mobile application.
  • Using MPMoviePlayer In Xamarin iOSSep 15, 2017. Xamarin is a platform to develop cross-platform and multi-platform apps (for example, Windows Phone, Android, iOS). In Xamarin platform, the code sharing concept is used. In Xamarin Studio, Visual Studio is also available.
  • Create Bluetooth Android Application Using Android StudioSep 15, 2017. Android is one of the most popular operating systems for mobile. In this article, I will show you how to create Bluetooth android applications using Android studio.
  • SharePoint Permission Mode Vs Project Permission Mode In Project Server 2016 / 2013Sep 14, 2017. In this article, we will discuss the Permission Modes in Project Server 2016 / 2013.
  • 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.
  • Rating Bar In Xamarin iOSSep 14, 2017. In this article, you will learn how to create a Rating Bar in Xamarin iOS, using Xamarin Studio.
  • How To Show Interstitial Ad Every 20 Seconds In An Android ApplicationSep 14, 2017. Android is one of the most popular operating systems for mobile. In this article, I will show you how to show interstitial ads every 20 seconds in an Android application using Android studio.
  • Create Voice Search Android Application Using Android StudioSep 14, 2017. Android is one of the most popular operating systems for mobile. In this article, I will show you how to create Voice Search android application using android studio
  • File Upload With JQuery Progress Bar In ASP MVCSep 14, 2017. First we have to create an Asp Mvc project in visual studio. To do that, Open Visual Studio -> New Project -> A new dialog window will appear -> In left pane select C# ->select Web -> Select "ASP.NET MVC 4 Application" name your project and click ok.
  • Create Text To Speech Conversion Android Application Using Android StudioSep 14, 2017. Android is one of the most popular operating systems for mobile. In this article, I will show you how to create a text to speech conversion Android application using Android studio.
  • 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.
  • Build Chat Application On MEA2N Stack - Part OneSep 13, 2017. In this article we are going to build a basic chat application on NodeJs platform using Express and Angular 2. For saving chat history we will use MongoDB. We will be using socket.io for communication between server and client.
  • GitHub Extension In Visual Studio 2017Sep 13, 2017. In this article, I will explore the GitHub Extension for Visual Studio 2017. GitHub is a web-based graphical interface Git or version control repository that mostly used for code. It provides for each project access control and several collaboration features like bug tracking, feature requests, task management, and wikis.
  • How To Create A Calling Application In Android Using Android StudioSep 12, 2017. Android is one of the most popular operating systems for mobile. In this article, I will show you how to create a Calling Application in Android Using Android Studio.
  • How To Create A Camera Application In Android Using Android StudioSep 12, 2017. Android is one of the most popular operating systems for mobile. In this article, I will show you how to start the camera application in Android using Android Studio
  • How To Add Android Exit Dialog To Android App Using Android StudioSep 11, 2017. Android is one of the most popular operating systems for mobile. In this article, I will show you how to add Android Exit Dialog to Android App Using Android Studio.
  • Create TimePicker Android App Using Android StudioSep 11, 2017. Android is one of the most popular operating systems for mobile. In this article, I will show you how to create a TimePicker Android application using Android Studio.
  • Create Calendar Android ApplicationSep 11, 2017. Android is one of the most popular operating systems for mobiles. In this article, I will show you how to create a Calendar android application. Calendar is an important thing to handle the events and commitments. So, I will show you how to create calendar in Android applications using android studio.
  • Create Web Browser Android Application Using Android StudioSep 10, 2017. Android is one of the most popular operating systems for mobiles. In this article, I will show you how to create a Web Browser android application using android studio.
  • 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.
  • 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.
  • Visual Studio Team Service - Trigger A Build Using Any HTTP ClientSep 07, 2017. In this post, we are going to see how easily we can trigger a new build in VSTS from any of our widely used HTTP clients likeFfiddler or Postman.
  • Creating A Mini Browser Using Visual StudioSep 06, 2017. In this article, we will be creating a mini browser using Visual Studio.
  • 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.
  • 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.
  • Getting Started With ASP.NET Core And Angular 4 Using WEB APISep 06, 2017. In this article, let’s see how to get started with ASP.NET Core and using Web API. Select depending on your need and install the Visual Studio 2017 on your computer. If you have already installed Visual Studio 2017 then skip this part.
  • UIToolbar In Xamarin.iOSSep 06, 2017. In this article, you will learn how to Create a Tool bar View Using UIToolbar in Xamarin iOS, using Xamarin Studio.
  • Understand Serverless Architecture In AzureSep 05, 2017. This article will give an overview about the server-less architecture functionality present in Azure using Logic App.
  • Platform Mobile Analytics Tools For Efficient App ManagementSep 04, 2017. Analytics is crucial for an effective app management. Modern app analytics tools let you know whether your app is functioning as it should or there is a need for upgrading. Nowadays, the selection of these tools is impressive. The choice of the right tool helps not only speed up your return on investment for, let’s say, the cost of outsourcing app development or any other development expenses but also arrange future business outgoings.
  • 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.
  • Create Timer Task Application In Xamarin.Forms Using Visual StudioSep 04, 2017. Xamarin is the best cross platform tool to develop mobile applications. It provides cross platform app development in C#, so we don’t need to write java or Objective C. We can just use C# and leverage the same for all the platforms. Xamarin also helps us by providing the designers with the different platforms like Android,IOS,etc.
  • User Guide To Enroll iOS Device With Microsoft Intune And Configuring Outlook AppSep 04, 2017. If your company or school uses Microsoft Intune for Mobile Device Management and Mobile application management, you can enroll your iOS device to get access to company email, files, and other resources. When you enroll your devices, your IT department can manage the resources, keep them secure, and give you the freedom to use your preferred device to get your work done.
  • Create Local Notification In Xamarin.Forms Using Visual StudioSep 04, 2017. Xamarin is the best cross platform tool to develop mobile applications. It provides cross platform app development in C#, so we don’t need to write java or Objective C. We can just use C# and leverage the same for all the platforms. Xamarin also helps us by providing the designers with the different platforms like Android,IOS,etc.
  • Create StopWatch Application In Xamarin.Forms Using Visual StudioSep 04, 2017. Xamarin is the best cross platform tool to develop mobile applications. It provides cross platform app development in C#, so we don’t need to write java or Objective C. We can just use C# and leverage the same for all the platforms. Xamarin also helps us by providing the designers with the different platforms like Android,IOS,etc.
  • 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”.
  • Load Testing Web Service Using Visual StudioSep 04, 2017. Web Services are the more commonly developed and used to expose the APIs for other systems to consume. Number of external systems consume the web services on a frequent basis.
  • 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 Upgrade AD FS 3.0 To AD FS Server 2016 - Part TwoSep 01, 2017. This article is in continuation of my previous one. Here we will see how to upgrade AD FS 3.0 to AD FS Server 2016.
  • Basics Of ASP.NET Core Using Visual Studio 2017 - Part TwoSep 01, 2017. In this article, I have explained about ASP.NET Core using Visual Studio 2017 and how to create ASP.NET Core applications in simple ways. Before reading this article please read the previous part of this article using the below link.
  • How To Upgrade ADFS 3.0 To AD FS Server 2016 - Part OneAug 31, 2017. Being said that, Now a days ADFS is one of the very critical infra since it is used for Identity services which being used for office365, Azure, Applications be it in any which way it is been created/developed in terms of SAAS, PAAS and On-premises. I have seen the scenarios where ADFS is down, the complete company’s major applications are also going down. So we need to carefully plan and upgrade the ADFS infra. Any wrong command or wrong execution plan can mislead the infra and complete ADS infra can go down.
  • Extend Built In Label Tag Helper In ASP.NET Core ApplicationAug 31, 2017. Tag helpers is one of the new feature introduced in ASP.NET Core which allows us to add server side code while creating and rendering HTML elements. They are similar to HTML helpers in ASP.NET MVC. ASP.NET Core comes with various built in tag helpers for rendering HTML elements like label, input, img, select etc.
  • How To Add Custom Font To Android TextviewAug 29, 2017. Android is one of the most popular operating systems for mobile. In this article, I will show you how to add custom font to Android textview using Android Studio.
  • How To Develop A Simple EMI Calculator Using Android StudioAug 29, 2017. Android is one of the most popular operating systems for mobile. In this article, I will show you how to create a Simple EMI Calculator Android application using Android Studio.
  • How To Work With Multiple Modules In Angular v4Aug 29, 2017. In this article, we will learn how to configure Angular application using multiple module.
  • 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 in Machine Learning - An Intent Based Network ManagementAug 28, 2017. Implementation and application of Machine Learning are growing rapidly across different industries. The next big thing is Intent-Based Network or IBN.
  • 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.
  • Azure API App With ASP.NET WEB APIAug 27, 2017. In this article, we will see how to create Azure Web Api with your Visual Studio tool. Create a sample Web API Application in VS 2015 and publish Web api in Azure.
  • 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.
  • Create Your Own Home .NET /Apache Web Server In 30 MinutesAug 25, 2017. Most C# developers have been yearning to install their work on Apache and Linux, using the Mono project for years. Unfortunately this has been historically very difficult, since the documentation for how to do this has been lacking. In addition, securing and configuring the system after you've installed it, often requires a whole slew of knowledge with which most C# developers are not very familiar.
  • Create Email Android ApplicationAug 24, 2017. Android is one of the most popular operating systems for mobiles. In this article, I will show you how to create a Email Android application using Android Studio.
  • Create ToolBar Menu Items In Xamarin.Forms Using Visual StudioAug 24, 2017. Xamarin is the best cross platform tool to develop mobile applications. It provides cross platform app development in C#, so we don’t need to write java or Objective C. We can just use C# and leverage the same for all the platforms. Xamarin also helps us by providing designers with different platforms like Android, IOS, etc.
  • 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.
  • 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.
  • Building A Simple Web App Using Razor PagesAug 23, 2017. In this article , you will learn how to build a simple CRUD web app using Razor Pages , which is new in ASP.NET Core 2.0. This web app is about the management of the students , and all operations of the database will be through API building by NancyFx.
  • Create Native Calculator Android ApplicationAug 22, 2017. Android is one of the most popular operating systems for mobile. In this article, I will show you how to create a Native Calculator Android application using Android Studio.
  • 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.
  • JavaScript Code For Validating U.S. Format Phone NumbersAug 21, 2017. In this article, we shall learn how to do client side validation of US format phone numbers in three textbox fields. It means the application will be more responsive because the load on the server is reduced. JavaScript uses the client machine processing power.
  • 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.
  • Introduction To Microsoft's Coco Framework For Blockchain Applications - Part TwoAug 17, 2017. In this article, we are going to discuss about blockchain network management in Coco framework.
  • Basics Of ASP.NET Core Using Visual Studio 2017 - Part OneAug 17, 2017. This article explains about ASP.NET Core using Visual Studio 2017 and the ways to create ASP.NET Core application.
  • QR-Code Scanning Using Android StudioAug 17, 2017. Android is one of the most popular operating system for mobile. In this article how to scan QR code without camera options using Android studio Android is kernel based operating system that allows the user to modify the GUI component and source code.
  • The Future Of C# At A GlanceAug 17, 2017. C# is one of the top ten most popular programming languages. It’s been 16 years since Microsoft released C# in 2000 and is considered the foremost emerging programming languages because of the maturity it has accrued. Today C# 7.0 is available as a part of Visual Studio 2017.
  • Getting Started With Microsoft Azure Functions Using Visual Studio 2017Aug 17, 2017. Azure Functions is a solution for easily running small pieces of code in the cloud. We can create, execute, and test our custom logic function without creating a VM or web applications and also without needing to install any software or infrastructure to run the function.
  • Docker And Docker Tool In Visual Studio 2015Aug 17, 2017. Docker is an open-source project for automating the deployment of applications as portable, self-sufficient containers that can run on the cloud or on-premises. Build Once and Run Anywhere is the mantra for Docker. Docker is also a company that promotes and evolves this technology, working in collaboration with cloud, Linux, and Windows vendors, including Microsoft. Docker image containers can run natively on Windows and Linux. The blog is mainly focused on explaining Docker, how to install Docker on development environments and how to run the ASP.Net Core application on it.
  • UIPickerView In Xamarin iOSAug 17, 2017. In this article, you will learn how to create a Picker View using UIPickerView in Xamarin iOS.
  • 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.
  • Understand Service Scheduler In AzureAug 14, 2017. It is a task scheduling service provided by Microsoft Azure. It can perform many actions regarding the job details in the scheduler and can also check Scheduler’s monitoring and management capabilities.
  • 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.
  • Manage Web Applications On SharePoint 2016 Central Administration - Part OneAug 10, 2017. Here, we will see how the Central Admin controls management of the web application.
  • Building Container Image Through AutomationAug 10, 2017. The following is the continuation of the previous document. Here we will work with the automation concept through which the container images can be created.
  • Making The Switch As A Software DeveloperAug 09, 2017. After nearly seven years at my previous position, I've decided to finally make a change. When this post goes live, I'll officially be working for the engineering team at Bay Dynamics, a San Francisco-based Risk Management and Cyber Security firm. I'm extraordinarily excited to get to join the amazing team there and be a part of something much larger than anything I've worked within the past.
  • Aligning And Formatting The C# And ASPX/CSHTML Code Using Visual Studio 2017Aug 09, 2017. Aligning code in the code-behind as well as in front-end makes the code more professional look. The Visual Studio Code Editor gives you the ability to format your code with options such as hiding text, displaying URLs, and so forth.
  • 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
  • Deploying An Ubuntu Server 16.04 LTS Virtual Machine Using Microsoft AzureAug 08, 2017. In computing, a Virtual Machine is an emulation of a computer system. Virtual machines are based on computer architectures and provide functionality of a physical computer. Their implementations may involve specialized hardware, software, or a combination. Azure Virtual Machine (VM) is one of several types of on-demand , scalable computing resources that Azure offers.
  • 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.
  • 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.
  • 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 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.
  • Facebook Login Using Xamarin.Auth In Xamarin iOSAug 04, 2017. Xamarin is a platform to develop cross-platform and multi-platform apps (for example, Windows phone, Android, iOS). In Xamarin platform, the code sharing concept is used. In Xamarin Studio, Visual Studio is also available.
  • Building Your Own Container ImagesAug 04, 2017. Here, we will be building our own container images. For doing this we have two different ways, namely manual method and automated method. Let us see both ways.
  • Pulling Base Container ImagesAug 03, 2017. So far, we have deployed our container in the Nano Server VM and Windows Server VM. The next piece of work is to pull down the Images for these containers. The Docker is the container which we have created so far. In the following lab, we will pull some image for that container form the Microsoft Container images repository.

About SQL-server-Management-Studio

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!