C# Corner

Resources  
  • 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.
  • Exploring And Managing Azure Resources Using Microsoft Azure Mobile App Dec 13, 2017. Microsoft has introduced Azure mobile app for Android & iPhone azure subscribers to get connected with there own Azure resources 24 by 7. Mobile being human chore partner, app made life easier for developers, entrepreneurs or Admin to manage provisioned azure resources anytime from anywhere. Not only can access & manage, but also can monitor health & status of Azure resources. This helps in quick resolving the issues encountered if any.
  • 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.
  • Embedding PowerApps As A Web Part On SharePoint PageDec 12, 2017. This post provides information on how Power Apps can be embedded within a SharePoint Page as a web part.
  • 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.
  • How To Build A Survey Using Survey List In SharePointDec 11, 2017. In this article, I will discuss the process of building a survey in SharePoint Online.
  • Enabling/ Using Content By Search Web Part In Standard Edition Of SharePoint 2013Dec 11, 2017. In this article, I’ll explain how to use/enable Content by searching Web Part in Standard Edition of SharePoint 2013.
  • 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
  • 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.
  • 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 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.
  • How To Save Multiple Links In A List Column And UI On Custom List Form In Visual Web PartDec 06, 2017. In this article, we will discuss how we are storing multiple links in the list field and supporting the UI on custom list form in Visual web part
  • 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.
  • Step By Step Procedure To Create An Azure Logic AppDec 06, 2017. The article is on the detailed procedure of building an Azure Logic App. These steps are described with photos.
  • Show SharePoint List Item Level Attachments Using REST API And jQueryDec 05, 2017. In this article, we explore in Sharepoint 2013, how to show the Sharepoint list item level attachments using REST API and jQuery. In previous articles, I explained about adding multiple attachments to list item using html and JQuery. Now let’s use some REST API to pull these attachments and display them in list.
  • 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 Delete Attachments Of SharePoint List Item Using Rest APIDec 05, 2017. I have created a custom list named “Attachments” in the host site and have added multiple items with attachments, now let’s say that we want to “Delete” the attachments on any particular item which we want.
  • 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.
  • SharePoint 2013 - Changing The URL Of Existing Web ApplicationDec 02, 2017. In this blog, I’ll discuss our customer requirement for changing the URL of an existing web application, changing URL of its extended application, and steps to do those successfully.
  • Enable External Sharing In SharePoint Online Using PowershellDec 01, 2017. The below article explains how to enable the external sharing using SharePoint Admin Center and using PowerShell.
  • 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.
  • Comparing Objects In C#Nov 29, 2017. In this article, we are going to compare two objects of the same class having collection property or multiple collection properties.
  • 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.
  • CRUD Operations On A SharePoint List Using REST APINov 29, 2017. In this article, I am going to explain how to perform CRUD (Create, Read, Update, Delete) operations on a SharePoint list using REST API.
  • 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.
  • 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.
  • Change SharePoint Site To Read OnlyNov 29, 2017. This article will help you out on making your sites read only which is mostly required during your SharePoint migration. These steps have been tested on SharePoint 2010, 2013 and 2016. We have 3 options and we will cover each one. So, let’s get started.
  • 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.
  • 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!!
  • Passing Data Between ComponentsNov 28, 2017. Article explains 2 Methods of communication between the components .
  • 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.
  • 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
  • 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
  • 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.
  • 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.
  • Angular Components And ModulesNov 23, 2017. In programming terms, Modules can be described as the self-contained chunks of the functionality in your application which can run independently. In Angular, Modules are the collection of the components, services directives, and Pipes which are related such that they can be combined to form a module.
  • Developer's Tools - How To Generate Basic Authentication TokenNov 22, 2017. This demo is about another tool that I worked out during an assignment while working with an integration scenario using web services supporting Basic Authentication.
  • SharePoint 2016/2013/Online - How To Apply Password Encryption For Component As Service Using PowerShellNov 22, 2017. In this article, I will discuss the mechanism to authenticate the requests to SharePoint Lists while working with PowerShell.
  • 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.
  • Create Views In SharePoint ListNov 21, 2017. In this article, I will share the steps to create a View in SharePoint list. Already we have gone through how to create a list and their features.
  • 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.
  • 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
  • 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.
  • 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.
  • Three Places To Manage Modern / Classic Experience For Lists And LibrariesNov 15, 2017. This article explains how to manage the classic experience and modern experience for SharePoint Online Lists & Libraries
  • Basic Introduction To ISAPI FiltersNov 15, 2017. In this article we will have a look on ISAPI filters in windows SharePoint services
  • Everything You Want To Know About SharePoint 2016Nov 15, 2017. The new kid in town. Well, I hope you won’t mind when I say that SharePoint 2016 is the new kid in town considering the fact that it has been more than a year since Microsoft has released SharePoint Server 2016 and it has also announced the release of SharePoint Server 2019 a month back at Ignite Conference. However, there’s reason for me to still call SharePoint 2016 as the new kid in town because it still remains to be a cutting-edge platform for many SharePoint professionals out there and I’ve seen many organizations actively working on adapting SharePoint Server 2016 as the modern collaboration platform for their IT workspace.
  • Comment Or Reply To A Post In SharePoint Using AngularNov 15, 2017. Nowadays commenting or replying to a post is the most common thing in all social networks. Hence, in this article I am going to explain how it works in SharePoint using AngularJS. By the help of this article you will learn how to set comment or reply feature to a post in SharePoint using AngularJS.
  • Creating Azure WebJob To Access SharePoint Using Typescript And Node.jsNov 14, 2017. Create a new folder in the solution by the name 'src' and create index.ts file inside the folder. In this folder we will keep all the source files which will get executed when the Job runs. Remember to keep the index.ts at the root of the src and all other files (if any) keep them in the folder otherwise the job will fail.
  • Introducing Microsoft's SharePoint Migration ToolNov 14, 2017. Welcome to an article about Microsoft’s own SharePoint Migration Tool.
  • Custom Search Using Client Side CodeNov 11, 2017. The Custom Search functionality is achieved through JS. The Search produces live results for each key press. This search can be used to filter the data table or html table data dynamically based on the key words entered. The below code explains the search for html table.
  • Upload/ Download Files In ASP.NET Core 2.0Nov 10, 2017. ASP.NET Core MVC model binding provides IFormFile interface to upload one or more files. The HTML form must have encoding type set to multipart/form-data and an input element with type attribute set to file.
  • Masking Sensitive Data With SQL Server 2016Nov 10, 2017. SQL Server 2016 has many features which you can use to make your data and application more secure, more maintained and easily retrieved as per your requirements. It has introduced both client side security such as Always Encrypted as well as server side security such as Data masking etc. In this post we’ll examine how Dynamic Data Masking can help secure our data.
  • Working With View Components In ASP.NET Core MVCNov 09, 2017. View component is newly introduced feature in asp.net core MVC. It is very similar to partial view but it very powerful compared to partial view. It does not use model binding but works only with the data we provide when calling into it.
  • How To Create Logic App From Template In AzureNov 09, 2017. Azure Logic Apps is a fully managed integration Platform as a service which provide a way to automate the workflows and business processes. You could easily integrate across different services in cloud and on-premise through connectors. In this article you will see how to create logic app from template which will create a new item in SharePoint Online list when a new tweet appears with text as “SharePoint”, #SharePoint, O365 or Azure.
  • How To Bind Data To Controls Inside Bootstrap Popup Using ASP.NET WebServicesNov 09, 2017. This article describes how to bind controls inside bootstrap popup using webservices in asp.net
  • Azure Data Factory - ETL Solution To Azure DB And To Azure SQL Data WarehouseNov 09, 2017. In this article we will learn how to use Azure Data Factory to Extract, Transform, Load (ETL) data especially for the data warehousing purposes.
  • Retrieve SharePoint Lookup Field Value Via C#Nov 07, 2017. Get and set a SharePoint Lookup Field via SSOM C#. In this article, I have explained how to get & set SharePoint lookup field (single/multiple) values programmatically via Server Side Object Model in C#.
  • How To Create A Blank Logic App In AzureNov 07, 2017. Azure Logic Apps is a fully managed integration platform as a service which provides a way to automate the workflows and business processes. You could easily integrate across different services in the cloud and on-premise through connectors. In this article you will see how to create a blank logic app which will send an email to a Gmail account when a new tweet is posted with the text “SharePoint” or #SharePoint.
  • Find The Installed SharePoint 2016 Edition Via C#Nov 06, 2017. Have you ever tried to detect the SharePoint Edition via C#? Regardless of the answer, detecting the SharePoint Edition via C# is not just a line of code as Build Number, to detect the SharePoint 2016 Edition, it will need to know the corresponding SKU.
  • Power BI And Excel File As Data SourceNov 06, 2017. Though we have several options for data sources to connect with Power BI in this blog, I am going to write about how we can use Excel data with Power BI and how to refresh the report when Excel data is changed.
  • Power BI On-Premises Server Installation And ConfigurationNov 06, 2017. On October 31, 2017 Microsoft released the latest version of Power BI report server, in this version on-premises reports can connect to different data sources (SQL Server, Oracle, SAP HANA ...Etc.). Users can also use direct Query option or import data option and create schedule to refresh the imported data. This article will give the step by step process to install and configure a Power BI on premises server.
  • If The Boot Configuration Data For Your PC Is Missing Or Contains ErrorsNov 06, 2017. The Boot Configuration Data (BCD) is a firmware-independent database for boot-time configuration data. It is used as new Windows Boot Manager. It replaces the "boot.ini" file that was used in the old Operating System. For more details check Windows startup process.
  • Retrieve User Profile Properties Using SPFx And PnP JS In SharePoint OnlineNov 05, 2017. SharePoint Framework is the new development model in which a lot of work has been going on since it went to General Availability on Feb 23, 2017. It is a page and web part model that provides full support for client-side SharePoint development, easy integration with SharePoint data and support for open source tooling. With the SharePoint Framework, you can use modern web technologies and tools in your preferred development environment to build productive experiences and apps in SharePoint.
  • How To Create A SQL Database In AzureNov 03, 2017. In this article you will see how to create an Azure SQL Database in the Azure portal. Azure SQL Database is a relational database-as-a-service which provides high performance, reliable and secure database used to build data-driven applications and websites.
  • Implementation Of Stack And Queue Using Linked ListNov 02, 2017. In this article, I will be discussing two data structures - Stack and Queue and their implementation using another data structure - Linked List.
  • Introduction To ASP.NET MVC Model BindingNov 02, 2017. Asp.NET MVC model binder allow you to map http request data with model. HttpRequest data means when user makes a request with form data from browser to controller at that time model binder works as middle man to map the incoming http request with controller action method.
  • How To Move Site Or Subsite To Another Site Or Subsite In SharePoint OnlineNov 01, 2017. Sometimes, there is a situation in which we need to move one subsite to another subsite. We can move one subsite to another subsite using Site Manager in sharePoint Online.Here I explained all the steps in detail.
  • Create Charts In PowerPoint Using C#Oct 31, 2017. When it comes to PowerPoint presentation, charts are an import thing. Because charts can visualize large amount of complex data, which is helpful for data comparison and analysis. This article focuses on how to create most commonly used chart types (including column chart, pie chart and combination chart) by using .NET Presentation library in your C# applications.
  • Posting SharePoint Items As Conversations In Microsoft TeamsOct 31, 2017. Here, let us see how to push the items from SharePoint into the Microsoft Teams Channels as conversations using Microsoft Flows.
  • Performance - SortedDictionary Vs DictionaryOct 31, 2017. Recently when I was analyzing a clients code base for performance, I found that they were using the collection SortedDictionary in many places in their projects. After looking on how they are using this collection type, I discovered that they really only needed the collection sorted once. So I figured, that if would be better performance to use just Dictionary and sort it once. Before recommending this change to their code, I needed to prove my theory.
  • Populating A ListView With Data Using Kendo Listview And Entity Framework In ASP.NET MVC 5Oct 31, 2017. Here, I am going to demonstrate how to load the data from a database to Kendo listview in ASP.Net MVC5.
  • How To Use ServerSide Processing With jQuery DatatableOct 29, 2017. Create one WebService to Getdata(Here I am using asp.net WebService to get data). You can see my Solution Explorer . I have two web pages and one service, and the name of the service is webService.asmx.
  • Useful URL Shortcuts For SharePoint Online - Part TwoOct 29, 2017. In this second part of URL shortcuts, I am going to write some useful URLs which will help developers or administrators perform their daily tasks in a very easy manner. As a developer these shortcuts are very useful to us. These URL shortcuts make our work faster. This article covers eight shortcut URL which we can use in our daily practice.
  • Office 365 Public CDN OverviewOct 27, 2017. Microsoft has recently announced (over a months’ time ago now as I am writing this article) availability of Office 365 Public Content Delivery Network (CDN). This gives us the good option to host the static content such as JavaScript files, CSS, images, documents in CDN. The files in CDN will help better performance with SharePoint pages.
  • One-Way And Two-Way Data Binding With Examples In AngularOct 27, 2017. In Angular 2, Data Binding is mainly classified in two ways, namely One-Way binding (i.e. unidirectional binding) and two-way binding (i.e. bi-directional binding).
  • Read Outlook Emails And Add Email Content In SharePoint ListOct 26, 2017. In this article, we will explore how to read an email in Outlook and add the content of the email body into SharePoint List.
  • Useful URL Shortcuts For SharePoint Online - Part OneOct 26, 2017. In this article, I am going to write some useful URLs which will help developers or administrators perform their daily tasks in a very easy manner.
  • How To Do 'LinkedIn Connection Analytics' Using Power BI Oct 26, 2017. Learn to use new free 'LinkedIn Connection Analytics' dashboard with Power BI.
  • Generate PDF From An HTML Page Using AngularOct 24, 2017. In this article, I am going to explain how to generate PDF file from an HTML page using AngularJS in SharePoint. This is the effortless way to port the SharePoint list data or any other list data to carry, print, and make a hard copy.
  • Amazing Modern SharePoint Admin Center To Try Right NowOct 24, 2017. You’ll learn updated features to the SharePoint Modern admin center in office 365 and how we can navigate from the old admin center.
  • How To Use jQuery Datatable In AngularOct 24, 2017. In this article I am going to explain how to use and integrate the jQuery datatable with AngularJS. DataTables is a prebuild functionality and a plug-in for the jQuery JavaScript library. It is a highly flexible tool, based upon the foundations of progressive enhancement, and will add advanced interaction controls to any HTML table.
  • Missing 'Manage Delegates' Option In PWA Setting In Project Server 2016Oct 23, 2017. In this article, we will be fixing the issue Missing 'Manage Delegates' option in PWA Setting.
  • Basic Introduction To Power BIOct 17, 2017. In this article I will discuss the fundamental concepts of Power BI. So this article will cover basic knowledge on power BI, the need of power BI, the importance of data visualizations, the components of Power BI, the architecture of Power BI, the building blocks of Power BI & the cost of power BI tools.
  • Running Business Rule Only On Record CreateOct 16, 2017. We know that business rules are executed on form load and on change of the associated field, which means if we have business rule for any entity it will fire for new record as well for existing records when form loads.
  • Missing Office / SharePoint Template In Visual Studio 2017Oct 16, 2017. In this article, we will explain how to install Office Developer Tools to create Office / SharePoint projects in Visual Studio 2017.
  • Power BI - Get Data From SharePoint List / LibraryOct 16, 2017. In this article, we will explore two methods to get data from SharePoint List / Library in Power BI.
  • Different Operation On SharePoint People PickerOct 14, 2017. I developed this POC, which often proves helpful to deal with investigating user properties
  • Generate A Nice UI For SharePoint List Using AngularOct 14, 2017. This article helps you to generate an automatic UI page according to your SharePoint list using angular and jQuery. Also, you can customize your UI color by giving an input with a specified color.
  • 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.
  • SharePoint 2016 - February 2017 CU Issue FixedOct 13, 2017. In this article, we will list all the issues of SharePoint 2016 that are fixed in the February 2017 CU.

About health-data-collection-SharePoint-2013

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!