C# Corner

Resources  
  • Sharing Data To Third-Party ServicesJan 20, 2018. The ActivityViewController is a controller that allows the current application user to share the data in the form of text, images etc easily between the current application and services. There are a number of services such as social networks, email, and sms that are provided by the operating system where we can share the data easily.
  • Custom Model Binding In ASP.NET Core 2.0Jan 17, 2018. In an earlier post I discussed how to prevent insecure object references by encrypting the internal references (e.g. table primary keys) using Data Protection API. To avoid duplication of code that encrypts/decrypts on every controller I used filters in that example. In this post I’ll use another complimentary technique: custom model binding.
  • Stored Procedures In Azure Cosmos DBJan 16, 2018. There are many performance benefits when executing complex operations like Batching in case of using Stored Procedures. Reason is all these operations get executed closer to data as Stored Procedures are stored at server side.
  • Why Dynamic Query Is BadJan 15, 2018. In this article, we will be talking about Dynamic Query and why it is bad.
  • An Introduction To Q#Jan 15, 2018. In this article, I will be explaining about Q# - the new programming language introduced by Microsoft for quantum computing. We will understand the data type, expressions, and statements of Q# with the help of code snippets.
  • Learn About Microsoft KaizalaJan 15, 2018. Microsoft Kaizala is a mobile application designed for group communication and work management. It is used to efficiently manage the work or collect data from individuals or large groups, even if they are not part of the organization. It makes easy to connect and co-ordinate work with the field employers, vendors, partners and customer wherever they are.
  • Comparison Of Subquery And JoinsJan 15, 2018. Here, in this article, we are comparing the SQL Join and SQL Subquery.
  • Google Chart With ASP.NET Core And Visual Studio CodeJan 13, 2018. The Google Chart API lets you dynamically generate charts with a URL string and embed these charts on a web page, or download the image for local or offline use. The Google Chart Tools enable adding live charts to any web page. They provide advantages such as a rich gallery of visualizations provided as image charts and interactive charts and they can read live data from a variety of data sources. Users embed the data and formatting parameters in an HTTP request, and Google returns a PNG image of the chart. Many types of chart are supported, and by making the request into an image tag the chart can be included in a web page.
  • Workflow Initiation Form And Association FormsJan 12, 2018. In SharePoint Workflows, Initiation Forms are used to provide some additional information into the workflow for whom it is triggered or who starts it. Basically, the initiation forms are used to interact with the user, for example - if we want to take some data from the user before the workflow is triggered, this will be done by Initiation Forms. At first, the input will be taken and then the workflow will be triggered. This is the scenario of initiation form.
  • Observables With Angular 5Jan 12, 2018. We have a case where we use observable to populate the UI from the external data asynchronously Angular uses same thing for this task let’s see how we can use the observables and use them in an angular application.
  • Template Driven Forms In AngularJan 11, 2018. We are going to talk about forms. Forms are really important to get the data from the user.
  • Explore Azure Cosmos DB Without Azure SubscriptionJan 10, 2018. Azure Cosmos DB emulator is an exciting tool for getting started with Cosmos Db. This allows us to play with Cosmos DB without even having an Azure Subscription. That means you can write Cosmos DB code in your .net application and view your data on emulator.
  • Most Popular JavaScript LibrariesJan 10, 2018. Here is a list of the most popular JS libraries. In the past few years, Web development has grown rapidly and so is the use of JavaScript libraries. In this article, I’ve collected data on various JS libraries from various references to list the most used JS libraries.
  • Introduction TO PowerApps And Creating Template With ItJan 09, 2018. PoweApps is a collection of software services and apps that work together to fundamentally transform and accelerate. It is provided by Microsoft as a service under Office 365 for non-technical users (no coding experience is required) to build business apps. It can be simple and fast.
  • Ignite UI Data Grid In SharePoint Online Using AJAX - Part OneJan 08, 2018. How to use UI Data Grid in SharePoint Online using AJAX.
  • Hashing In ASP.NET Core 2.0Jan 08, 2018. The new Data Protection API in .NET Core includes functionality to create hashes using PBKDF2algorithm. ASP.NET Core uses this behind the scenes in PasswordHasher class, which is used in ASP.NET Core Identity.
  • State Management In ASP.NET MVCJan 08, 2018. HTTP is a stateless protocol. Each HTTP request does not know about the previous request. If you are redirecting from one page to other pages, then you have to maintain or persist your data so that you can access it further. To do this, there were many techniques available in Asp.Net like ViewState, SessionState, ApplicationState etc.
  • How To Bind Data To A Drop-Down List And An HTML Table With *ngfor In AngularJan 07, 2018. In this article, you will learn how to bind a data to a drop-down list and to an HTML table on selected item from a drop-down list with *ngFor in Angular4.
  • Send Email With Attachment In Office 365 (SharePoint Online)Jan 07, 2018. Recently, I came up with a requirement to send an email with attachment in Office 365 (SharePoint Online). This needs to be a custom functionality wherein for each line item in a jQuery Data table (as shown in below image), user needs to send an email with an attachment to specific email address.
  • Xamarin.Forms - Deep Linking Application Using SQLiteJan 06, 2018. Android deep links open a specific page within an app and optionally pass data to it. Developers may find deep links particularly useful for actions such as clicking a notification or sending an app link via email
  • Store And Retrieve Using FILESTREAM From SQL DatabaseJan 06, 2018. Hello friends today I will explaining you regarding storing and retrieving image, video and other document files from SQL server using FILESTREAM future. If you are new to FIELSTREAM then read my previous article FILESTREAM Feature In SQL Server.
  • Azure SQL Intelligence For Database Administrator And DeveloperJan 05, 2018. When interacting with large volumes of data, Azure SQL comes into the picture. SQL Azure is a cloud database service owned by Microsoft, which is based on SQL Server database technology.
  • How To Install And Start The Reporting Services SharePoint Service In SharePointJan 05, 2018. In this article, we will learn about "How to Install and Start the Reporting Services SharePoint Service in SharePoint".
  • FILESTREAM Feature In SQL ServerJan 04, 2018. Today I am explaining what FILESTREAM is and how to use FILESTREAM in SQL server.
  • Intelligent Image Object Detection Bot Using Cognitive Computer Vision APIJan 02, 2018. Microsoft Cognitive services is set of cloud based intelligence APIs for building richer and smarter application development. Cognitive API will be used for searching meta data from Photos and video and emotions, sentiment analysis and authenticating speakers via voice verification.
  • Repository Pattern In ASP.NET MVCJan 02, 2018. In this article, we will learn about Repository pattern which is mostly used to create enterprise applications. Repository pattern divides application’s UI, business logic and data access components into different layers that are easily maintainable and testable.
  • R Services In SQL Server 2017Jan 02, 2018. Hello Everyone. In this article I will be demonstrating how to use R Services in SQL Server 2017. This article is intended for those who have a basic idea of R language. If you don't, still no worries. You can still go through and grab it easily. I will go into details of R language in some other article.
  • Xamarin.Forms - Dynamic GridViewJan 02, 2018. This article demonstrates how to create Dynamic GridView using Xamarin.Forms. If you ever need to show something in a data-bound grid view that is not in your data source, just create that extra row dynamically.
  • Understanding Data Structures - Linked ListsDec 26, 2017. In this article we will go through the basics of linked list data structure and implementation of it in various programming languages like C, C++, C#, Java, Python, VB.Net
  • ASP.NET MVC 5 - Buttons In Datatables jQuery PluginDec 26, 2017. Table view is one of the most important and basic forms of presenting data on a web page. However, adding action to each row is equally important simply because action for each row leads to different results. Jquery Datatables plugin is one of the most used plugins, as I have demonstrated its integration in ASP.NET MVC5 - Datables Plugin Server Side Integration in one of my articles.
  • Validation Of Excel Data In C#Dec 24, 2017. This article demonstrates how to validate an Excel sheet before uploading or storing its data into a database.
  • Configure Data Gateway With SQL Server Database Using Recommended Or Enterprise ModeDec 23, 2017. In this article, we will discuss how we can configure Data Gateway for On-Premise SQL SERVER Database for Live Data Connection using Recommended Mode.
  • SharePoint 2013 - Different Ways To Enable User Information ListDec 22, 2017. You can find a great description of User Information List on MSDN, yet if I had to explain it in brief I would say it’s a list which stores the users and their information. The information of the users includes details like their Name, Email ID, Display Name, Login Name, Job Title, About User, and Department. Whenever a user is added to the site, he/she appears in the User Information List. The User Profile Services sync the user data into the User Information List from Active Directory.
  • How To Configure Data Gateway With SQL Server Database For Live Data Connectivity Using Personal ModeDec 21, 2017. In this article, we will discuss how we can configure Data Gateway for On-Premise SQL SERVER Database for Live Data Connection using Personal Mode.
  • Indexing In Azure Cosmos DBDec 21, 2017. By default, the Azure Cosmos DB data is indexed. Azure applies its default indexing policy while creating a collection. However, a user can set their customized indexing policy as per requirement.
  • Classify Twitter's Tweets Based On Naive Bayes AlgorithmDec 20, 2017. This article explains the way to classify twitters' tweeted data based on Machine Learning's Naive Bayes Algorithm
  • Xamarin.Android - Working With Firebase Database - Part TwoDec 20, 2017. Today, we are going to learn how to save and retrieve data from Firebase in Android.
  • Querying ConsmosDB Using SQL APIDec 19, 2017. Here, we can find the first name and number of pets from child entity but to find out the last name we need to refer to family entity. To select last name along with first name we need to use join operator In DocumentDB
  • Xamarin.Android - Working With Firebase Database - Part OneDec 19, 2017. Today, we are going to learn how to save and retrieve the data from Firebase in Android.
  • Stored Procedures Vs User Defined Functions And Choosing Which One To UseDec 19, 2017. In SQL Server, we usually come across queries, tables, views, stored procedures and functions. People often wonder what are the real differences between User Defined Functions (UDF) or simply functions and stored procedures or just procedures. There are two types of functions: Built-in and user defined. Built-in functions cannot be modified where as you can create and modify your own UDF. To utilize the full advantage of these features, we should understand their capabilities and what we can do with them and what we cannot. I am going to explain this in terms of SQL Server.
  • Getting Started With Apache SparkDec 18, 2017. In Big Data, Hadoop components such as Hive (SQL construct) , Pig ( Scripting construct), and MapReduce (Java programming) are used to perform all the data transformations and aggregation . Now with Apache Spark the same is being achieved with many more advantages like unified API performance, and support for multiple languages, 10X-100X faster than MapReduce.
  • Partitioning In Azure Cosmos DBDec 18, 2017. This article gives an overview of partitioning in Azure Cosmos DB. The partition key is the JSON property (or path) within your documents that can be used by Cosmos DB to distribute data among multiple partitions.
  • Export SQL Result To A Text FileDec 18, 2017. This article gives an overview of how to export SQL query results to a text file.
  • Kendo Tree View Remote DatabindingDec 17, 2017. From this article, you will learn how to implement the Kendo tree view with remote data-binding.
  • Overview Of Data Gateway In Power BIDec 17, 2017. In this article, we will discuss about Data Gateway in Power BI. We will discuss about Personal and Enterprise Mode of Installation of Power BI Gateway. We will also check minimum system requirements to install a data gateway. With this we will also discuss when to use Personal Mode and when to use Recommended or Enterprise Mode for installation.
  • Xamarin Android - Working with Existing DBDec 16, 2017. In this article, I shall show you how to retrieve user data from existing SQLite Database.
  • MVVM Lite For Data Binding In Xamarin.FormDec 16, 2017. We are using MVVM light that will provide the facility to implement Model-View-ViewModel. This is the quick way for development of an application and also provides a user the facility to customize and design the application.
  • Handling Concurrency In ASP.NET Core 2.0 Web APIDec 15, 2017. We add a magic value to the response based on data we hold at the time. Usually ETag header is added for this purpose containing hashed value based on data/body of response.
  • Introducing Hadoop /Big Data For BeginnersDec 14, 2017. Companies like Facebook ,NASA, and Google have huge amount of data (can be hundreds of petabytes or exabytes). Each and every like, click, comment, review, update, search, call, visit, piece of financial and health information, transaction, photo upload etc., which is a very huge data set, gets stored somewhere(database).This data is called Big Data.
  • MySQL Data Access API Development Using Express.JS, Node.JSDec 14, 2017. In this article, we are looking into introduction of Node.JS, Express.JS and then I am going to create Simple MySQL data access API using Express.JS, Node.JS.
  • Create Your First Azure SQL Database Using Azure Portal Dec 14, 2017. In this article, we will talk about how we can create a new database in Azure SQL. We will learn each step in a brief manner. Most of the time when we are beginner in Azure we always have a question how we can create a database in Azure SQL. It’s very easy and simple.
  • DirectQuery Mode In Power BIDec 13, 2017. In this article, we will talk about the two ways to import data into Power BI. When we connect any data source, it will import copy of the data in Power BI. For some data sources, an alternative approach is available: connect directly to the data source using DirectQuery.
  • What XSLT Transformation Is And How To Use ItDec 12, 2017. XSLT (Extensible Stylesheet Language Transformations) is a language for transforming XML documents into other XML documents. Sometimes the user wants to some kind of xml structure instead of whole xml; In that case we can use XSLT transformation. This article gives us idea about this.
  • Deep Walk On Azure Machine Learning - Why On Cloud And That Too On AzureDec 12, 2017. This article goes up with a deep walk on Azure Machine Learning covering the topics with lot many modules which heads up with loading data in azure machine learning, data preparation, azure machine learning modelling, deploying the models and about r scripts in Azure.
  • Using jqGrid With ASP.NET MVCDec 12, 2017. If you belong from a background of asp.net web forms then there is grid view which we used most but in some scenario if data was large then it would use to break, but in MVC we do not have that kind of grid which has all readymade event, but there is html helper which help you to generate html is Web grid in that we need to use different package for handling paging of grid, and also we need to pass a strongly typed model to view for rendering the grid.
  • 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.
  • Learn Angular 4.0 In 10 Days - Data Binding - Day ThreeDec 11, 2017. In this article, we will discuss data binding in Angular JS 4.0
  • Implement Symmetric And Asymmetric Cryptography Algorithms With C#Dec 09, 2017. How to encrypt and decrypt data using Symmetric and Asymmetric algorithms using C# Programming language
  • Roles And Responsibilities Of SQL Developer Dec 09, 2017. In this article, I have shared the Roles and Responsibilities of a SQL Developer.
  • 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.
  • How To Control SQL Injection In PHPDec 07, 2017. This is an interview question, when a person showcases himself as the FULL Stack developer, it is very important that the developer should have base knowledge on the security aspects of the applications.
  • Understanding Classes In KotlinDec 07, 2017. In the above example, I have created a nested class ‘Nestedclass’ which has a data member ‘b’ and a member method show(),now the object of nested class can access member of nested class only.
  • How To Find Duplicate Records In SharePoint ListDec 07, 2017. In this article, we will see how to detect duplicate records in SharePoint Lists. This automation approach will be helpful in scenarios where we need to fix data duplication issues across multiple SharePoint Lists.
  • How To Optimize SharePoint Custom Pages Using HTML 5 IndexedDB APIDec 07, 2017. In this article we will discuss another obvious performance issue with SharePoint Solutions involving large volumes of data transactions surfacing in SharePoint Custom Pages.
  • 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.
  • How To Use Indexed DB To Improve Page Load PerformanceDec 05, 2017. Indexed DB is a local storage system, which will store data in client-side on browser. This is useful for applications that require us to store large amounts of data. These applications can run more efficiency and load faster.
  • How To Create Three-Layer Architecture Of ASP.NET ApplicationDec 03, 2017. Three-layer architecture is made of Presentation, Business, and Data access layer. In this article, I will create three layered architecture with the help of a simple asp.net application.
  • Angular 5 Property - Event BindingsDec 02, 2017. Binding is the process which forms the connection between the application UI and the data which comes from the business logic. In Angular it can be called the automatic synchronization of the data and the view.
  • 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.
  • Difference Between MySQL DATETIME And TIMESTAMP DataTypesNov 29, 2017. A simple question that may come to one's mind while working with MySQL is "Whether to assign DATETIME or TIMESTAMP datatype for a column as both seem to store the same data?”. Even though they store the same data, they differ in some ways and let's check those things out with the help of a small example.
  • Passing Data Between Components - Day TwoNov 29, 2017. We have seen that we can pass the data between the components using the @Input and @Output directives and using event emitters. Let’s see the other two methods - @View child and the services which can be used to pass the data between components.
  • Building Entity Framework Disconnected Generic RepositoryNov 29, 2017. The repository pattern separates and retrieves data model mapping logic from the business logic. We will create a repository class for each entity class in our application. All these classes usually have a main group of equals methods.
  • 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.
  • How To Add Test Data For SharePoint Online Using Test Data AppNov 29, 2017. In this article, we will learn how we can add Test dummy data with SharePoint Online List , Document Library , Calendar List , Tasks and Events. We will use one third party utility which is totally free to use.
  • Adding A DataDisk To Our Virtual MachineNov 28, 2017. This article shows how to add a disk to our Virtual Machine for additional data storage.
  • Passing Data Between ComponentsNov 28, 2017. Article explains 2 Methods of communication between the components .
  • Virtual Entity - New Way Of Integration - Part TwoNov 28, 2017. This is our second article regarding virtual entity, if you have not checked our earlier article, we suggest you check that first here. In this article we are going to demonstrate about create OData Web API without Entity Framework and hosting it in Azure to consume into Dynamics 365. Let say we have employees data that we want to show into virtual entity, so let’s get started!!
  • 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
  • Convert XML File To Excel FileNov 27, 2017. Here, we are going to learn to read XML files in C# WindowsForm applications. We are going to make a small single-form application which takes an XML file from the user and convert XML Data to Excel Data and Returns an Excel File.
  • Pug Vs HTMLNov 26, 2017. In the holy wars of "Pug vs HTML", it is really confusing sometimes to realize which one of these to use. The same is true for SQL vs NoSQL, and the similar is true for Java vs Python. Then people think why not talk about Pug vs HTML as well. HTML is always the perfect language to consider, however for the case of Pug there might be a bit of confusion. Some developers don't know Pug, and some who know it, know it as a Jade framework.
  • 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.
  • Classify Data Based On K-Nearest Neighbor Algorithm Machine LearningNov 25, 2017. This article will explain the concept of data classification based on K-Nearest Neighbor Algorithm of Machine Learning
  • Transform Web.Config File While Deploying The Web Application ProjectNov 25, 2017. One of the nice features that supports Visual Studio 2010 and above versions is Web.Config (XDT) transformations.
  • Connecting R Software With Oracle DBNov 24, 2017. This article is about how to connect the R software with Oracle database so that the data can be brought inside R environment for analysis
  • 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.
  • Creating An Event Hub On The Azure PortalNov 24, 2017. In this article, I am going to describe and demonstrate the creation of Event Hubs on the Azure Portal.These Event Hubs are used to act as a port to collect the streaming data and processing of that data per second.
  • How To Track Facebook Wall Messages In An Excel Table Using Microsoft FlowNov 22, 2017. Microsoft Flow is a cloud-based service. It allows us to react to an event in one and do something with the data from that event into another service. It makes it practical and simple for line-of-business. The users can build workflows that automatically do some business tasks and processes across applications and services.
  • Creating A Data Science Virtual Machine(DSVM) For Linux In The Azure PortalNov 21, 2017. In this article, I am going to demonstrate how to create the Data Science Virtual Machine for Linux on the Azure Portal and connect the DSVM to visualize the VM using X2Go Client Software.
  • Use SQL Server 2017 in Docker ContainersNov 21, 2017. How to use SQL Server 2017 on Docker containers to automate deployment using VSTS
  • Creating A SQL Database And SQL Server On The Azure PortalNov 20, 2017. This article shows how to create a SQL Database and Server on the Azure Portal and also the process of configuring the threat protection to our Database.
  • Creating An Azure Data Lake Store And Data Analytics Account In Azure PortalNov 20, 2017. This article shows how to create an account on Azure Data Lake and Data Analytics in the Azure portal.
  • 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.
  • Simplest WPF Dependency Property For Beginners On Background ColorNov 19, 2017. Dependency property is not wrapped over any private members unlike CLR properties, and it is also stored in Key-Value pairs inside the DependencyObject host instance. You must use Dependency properties if you need to create and apply properties on custom usercontrols, or change properties based on external inputs like Theme, Style, animation etc, or while applying data binding or set with a resource (static/dynamic) .
  • Using Custom Document Template And Quick Parts To Get Column Values From SharePointNov 17, 2017. Quite often there is situation when user wants to save documents with metadata in SharePoint library and to accomplish this we can use document template, customize it and by using Quick parts in Microsoft office we can save Meta data in library and in Microsoft office documents.
  • Two Way Data Binding In Angular Without $scope Object Using MVCNov 16, 2017. Data binding is the most useful and powerful feature among any of the existing or upcoming software development technologies. It is actually a process that bridges a connection between the view and business logic of the application.Basically we will see one-way and two-way data binding with respect to AngularJS applications. But before we jump to that section we will try to learn something about the scopes in AngularJS.
  • Auto Complete with ngTagInput using Web API in AngularJSNov 16, 2017. AutoComplete,ngTagInput,Web API,AngularJS,AutoComplete in AngularJS using Web API
  • How To Save Office 365 Email Attachment To OneDrive With Microsoft FlowNov 16, 2017. Microsoft Flow is a cloud-based service. It allows us to react to an event in one and do something with the data from that event into another one Service. It makes it practical and simple for line-of-business. The users build workflows that automatically do some business tasks and processes across applications and services.
  • Build Intelligent Apps with Microsoft Data PlatformNov 16, 2017. Learn how to build intelligent apps using Microsoft data platform and tools.
  • 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.
  • What Is SQL Operations StudioNov 15, 2017. Learn and download SQL Operations Studio

About Transforming-SQL-Data

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!