C# Corner

Resources  
  • Writing A Sensor Value In The SD Card Using ArduinoApr 07, 2018. In this article, we are going to see how to write ultrasonic sensor values in the SD card using SD Card module. This is applicable to every SD card.
  • Difference Between Value Type Variables And Reference Type VariablesApr 03, 2018. Before we get started between the difference of value type variables and reference type variables, we need to understand the concept of stack and heap. So let’s get started with stack and heap.
  • Angular - Creating Custom Pipe(|)Mar 28, 2018. As we already know that Pipes (|) in Angular are used to transform the data before displaying in a browser. So in this article, my requirement is to filter the student record based on the value i.e. Name of the student entered in the search textbox given at the top.
  • Android Kotlin - Classes And Objects - Part FourMar 21, 2018. In this article, we are going to learn about classes and objects in Kotlin with null values.
  • Use INotifyPropertyChanged Interface In WPF MVVMMar 20, 2018. INotifyPropertyChanged is an interface member in System.ComponentModel Namespace. This interface is used to notify the Control that property value has changed.
  • CSS Class Binding In Angular 5Mar 19, 2018. We use css classes to give a good look and feel to our applications. It is very important to add or remove css classes on runtime to maintain a high user experience in the application. It is a very common thing for any front end developer to do so in JavaScript or Jquery.
  • Removing Item Permission Using SharePoint Workflow And REST APIMar 10, 2018. In this article I have explained about how we break item permission inheritance.
  • Working With Arrays In JavaScriptMar 09, 2018. Arrays are the collection of same data-types values or a collection of data items. In memory variable, we can store one value at a time but in arrays, we can store many values and retrieve as per index number of stored values.
  • Export Only SharePoint Filtered List Items To Excel Mar 09, 2018. This article demonstrates how to export to Excel SharePoint Filtered list items.
  • Get HTML Tag Values With JavaScriptFeb 20, 2018. In this article, you will learn how JavaScript interacts with HTML.
  • Import And Export Data Using EPPlus.CoreFeb 19, 2018. In this post, we will see how we can import and export excel data in Asp.net Core. We are using EPPlus.Core library which helps us to perform import and export operations. I hope you will like it.
  • How To Manage Externally Shared Contents In SharePoint OnlineFeb 18, 2018. Anonymous access to the SharePoint Online site has been removed for more than a year. Instead, Microsoft allows us to share the files or folders from SharePoint Online to external users. This configuration can be done in the Office 365 admin portal and SharePoint Online to enable or disable sharing.
  • Stack, Heap, Value Type, And Reference Type In C#Feb 13, 2018. Now, let’s see what happens when we declare any variable like int a=10 in C#. When C# compiler will run, it will allocate a block of memory which will have name of variable i.e. a, its type i.e. int and its value i.e. 10. Now this memory can be of type Stack or Heap i.e. variable gets store in Stack or Heap.
  • Automating SVN Check-Ins And Building A Project Via JenkinsFeb 05, 2018. A few weeks back, while sitting with my team, I learned that they run a Jenkins job which has to execute the automation scripts using the robot framework, daily around 1:00 a.m. The primary purpose of the job is to place all the necessary files and folders over the node machine of Jenkins (after copying them from the machine pointed as master on Jenkins), execute those scripts accordingly, generate the reports, and finally copy the output files back to the master machine to analyze the logs for the overall reporting and analysis purposes. This whole efficient job starts with a slack manual step which was enough to tag this activity 'not fully automated' because they had to place the updated work regularly on the specified path over the master machine before leaving the office (this includes taking the updated code, files, and automation scripts, building the project to take the DLLs etc.). This may sound tedious but more than that, there is no sense to do it manually.
  • Object In JavaScript With Function, Constructor, Function Constructor And Function HoistingFeb 04, 2018. In Javascript everything is Object, except for primitive values. In Javascript we can create an Object Wrapper through Object constructor. Whatever value we give or assign to variable the Object constructor creates an Object wrapper for that.
  • Implementing Duplicate Detection Using KeysFeb 04, 2018. Dynamics CRM contains a duplicate detection feature that can be enabled for multiple operations; for example, we can see different options under duplicate detection settings.
  • Dynamic Web View Of A SharePoint List Item Using Excel Web Access Web PartFeb 03, 2018. Sometimes, the customer would like to see the SharePoint list item with a specific design instead of default view for which the developer develops an app or web part to achieve it.
  • Variable In DAX, Keep Rows And Remove Rows In Power BIFeb 02, 2018. In this article, we shall learn about implementing variables in a DAX query. We shall also learn what Keep Rows and Remove Rows are in Power BI.
  • CRUD In Excel File In C#Feb 02, 2018. In this article, I am going to explain how we can CREATE, UPDATE, DELETE and READ the records in Excel files.
  • Linq To Excel In ActionJan 29, 2018. In this post, we will demonstrate how we use LinqToExcel library to query data from Excel.
  • Adding/ Removing Users To Enterprise Applications In Azure Active DirectoryJan 29, 2018. In this article we will be looking into adding new users to Azure active directory and providing access to your enterprise applications without giving them access to your application's dedicated login information.
  • How To Add Excel Add-In For GeoCoding (Batch GeoCoding)Jan 27, 2018. This simple tutorial is about adding MS Excel Add-in and getting the geocodes, i.e., Location Points (Latitude, Longitude) or to verify the accuracy of address, using three Service Providers
  • SharePoint Online Automation - Increase SharePoint Storage Quota In SharePoint Online Using PowerShellJan 24, 2018. As we know when a site collection is created in SharePoint online, we must specify a storage quota. This site size value must be between 100 MB and 100 GB. We will discuss more about site collection quota and usage in the next article.
  • View Customization With JavaScript In Dynamics 365Jan 24, 2018. You need to write a JS function with 2 parameters, when you’ll add it to view, first parameters will recieve rowData(value with metadata shown below for one cell) and userLCID(i.e. language code fof current user). Based on those 2 inputs you can decide what icon to show. And name of this function goes in Function Name: field in View’s property.
  • Converting SQLite Database To Excel And Excel To SQLite Data In AndroidJan 23, 2018. In this article, we will learn how to export Android SQLite Database to Excel or Import Excel into SQLite Database. We can use SQLiteToExcel library to perform these functionalities.
  • JavaScript Powerful Property DescriptorsJan 21, 2018. We developers assume that an object’s property is only a container that can be assigned a name and a value. In actuality though, JavaScript gives us a series of powerful property descriptors that further shape how the property behaves. To demonstrate this, let's create a JavaScript object by using object literal.
  • 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!)
  • Segmented Control In Xamarin.iOSJan 16, 2018. In this article, we are going to create a Xamarin iOS application that contains UI Segmented control that let the user select the value between the certain range of values. We will create a simple application that contains the set of values and a user can select values among the available values.
  • Conditional Column, Index Column And Duplicate Column In Power BIJan 12, 2018. This article defines the query editor add column option of conditional, index and duplicate column in Power BI.
  • 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.
  • Microsoft Office 2013 UI Design In C# - Visual StudioJan 07, 2018. In this article we will design the UI of Microsoft Office 2013 applications like Word, PowerPoint, Excel etc.
  • ASP.NET Core 2.0 Cookie AuthenticationJan 02, 2018. Cookie Authentication allows developers to hook into events at various lifecycle stages of the authentication process. For instance you could log successful sign-ins using OnSignedIn or use OnValidatePrincipal (runs on every request) to invalidate the user (e.g. if you want to force sign-out).
  • 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.
  • 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.
  • 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.
  • 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.
  • Directives In Angular 5 - Part Two (Structural Directives)Dec 15, 2017. These are responsible for the HTML layout they shape or reshape the html element by simply adding or removing the elements in the DOM. These directives are the ways to handle how the component or the element renders in the template .
  • 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.
  • 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.
  • Functions In KotlinDec 01, 2017. Function is a set of code which may take some parameters, perform an operation on it, and then may return a value.
  • 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.
  • 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.
  • Implement DropDown MultiSelect Using Kendo UI MultiSelect In ASP.NET MVC5Nov 21, 2017. In this article, I am going to explain how to bind the value to a dropdown from the database, how to implement drop-down multi-select, how to group the drop-down values, and how to implement Custom Template using Kendo UI MultiSelect in ASP.Net MVC5.
  • 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) .
  • Introducing Visual Studio Live ShareNov 18, 2017. With Visual Studio Live Share you and your teammates use the same debugging session. You can collaboratively step through code or set breakpoints which are reflected in your teammate’s editor in real time. Each of you can independently inspect objects, use features like tips on hover, locals and watches, or make changes to an object’s value. When you are ready to make a fix, simply edit the code and your teammates will see your edits in their editor.
  • How to Return Files From Web APINov 18, 2017. This article explains how to transfer/ return files(PDF/Doc/Excel/zip) files from Web API service
  • 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.
  • Different Ways Of Binding Razor DropdownList In ASP.NET MVC 5Nov 13, 2017. This article will demonstrate how to bind the values to Razor DropDownList in various ways using ASP.NET MVC5
  • Enums In C#Nov 09, 2017. Suppose we are creating a program in which we have to use multiple named constants of similar type and on the basis of a particular constant we have to perform some operation. So what we normally do is initialize each named constant with a value. This may require a lot of effort if the number of constants is large. Also the look and feel of the code is not up to the mark. Have a look at the below program to understand more. The program contains months of the year. We have to put lots of effort to assign each month to a value.
  • 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#.
  • 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.
  • Get Master Page Control Value In Content PageNov 05, 2017. Asp.Net Master page helps us to create a consistent view for the pages. Master page behaves like a container and parent page of Content page. In your application you can add numbers of Master page depending upon your project requirement and layout.
  • Binding DropDown List Using Tuple In ASP MVCNov 05, 2017. Tuple is a generic static class that was added to C# 4.0 and it can hold any amount of elements, and they can be any type we want. So using tuple, we can return multiple values.One great use of tuple might be returning multiple values from a method. It provides an alternative to "ref" or "out" if you have a method that needs to return multiple new objects as part of its response.
  • How To Connect The Outlook Mail To Excel With Microsoft FlowOct 31, 2017. This article helps you to learn how to create a Flow between the Outlook Mail and Excel Spreadsheet.
  • Getting Started With Azure Cosmos DBOct 29, 2017. Azure Cosmos DB is a globally distributed database service designed to enable you to elastically and independently scale throughput and storage across any number of geographical regions with a comprehensive SLA. You can develop document, key/value, or graph databases with Cosmos DB using a series of popular APIs and programming models.
  • How To Read CSV File In ASP.NET With Example C# and VB.NETOct 26, 2017. In this articleI'll explain a way to upload, read/browse and show CSV file (Text File) information in ASP.Net GridView using C# and VB.Net.
  • Debugging Tips - Part OneOct 24, 2017. A cool attribute to save some debugging time is DebuggerTypeProxy (Namespace: System.Diagnostics). Using this attribute, you can write your own logic to interpret the object at debug time. Meaning, if you have a list of class objects then you can project on certain properties and force debugger to show the value off of this proxy class. This attribute is applicable to Structures, Classes and Assemblies.
  • Re-adding Accidentally-Deleted Status Reason Option- Quick TipOct 22, 2017. Have you been in a situation where you accidentally deleted status reason option from quote entity and now want to add it back as soon as possible?? If yes, then this article is going to help you.
  • Read Excel File In C# WinFormOct 13, 2017. Here we are going to learn to read Excel files in C# windows form applications.
  • Getting Started With SharePoint Framework For SharePoint 2016 On-PremisesOct 12, 2017. Once you have installed and upgraded the September 2017 Public Update for SharePoint 2016, you will be able to upload and deploy SharePoint Framework packages that contain web parts via the SharePoint App Catalog just as you would with SharePoint Add-ins.
  • Excel To XML Using LINQOct 11, 2017. In this article we will show you the easiest way to convert Excel data into Xml files. There is a certain way to convert Excel file to Xml, for example using Excel Library (Com Component)
  • Sending Bot Reply Message With Attachment Using Bot FrameworkOct 07, 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, the message with an attachment like the image, File (pdf, word, excel, ppt), mp3, Video or more complex rich cards.
  • Read Data From Excel With Preview In ASP.NET MVC Using AngularOct 03, 2017. In this article we will see how to Read data from excel and show preview and after we can update to database with Asp.net Mvc using Angular.
  • TextBox Validation Client Side And Server Side In ASP.NET WebFormOct 03, 2017. Validation is main thing to process the data. We store the textbox value into database table. Before moving to storing and storing data into database first we check the value of each textbox.
  • Create Value Object In C#Sep 28, 2017. Create a class that abstracts away (encapsulate) ‘data’ in your domain and provide methods to work on it. Below is a class I don’t consider a good Value Object.
  • Default(T) In GenericsSep 27, 2017. Default represents default value of T parameter in generics intructions. In several cases, the default keyword is an absolute unknown and we think it’s unnecessary or its functionality is null. There are many development moments with the generics classes where the default keyword can be useful.
  • XAML Value Converter With A Simple ExampleSep 27, 2017. In this article, I'm going to show you how you can use value converter in XAML to convert one format of data into another format. In our case, we'll convert a string value (value in the textbox) to a Boolean value (checked status of a checkbox).
  • Stored Procedure With Input And Output Parameter Using Entity Framework In ASP.NET MVCSep 23, 2017. In this article, we are going to learn how to get list and output value from a stored procedure using Entity Framework in ASP.NET MVC.
  • Edit Or Remove Permission From Existing Data Source Connection From Power BISep 23, 2017. In this article, we will learn how we can remove our existing data source connection from Power BI Desktop.
  • How To Create To-Do CRUD Operation With ASP.NET MVC Core, Angular 4.0Sep 21, 2017. We want to create below single page application with CRUD operation, Add, Update and Remove functionality with in-memory TodoRepository Database.
  • Learn Universal Windows Programming Via Modern C++ (Check Box)Sep 19, 2017. In the button control, we are using the IInspectable to set the content of the text. How do we get the value from the IInspectable interface ? By IPropertyValue; using the “as” operator, we can convert from IInspectable to IPropertyValue.
  • Get Office 365 Data In Excel Using MS Graph APISep 08, 2017. In this article, I will show how you can quickly fetch Office 365 data of your organization in MS Excel using Microsoft Graph API.
  • JasperReports - Basic IntroductionAug 26, 2017. JasperReports is an open source software which is widely used for creating PDFs. It is not limited to creating PDFs but one can also export any desirable formats such PNG, CSV, Excel, Word doc, and HTML etc.
  • Create Office Web Add-In Project Using Visual StudioAug 24, 2017. In this article, I would like to share the steps to create Office web add-in projects using Visual Studio. In this article, we have explored what Office add-ins are and how to create Office web add-in projects using Visual Studio 2015.
  • Dynamic Menu Using Entity Framework And AngularJS In ASP.NET MVC Aug 23, 2017. The logic behind this is all main menus should have parentid = 0 and whatever ID column value of Main menu that ID value should be mentioned in parentid column of sub menu. Then the sub menu will appear for corresponding Main Menu.
  • Remove U+200B (Zero-Width Space) In RichTextHTML Field SharePointAug 22, 2017. In this article, we will explore how to resolve the error that arrives while implementing the validation to enhanced/rich text box of SharePoint 2013 using jQuery. We will call this error the “Zero-width space” issue.
  • Normal Equation Implementation From Scratch In PythonAug 19, 2017. Normal equation is a more closed-form solution of figuring out the value of a parameter that minimizes the cost function. It's called closed-form solution in the sense that it gives the result directly though the equation.
  • Reading An Excel File Using HTML 5 And jQueryAug 18, 2017. This article explains how to export data from an Excel file to an HTML table using jQuery & HTML5.
  • Swift Programming - Zero To Hero - Part ThreeAug 17, 2017. Statements are the building blocks of any program. We can perform any function with the help of statements, such as checking values or declaring variables, calling methods, or even creating objects.
  • The Value Of Coaching And The Dangers Of TellingAug 15, 2017. I have led many global training sessions on leadership and coaching. I typically start by asking, “what is coaching?”. The responses of most people gravitate towards an answer consisting of making people better in some way. If you look up the word “coach” in the dictionary the first definition is “a large usually closed four-wheeled horse-drawn carriage having doors in the sides and an elevated seat in front for the driver”. People equate coaching to “moving forward” or “getting someone from point A to point B”.
  • Export To Excel And PDF In Kendo Grid For AngularAug 06, 2017. From this article you will learn how to perform export to excel and PDF in kendo grid for Angular 2
  • Implementing Equality In Value TypeAug 02, 2017. This post is to focus on implementing Equality in Value Types; i.e., overriding Equality behavior for our own implemented Value Types which is basically defining how to decide two object of a type are equal or not.
  • DataTable In Xamarin iOSJul 27, 2017. In this article, you will learn how to Store Values Using DataTable in Xamarin iOS, using Xamarin Studio.
  • Extracting Data From Large Spreadsheets Using Python And OpenpyxlJul 26, 2017. At least once in life, every computer user has to handle some spreadsheets or, excel files. Sometimes it's to put formulas in for accounting, sometimes it's to store data from Google forms or other surveys. So what do you actually do when the spreadsheet contains just survey data or no numbers to apply formulas at all? I know you'll get your hands dirty and do it manually.
  • Custom Actions Using CSOM For SharePoint OnlineJul 18, 2017. In this post, we will see how to add and remove Menu(ECB) and Ribbon custom actions to different types of lists (Custom List, Document Library and Calendar) in SharePoint online using CSOM (.NET managed) code.
  • Arithmetic Operation In ASP.NET MVCJul 16, 2017. In action result method I passed one string parameter named command and using this command I assigned some arithmetic operation string value and based on that the operation will be performed.
  • Commands For "Add", "Install", "Update" The Solutions For SharePoint SiteJul 13, 2017. In this article, I would like to share the steps and commands for how to Add, Install and Update, Uninstall and Remove the solutions (WSP Package) in SharePoint server.
  • How To Upload Records From Excel File to Database Using Stored Procedure In MVCJul 10, 2017. In this article, I will explain how to upload records from Excel files in the database using store procedure and also how to check all types of validation.
  • Update Entity Form JS Library Without Removing Event Handlers - Quick WorkaroundJul 06, 2017. Let’s say we have one entity with a good amount of custom fields and we have developed a web resource for the main form. Many of the fields have onchange event associated with them. Now we have a new requirement where we need to implement a similar kind of form with some new functionality for different types of users and some of the existing methods also need to be modified. The requirement is to replace new form JS library with updated new JS library but without removing dependent handlers (as we are using many onchange event handlers as it is) with minimum effort.
  • How To Download SQL Records In Excel Format Using MVCJul 02, 2017. I will explain how to download records in Excel format from database.
  • Export GridView In Excel And PDF Using Stored Procedure In ASP.NET In Real-TimeJun 28, 2017. This article will show you how to export GridView records using Excel and PDF.
  • JavaScript For Querying An Entity And Updating Attribute Values In FormJun 20, 2017. In this article, you will learn about JavaScript for querying an Entity and updating attribute values in form.
  • Get selected row column values in AngularJS-UI-Grid in MVCJun 12, 2017. In this article, you will learn how to get the selected row column values from angularjs-ui-grid using Web API and MVC.
  • Filtering In UI-Grid With AngularJS And WebAPIMay 22, 2017. In this article, you will learn how to filter a UI-Grid data based on the columns and the given values.
  • Add Excel Web Access Webpart In SharePoint SiteMay 19, 2017. Add Excel Web Access Webpart In SharePoint Site.
  • Dynamics CRM - Passing Dynamic Value As Parameter To Web Resource From Entity FormMay 19, 2017. This article describes about passing the dynamic values to the Web resource function as a parameter.
  • Most Valued ProfessionalMay 15, 2017. This article presents my thoughts on getting MVP for the third time.
  • Add, Replace And Remove Bookmarks In Word Using C#May 08, 2017. In this article, you will learn how to add, replace and remove bookmarks in Word, using C#.

About remove-duplicate-values-in-excel

NA
Hire a remote developer
Looking to add more bandwidth to your software team? Web Developers, designers, testers are now available on demand. Flexible hours, very competitive rates, expert team and High Quality work.
X

Build smarter apps with Machine Learning, Bots, Cognitive Services - Start free.

Start Learning Now