C# Corner

Resources  
  • Getting Started With Customizing A FormFlow Using Microsoft Bot FrameworkSep 25, 2017. The Bot Framework enables you to build bots that support different types of interactions with users. You can design conversations in your bot to be freeform. Your bot can also have more guided interactions where it provides the user choices or actions. The conversation can use simple text strings or more complex rich cards that contain text, images, and action buttons. And you can add natural language interactions, which let your users interact with your bots in a natural and expressive way.
  • 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.
  • How To Write Simple Todo CRUD ASP.NET MVC ApplicationSep 22, 2017. This article includes a lab exercise for you to demonstrate what have you learned from this training material to create your own Employee CRUD operation using EmployeeRepository
  • How To Migrate Your On-Premises / Enterprise Data Warehouse Into Azure SQL Data WarehouseSep 21, 2017. I will share how you can start migrating your data into the Azure SQL Data Warehouse
  • How To Secure PII Data In SQL Server Using .NET AssemblySep 21, 2017. PII (Personally Identifiable Information) is used to identify individual identity markers such as SSN, DOB, Bank Account Number etc. When you are working with financial applications you face a scenario where you have to store the data in encrypted format, so no one can see the actual data.
  • Purchasing A New Service To Your Office 365 TenantSep 21, 2017. This is going to be a very simple article where I’ll be describing about how to add a new service to your Office 365 tenant. Let’s say there comes a scenario where your organization has been using Office 365 for quite some time and all of a sudden, the business shows interest on a new Office 365 service then you need to follow the steps mentioned in this article below to purchase that new service for your existing Office 365 tenant.
  • 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.
  • 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.
  • 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.
  • 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.
  • Multiple Pages On The Form Using Panel Control In A Simple Windows Forms ApplicationSep 15, 2017. In this article, we will learn how to show multiple pages on the form using Panel Control in a simple Windows Application.
  • 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.
  • 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.
  • 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.
  • ASP.NET Core 2.0 ConfigurationSep 11, 2017. ASP.NET Core has a simple mechanism to read application settings from various sources like JSON files, Environment variables or even custom data sources. It is also simple to use the settings, thanks to Dependency Injection.
  • Use Of HttpResponseMessage In WebAPISep 11, 2017. Here, you will learn the uses of HttpResponseMessage WebApi. For better understanding we will go step by step with simple examples.
  • 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.
  • SharePoint 2016/2013/Online - Sites Health Monitoring By PowerShell AutomationSep 08, 2017. In this article, we will discuss a simple yet powerful automation technique using PowerShell that will try pinging the Site and if it fails, it will send the email notifications to the designated SharePoint Admins for the Site.
  • 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.
  • 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 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • Search Data From Xamarin.Forms List ViewSep 04, 2017. In this article, we are going to search some data from list view of xamarin forms. Firstly we can create a list in xamarin forms PCL application. Then add some data in list and make a search bar to search data form list.
  • Getting Started With Raspberry Pi - How To Use BreadboardSep 04, 2017. In my previous article – Understanding Raspberry Pi - GPIO, we talked in about GPIO (General Purpose Input Output). In this article we will discuss about a handy tool – Breadboard – It a must tool for everyone working on building simple to complex circuits and also must when using Raspberry Pi.
  • How To Backup A Mirrored Database Using SQL AgentSep 04, 2017. Database mirroring is a primarily software solution for increasing database availability. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery model. The simple and bulk-logged recovery models do not support database mirroring. Therefore, all bulk operations are always fully logged. Database mirroring works with any supported database compatibility level.
  • How To 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 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.
  • 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.
  • Getting Started With Dialog Using Microsoft Bot FrameworkAug 28, 2017. The Bot Framework enables you to build bots that support different types of interactions with users. You can design conversations in your bot to be freeform. Your bot can also have more guided interactions where it provides the user choices or actions. The conversation can use simple text strings or more complex rich cards that contain text, images, and action buttons. And you can add natural language interactions, which let your users interact with your bots in a natural and expressive way.
  • 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.
  • More Details About Razor Pages In ASP.NET Core 2.0Aug 27, 2017. I built a simple web app to show you the new feature named Razor Pages in ASP.NET Core 2.0 . However it doesn't contain some useful and basic functions. So I decided to write one more article to show more details of Razor Pages.
  • A Simple Windows Forms Application - Using With LoaderAug 27, 2017. In this article, we will learn how the Loader works in between two forms of Windows Application.
  • 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 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.
  • Custom Keyboard In Xamarin.iOSAug 23, 2017. In this article, we are going to learn about how to create a simple custom keyboard in xamarin ios.
  • 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.
  • How To Create Multi-Screen Request Form App For SharePoint Online List Using PowerAppsAug 22, 2017. In this article you will see how to create multi-screen request form app for SharePoint Online list using PowerApps. Refer to getting started with PowerApps and Flow for more details. Refer to my previous article to create a simple approval app using PowerApps and Flow in SharePoint Online.
  • 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.
  • 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.
  • Calendar Events Using EntityFramework In AngularJSAug 18, 2017. Here, I have used ui-calendar directives to create a simple scheduling application for displaying events in a calendar.
  • Using ERB Tags In Ruby On Rails Default HTML TemplatesAug 18, 2017. In this article, you will learn about the view templates, template file naming, ERB tags, and how to use ERB tags in HTML templates.
  • How To Create A Simple Approval App Using PowerApps And Flow In SharePoint OnlineAug 18, 2017. In this article, you will see how to create a simple approval app using PowerApps and Flow in SharePoint Online. Refer getting started with PowerApps and Flow for more details. I have created a custom list in SharePoint online named Change Request which contains the following columns.
  • Custom Model Binding In ASP.NET Core MVCAug 17, 2017. Model binding in MVC maps HTTP request data to the parameters of the controller's action method. The parameter may either be of simple type like integers, strings, double etc. or complex types. MVC binds the request data to the action parameter by parameter name.
  • Understanding API Apps In AzureAug 17, 2017. API apps in Azure make it easier to develop, host, and consume APIs in the cloud and on-premises. It provides security, simple access control, hybrid connectivity, automatic SDK generation, and seamless integration with Logic Apps. It’s a fully managed platform for web, mobile, and integration scenarios.
  • 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.
  • Consuming Restful Services In Xamarin.Forms - Part TwoAug 14, 2017. In the first part, we called a fake RESTFul service, got some data from the service, and displayed it in a list view. Now in this article, we will continue where we left and add, delete some data which we displayed in previous part.
  • How To Create Angular App Using Angular CLIAug 14, 2017. Before 1 year, I planned to create simple angular app but at that time i don't have idea about angular cli so i had configure lot of things and faced more issue.I spend 2-3 days to configure angular app and finally done. In this article we will learn how to create Angular app using angular CLI.Angular CLI is just a command line interface help us to create angular app very eaisly within 2 minute.
  • 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.
  • Creating A Flow To Get New Posts From Microsoft Flow Official Blog AutomaticallyAug 09, 2017. Today, we are going to create a simple flow using Microsoft Flow to get new posts from Microsoft Flow Official Blog automatically, so we can be updated and notified when something new shows up.
  • 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.
  • 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
  • Communication Between Model, View, And Controller In ASP.NETAug 08, 2017. In this article we are going to learn how to communicate between Model, View, and Controller in ASP.NET application.
  • 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.
  • 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
  • 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 TwoAug 06, 2017. This article will allow us to connect with SQL Azure and perform CRUD operations using EF.
  • 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.
  • 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.
  • 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.
  • Running Windows Containers On Windows Container HostsAug 03, 2017. In this module, we will be seeing the different commanding techniques that can be used to work with the containers. We will check on how to start and stop a container, and to run them interactively or even in the background.
  • Configuring Nano Server For Remote ConnectionsAug 02, 2017. Here, we are going to connect with the Docker engine remotely using the PowerShell. For this we can either use our local machine or a VM. Before we proceed further, make sure that your Nano Server is up and running.
  • Creating Windows Server Machine On Virtual Network And Load Balancing itAug 01, 2017. Welcome back to an article about creating another Windows Server Machine on Virtual Network and to work with Load Balancing. Here with this demo article we will be working with the Virtual Network and we will be creating a Load Balancer on it.
  • Connecting To Docker In Nano ServerAug 01, 2017. This is about creating a firewall path in between the local machine and the Nano server to get connected with the Docker. This will give access for local machines to access the docker.
  • 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.
  • Creating A V-Net And Adding A Windows Server Machine On ItJul 31, 2017. Welcome to an article about creating a Virtual Network and adding a Windows Server Machine on it
  • Installing Docker In Nano ServerJul 31, 2017. This is about the installation of Docker in the Nano Server VM which has been created previously.
  • 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.
  • Installing Windows Server-2016 Nano Server Using PowerShellJul 30, 2017. The following exercise is all about the installation of Windows Server 2016-Nano Server. Open your PowerShell in the administrator privileges.
  • Installing Docker In Windows ServerJul 29, 2017. The following document will provide you the step by step guide to create a windows server operating system and install the docker in it. To proceed with this, you need to login into your Microsoft Azure portal.
  • Routing In Angular 2 With TypeScript And Visual Studio 2015 - Part OneJul 29, 2017. In this article, we are going to learn how to implement routing in Angular 2 with an example. Routing is a concept which helps users to navigate from one view to another view of the application. Similarly, routing in Angular 2 helps users to navigate from one view to another view depending upon the URL which user enters in the browser.
  • Managing Your Traffic On Server Applications Using Geographic RoutingJul 28, 2017. Welcome to my first writing on Azure Traffic Manager using Geographic Routing.
  • Creating Web API With ASP.NET Core Using Visual Studio CodeJul 28, 2017. Web API is is framework that allows us to build web or http based endpoints. If you are building services today for mobile, HTML 5, and even client-server desktop applications, all these different types of applications need services in the backend.
  • How To Check Long Server-Side Process Progress In Real TimeJul 26, 2017. Today, I will show you a way to monitor a long server-side process (like, a long running process, file generation etc.) in real time in your web application. The whole demonstration will be covered through asp.net C# but you can also implement the same sort of code in other languages.
  • 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 MVC Using Angular Dynamic Control In DataTableJul 26, 2017. In this article, we will learn MVC using Angular data binding for dynamic control in datatable from server side Web API using visual studio 2017.
  • RDLC Integration In MVC Application - Report Display Using IframeJul 25, 2017. This article demonstrates how to integrate RDLC report in ASP.Net MVC application. Build the solution and run, navigate to Report view, then we will be able to see the following screen that the report displayed in View.
  • Cache Headers For MVC File Action Result (ASP.NET Core 2.0 Preview 2)Jul 25, 2017. I’m pretty sure that you are familiar with StaticFiles middleware of the framework. All it does is serve static files (CSS, JavaScript, image, etc.) from a predefined/configurable file location (typically from inside the web root, i.e., wwwroot folder). But along the way, it also does some cache headers configuration. The reason behind this is you don’t want your server to be called up every time for a file that doesn’t change frequently. Let’s see how a request for a static file looks in the browser’s network tab.
  • 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.
  • Angular, Bootstrap And ASP.NET MVC - Part TwoJul 25, 2017. In this tutorial series, we are going to learn AngularJS as a server side, Bootstrap for layout styling and ASP.NET MVC as server side.
  • ASP.NET Core API Versioning In Simple Words (Update 1.2.0)Jul 24, 2017. This article shows you how to enable API versioning for ASP.NET Core Web API following three different techniques.
  • Angular, BootStrap And ASP.NET MVC - Part OneJul 24, 2017. In this tutorial series, we are going to learn AngularJS as a server side, Bootstrap for layout styling and ASP.NET MVC as server side.
  • React Tutorials - Day Six - FluxJul 24, 2017. Flux is a programming architecture and concept where data flows in an unidirectional way. Flux is not a framework or library, it is just an architecture pattern that was developed by Facebook along with the React View library to manage the data flow into our application. Flux makes it easier to track the changes and bugs during development.

About Simple-View-in-SQL-SERVER

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!