C# Corner

Resources  
  • SharePoint Online/2016/2013 - How To Upload Large Files Using PowerShell AutomationJan 22, 2018. Uploading large files to SharePoint On-Premise or Online is an obvious problem during data migration from any external system like Lotus Notes.In this article I will explain a data upload strategy where we can split a large file into multiple chunks of smaller size.
  • SharePoint 2016 June 2017 CUJan 21, 2018. In this article, we will list all the issues which are fixed in this June 2017 CU. MSFT released two versions of it, one includes the Fixes for LPs and others don’t include the Fix for LPs. Now it is irrelevant what language pack you installed or what the base language of the SharePoint is. You just simply install both exes and it will take care of everything.
  • SharePoint 2016 May 2017 CUJan 20, 2018. In this article, we will list all the Issues, which are fixed in this May 2017 CU. This Month MSFT released two versions of it, one includes the Fixes for LPs and others don’t include the Fix for LPs. Now it is irrelevant that what language pack you installed or what base language of the SharePoint. You just simply install both exe and it will take care of everything.
  • SharePoint 2016 April 2017 CUJan 20, 2018. In this article, we will list all the Issues, which are fixed in this April's 2017 CU. This Month MSFT released two versions of it, one includes the Fixes for LPs and others don’t include the Fix for LPs. Now it is irrelevant what language pack you installed or what the base language of the SharePoint is. You just simply install both exes and it will take care of everything.
  • CRUD Operations In SharePoint Using REST API - READ OperationsJan 19, 2018. In the previous blog, we had a look at the “Create” operations in this series of CRUD Operations in SharePoint using REST API. In this blog, we will have a look at the “Read” operations.
  • Publish Nuget Packages In .NET CoreJan 19, 2018. Now that you have a registry and key to upload your packages, let’s create and push a package. I am using here a simple .NET Core class library I wrote to work with CSV files, the source code can be found on GitHub. You can of course use any of your projects.
  • Delete The Locked Documents From SharePointJan 18, 2018. This blog will help you to understand the record declaration functionality in SharePoint Online.
  • CRUD Operations In SharePoint Using REST API - CREATE OperationsJan 18, 2018. REST API is a powerful CSOM concept that can be leveraged in SharePoint for converting sophisticated business designs into working and efficient SharePoint Artifacts (Add-Ins, CSOM solutions, etc.). REST does not require any separate references for its working unlike other frameworks (SPservices!)
  • SharePoint Online Automation - Email Notification Using PowerShell Script In SharePoint OnlineJan 18, 2018. In this article, we will learn how to send email notification using PowerShell in SharePoint Online
  • 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.
  • SharePoint Online Automation - Checking Site Quota For SharePoint Online TenantJan 16, 2018. Today, I am writing about SharePoint Online Automation script for checking the site quota.
  • Identity Server 4 With ASP.NET Core 2.0Jan 16, 2018. OAuth 2 provides several flows or grant types for various use cases. I personally group them into two categories; flows that require user interaction with authorization server and flows that don’t.
  • SharePoint Online Search Results - Sort By TileJan 16, 2018. Search is more commonly used to display the results in SharePoint Portal based on the business needs by configuring the search query. To make more sense out of the search results, they are commonly sorted on key attributes like Modified Date, Created Date, Title, etc.
  • How To Create A Site Collection in SharePoint OnlineJan 15, 2018. A site collection is the group of websites under a common top-level site with the same owner on the site administrator. To create a site collection for deleting a site collection in Office 365 is easy to do.
  • Why Dynamic Query Is BadJan 15, 2018. In this article, we will be talking about Dynamic Query and why it is bad.
  • Comparison Of Subquery And JoinsJan 15, 2018. Here, in this article, we are comparing the SQL Join and SQL Subquery.
  • Add Quick Launch Link To SharePoint 2013 Site Using REST APIJan 15, 2018. In this article, I have explored how to add links represented as headings in the Quick Launch area of the user interface using REST API. Here, we trying to add a custom navigation node corresponding to links in the Quick Launch area of the site using REST API using jQuery.
  • Bulletproof Disposable Types In .NET CoreJan 14, 2018. Whenever I do code review on .NET projects, hands down the number one issue is developers not calling .Dispose() on disposable objects. Ever since .NET was released, I have been preaching how important this is. If not done properly, it’s most likely to create virtual memory issues that will eventually cause the application to stop and possibly freeze server or users’ computer.
  • Create Site Collection In SharePoint Online Using PowerShellJan 13, 2018. In my last article, I have demonstrated about how to create Site Collection in SharePoint Online Using GUI, today I am demonstrating “Create Site Collection in SharePoint Online Using PowerShell”.
  • 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.
  • Co-Authoring In SharePoint And Why Check Out A Document Is Necessary In SharePointJan 10, 2018. In this article, I will discuss co-authoring in SharePoint & why we need to check out a document in SharePoint. SharePoint is the platform where multiple users can work on the same document at the same time.Co-authoring in SharePoint helps multiple users to access a document or edit a document simultaneously.
  • How To Customize Your Own Login Page Or Do Branding Of A Page In Office 365 OnlineJan 10, 2018. In SharePoint online, you can customize your own custom login page for branding.
  • How To Take Screenshot Using jQuery And PHPJan 10, 2018. Hello all, today in this article we will learn how to take screenshots using jquery and php. So, basically we will create a webpage and in the webpage we create a button which will take screenshot using the help of library called html2canvas . So once we take the screenshot we will save the screenshot in a json file using the help of jquery, javascript and php. We will be using for jquery and javascript to handel client side request and php to handel server side request. We will also learn about file handling using php.
  • How To Configure User Profile Service Application Step By StepJan 10, 2018. In the last article I described about how to delete and create User profile service, today I'm demonstrating about how to configure UPA service application step by step with a screen shot. This articles applies to SharePoint 2010, 2013 and 2016.
  • How To Remove And Create User Profile Service Application In SharePointJan 09, 2018. The purpose of this article to is to delete an existing UPA service from the SP server and create the same from scratch. As we know, there are two ways to configure or delete UPA server, Using UI and SharePoint PowerShell. We are going to delete and create UPA using UI.
  • Deploy SharePoint Remote Event Receiver To Microsoft AzureJan 08, 2018. This article will help even a beginner to deploy a SharePoint Remote Event Receiver easily to Microsoft Azure.
  • Ignite UI Data Grid In SharePoint Online Using AJAX - Part OneJan 08, 2018. How to use UI Data Grid in SharePoint Online using AJAX.
  • Say Hello To Swift GenericJan 08, 2018. If you have not been introduced to Swift generic yet, then definitely you are missing one of the most beautiful things. In this article, we will try to understand generic in a simple way and we will see how we can beautify our Swift codes with generics.
  • 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.
  • Office 365 Modern App DevelopmentJan 06, 2018. Web standard Apps are built using industry proven web Standards such as HTML, JavaScript and REST. Apps are independently scalable which reduces the total cost of ownership. Apps are secured and isolated from SharePoint. These apps can be accessed from any device with a browser.
  • 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.
  • Stop The Inherit Permission For List In SharePoint OnlineJan 04, 2018. In this article, I would like to share the steps to stop the inherit permission for List from the top level site in SharePoint Online environment.
  • Ordering The Columns In SharePoint Online List FormsJan 04, 2018. In this article, I would like to share the steps to order the SharePoint list columns for list forms.
  • Various List Operations With SharePoint Online List View Threshold LimitJan 03, 2018. In this article, we will learn about how we can work with SharePoint Online List view threshold. A myth with SharePoint List view threshold is a storage limit with the number of records, but it is not correct. List view threshold displays the number of record limits in SharePoint views.
  • Ignore The List Or Library Items From SharePoint Search ResultsJan 03, 2018. In this article I would like to share the steps to ignore the particular list items or library items from SharePoint search results. Already we have seen how to create a new search result source in SharePoint online.
  • Office 365 - SharePoint Online - Site Collection AdministratorsJan 02, 2018. In this article, we will discuss the role of site collection administrators in SharePoint online sites.
  • Integrating SharePoint And OneDrive? Check This Post Out!Jan 02, 2018. We all are well aware of the fact that Microsoft has an extensive selection of cloud-based digital storage options. Microsoft SharePoint and Microsoft OneDrive are the two most popular terms buzzing across the globe. Recently, the tech Giant has encouraged its end users to combine OneDrive for business and SharePoint, and here’s why!
  • Host ASP.NET Core On Linux With JexusJan 02, 2018. In this article, you will learn a new and easy way to host your ASP.NET Core project on Linux with Jexus Web Server.
  • 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.
  • How To Create Own NPM Package And Publish ItDec 29, 2017. NPM (Node Package Manager) is a package manager for JAVASCRIPT (Node.js) , use of npm is to use already developed javascript module in your application. It contains command line client that interacts with remote registry where the actual package resides
  • Customize SharePoint List Forms Using PowerAppsDec 29, 2017. We are all aware Microsoft announced that there will be no new release for InfoPath and advised us to start using PowerApps instead of InfoPath. The long awaited feature to create custom SharePoint list forms with PowerApps has been released now. This only exists in the SharePoint Modern Experience, so you won’t get this in classic.
  • ASP.NET MVC 5 - Full Calendar jQuery PluginDec 27, 2017. This article is about using Full Calendar jQuery Plugin with ASP.NET MVC5 server side.
  • A Potentially Dangerous Request.form Value Was Detected From The ClientDec 26, 2017. This error can occur in any page, but mostly a client receives this error while entering a new or modified item / product in admin panel of any portal because in admin panel we mostly write html code to fill in blanks, and also to display the product feature in ordered or unordered list.
  • Setting Up Add-In Development Environment In SharePoint Server 2016Dec 26, 2017. In this article, I have explained how to configure Sharepoint add-ins development environment and create a simple hello world web part in s=Sharepoint server 2016 on-premises.
  • 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.
  • 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.
  • How To Trigger SharePoint 2013 Designer Workflow On A List Item By Calling REST API Using jQueryDec 23, 2017. In this article, we will learn how to trigger the Sharepoint 2013 Designer List Workflow on a list item using REST API and jQuery.
  • 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 Host ASP.NET Core Application on IIS ServerDec 21, 2017. In this article, you will learn how to host ASP.NET Core Application on IIS Server.
  • Some Useful JavaScript Methods, Variable And Objects In Sharepoint 2013Dec 21, 2017. In my previous blog, I explored _spPageContextInfo variable properties. This time, I am exploring some SharePoint-provided useful methods and objects in JavaScript.
  • 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.
  • SharePoint Status And SharePoint NotificationsDec 19, 2017. Whenever we need to notify a user about some field value or when we want to describe the current state of the form, we usually go ahead and use Alerts or Message box.
  • 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.
  • Understand HTTP.sys Web Server In ASP.NET CoreDec 19, 2017. HTTP.sys is a Windows-based web server for ASP.NET Core. It is an alternative to Kestrel server and it has some features that are not supported by Kestrel.
  • How To Create Azure Function App To Delete SharePoint Online List Using CSOMDec 19, 2017. Azure Functions are used for executing a small piece of code or “functions” in a cloud and you will pay only for the time your code executes. You can use development language of choice such as C#, F#, PHP, Java etc. Some of the key features of Functions are Choice of language, Pay-per-use pricing model, bring your own dependencies, integrated security, simplified integration, flexible development, and open-source. Please refer Azure Functions for more details.
  • Uploading Attachment To The New Item On List Using “REST API” jQueryDec 18, 2017. In the previous article, we have seen how to explore multiple attachments to the new item on a list using JSOM and REST API. In this article, we will see how we can upload the documents to SharePoint list items using REST API based approach.
  • 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.
  • When SharePoint 2013 Site With .Dev Extension Stops Working In ChromeDec 18, 2017. In this article, I’ll explain how our SharePoint 2013 site with extension “.dev” stopped working in CHROME browser
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • Creating Server And Host HTML Page Using Node.jsDec 07, 2017. Today my mission is to explain about creating server in Node JS and hosting html pages on this server and accessing it from web browser.
  • Object-Relational Mapper For SQLite3 In Node.jsDec 07, 2017. Node.js is getting more popular day by day and many frameworks and platforms are supporting Node.js for its high-performance web server development. In this post, you will learn the database development in Node.js with the popular ORM library; Sequelize.
  • 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.
  • 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 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
  • 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.
  • 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.
  • 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 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.
  • 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.
  • Tips And Best Practices To Improve ASP.NET Web Application PerformanceDec 01, 2017. This article suggests you a few tips to improve the performance of an ASP.Net application. There are many more things which may ensure a better performance and faster response time for a web application. I am discussing only a few of the best practices that will help you avoid some unwanted performance hitters from your application. So, you will have a more light weight application which runs quicker and gives a better response time.
  • 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.
  • Creating Custom Tag Helpers With ASP.NET Core MVCNov 29, 2017. The tag helper enables us to run server-side code to generate HTML, CSS, Javascript code in Razor view.
  • 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.
  • Getting Started With Kotlin - BasicsNov 29, 2017. Google announced Kotlin as an official language for Android Application development in Google I/O 2017.Kotlin is a statically-typed language, developed by JetBrains and Open source Contributors in the 2011, that runs on JVM(Java Virtual Machine) and is compiled to JavaScript source code. It is very suitable for server-side application development with full compatibility of Java frameworks. You can use multiple frameworks like - Spring, Vert.x, Ktor etc. for web application development.
  • 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.
  • 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.
  • 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.
  • 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
  • How To Build A Kubernetes Cluster On Azure Using KubesprayNov 26, 2017. The concept of sticking our compiled code into containers is becoming quite popular at the moment, and for very good reason. If you develop for the cloud, and don't use containers or similar technology now, then you should really take a look at whats involved. The huge benefits of using containerized infrastructure/deployment are being pushed by the cloud vendors, and also increasingly being recognized by mainstream enterprise as an all round good egg and something worth investing time and resources into embracing. Containers and 'server-less computing' are two technologies that most developers are going to have to embrace in the next short few years.
  • 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.
  • 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.
  • Introduction To Suave With F#Nov 23, 2017. In this article, we will see how to construct a simple web application with the F# language and the Suave web server on Visual Studio Code.
  • 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.
  • Use SQL Server 2017 in Docker ContainersNov 21, 2017. How to use SQL Server 2017 on Docker containers to automate deployment using VSTS
  • 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.
  • 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.
  • 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.
  • Dynamic Checkbox Functionality Using Angular In ASP.NET MVCNov 17, 2017. Checkboxes in AngularJS and asp.net MVC (server-side) application.
  • 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.
  • 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.

About SharePoint-Server-Publishing

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!