C# Corner

Resources  
  • Add/Remove User Control for C#Jan 18, 2000. A nice feature in the Visual.NET environment is the ability to create User Controls.
  • How to read a value from Console?Oct 07, 2000. This article explains how to get the input from the console using ReadLine.
  • Boxing and UnboxingFeb 21, 2001. Boxing and Unboxing are fairly new terms introduced in C#. Author explains some concept of them.
  • Using the out ParameterMar 07, 2001. Did you ever need your method return more than one value? The out keyword can be used to do the same.
  • Assemblies : The Ins and Out : Part IApr 13, 2001. In Part 1, I will cover what exactly an assembly is, and what an assembly contains.
  • Assemblies : The Ins and Out : Part IIApr 16, 2001. In this part, I will discuss both Private and Shared assemblies and how to create a "Shared Assembly".
  • Assemblies : The Ins and Out : Part IIIApr 20, 2001. In this part I will discuss in more detail than Part 2, the available utilities for manipulating assemblies.
  • Serializing Objects in C#May 14, 2001. In simple words serialization is a process of storing the object instance to a disk file. Serialization stores state of the object i.e. member variable values to disk. Deserialization is reverse of serialization.
  • cwTab - A Tab Control in C#May 18, 2001. cwTab is a control written in C# that gives you the ability to add Visual Studio.Net, Excel, and InterDev tabs to any application. The control is fully customizable.
  • Properties in C#: New Cover on old book Jun 06, 2001. Properties are accessor methods whose job is to retrieve and set the values of fields.
  • The out and ref Paramerter in C#Jun 12, 2001. The out and the ref parameters are used to return values in the same variables, that you pass an an argument of a method. These both parameters are very useful when your method needs to return more than one values.
  • What & Why : Properties :: Part 2Jul 09, 2001. In the part 1 of this series, I discussed about the get method of the properties, with the help of which you can make your variable so that nobody can modify the value of the variable.
  • Text Reader and Text Writer in C#Aug 03, 2001. A detailed tutorial and C# types such as Value and Reference types with sample examples.
  • NumberBox ASP.NET ControlAug 08, 2001. The NumberBox control is an ASP.NET control, which lets the user only input numerical values.
  • Boxing and Unboxing in C#Aug 20, 2001. Boxing and unboxing is a essential concept in C#'s type system. With Boxing and unboxing one can link between value-types and reference-types by allowing any value of a value-type to be converted to and from type object.
  • Validation Controls in Web Forms: Part IAug 24, 2001. Validation is one of the less talked about areas – often taken for granted.
  • Realtime Stock Quotes into Excel using .NETSep 03, 2001. I may seem a little Bullish on .NET, but I was able to create this application fairly quickly in C#.
  • Is there any need to Boxing and UnboxingSep 21, 2001. With Boxing and unboxing one can link between value-types and reference-types by allowing any value of a value-type to be converted to and from type object. Boxing and unboxing enables a unified view of the type system wherein a value of any type can ultimately be treated as an object.
  • Method Parameters in C#Oct 15, 2001. This article describes different method parameters such as value parameters, reference parameters, output parameters, and parameter arrays.
  • Pointers in C#Oct 25, 2001. C# also supports pointers in a limited extent. A pointer is nothing but a variable that holds the memory address of another type. But in C# pointer can only be declared to hold the memory address of value types and arrays.
  • Enumerators in C#Oct 25, 2001. An enumeration (enum) is a special form of value type, which inherits from System.Enum and supplies alternate names for the values of an underlying primitive type.
  • Charting in GDI+Nov 07, 2001. Here is an example of creating simple charts using GDI+ commands in C#. I have used the random class to create 5 random percentage values. I then use GDI+ to plot these values on a chart.
  • How To Open and Read an Excel Spreadsheet into a ListView in .NETNov 26, 2001. The Interoperability services make it very easy to work with COM Capable Applications such as Word and Excel.
  • Data Transfer from SQL Server to ExcelDec 26, 2001. In this application, we will see how we can transfer data from Microsoft SQL Server into Excel spreadsheet.
  • A Quiz Application using Windows FormDec 27, 2001. This code shows you how to validate data in windows forms, add or remove panel control, and write a form based quiz application.
  • Working With Data TypesJan 02, 2002. Explains data types in C# and how to work with them.
  • Creating an Excel Spreadsheet ProgrammaticallyJan 22, 2002. The Interoperability services make it very easy to work with COM Capable Applications such as Word and Excel. This article reveals using Excel from a managed application. Excel is the spreadsheet component of Microsoft Office 2000.
  • Creating an Excel Spreadsheet ProgrammaticallyJan 22, 2002. The Interoperability services make it very easy to work with COM Capable Applications such as Word and Excel. This article reveals using Excel from a managed application. Excel is the spreadsheet component of Microsoft Office 2000.
  • TreeView in C#Feb 05, 2002. This program shows you how to use TreeView control in Windows forms using C# including adding, removing and searching nodes.
  • Working with Strings in VB.NETFeb 05, 2002. This article is VB.NET version of Working with Strings in .NET using C#.
  • Boxing and Performance of CollectionsMar 14, 2002. In this article, I will compare some performance issues of values and references types during boxing and unboxing operations.
  • Space Remover UtilityMar 25, 2002. In this article, I want to show you how you can remove white spaces in a web page.
  • Tracking Time in a Window ApplicationApr 15, 2002. The program reads from an XML file to get the data about names and birth dates, so it is easy to add or remove names without changing the code in case my son decides the program should include his pet dog or turtle.
  • Globalized Property GridApr 17, 2002. The property grid is a nice control to display properties and values. You create an instance of your class and assign it to the property grid. By using reflection a property grid extracts the properties of the class and displays its values.
  • Sorting MultiColumn ListView Windows Forms ControlMay 20, 2002. If you want to sort on the first column of a ListView, simply click the Sorting in the properties Window and choose Ascending or Descending as a value. If you want to do sorting in all the columns of a ListView, you need to write custom sorting using the ListViewItemSorter property.
  • Comparison of C# with Java: A Developer PerspectiveMay 29, 2002. The .NET is a language and operating system (on Windows as of now) independent platform pretty similar to Java.
  • Editable GridView Control in C# and .NET - Part IV Exporting the GridView to ExcelJun 27, 2002. In this article we will take the contents of our GridView control and spill it into an Excel spreadsheet using this wrapper mechanism.
  • Form Designer in C# and .NETSep 02, 2002. The FormMaker.NET Application has an undo feature for removing controls you just placed on the form and a fine tuning placement mechanism for positioning the control through the arrow keys.
  • Hex Colors in C#Sep 05, 2002. Currently I am developing a shareware application for generating image galleries for the web. There is a template engine built in that allows the user to specify colors as hexadecimal values, plus many other features.
  • Consumer/Producer Multithreaded ProgramNov 04, 2002. This is simple multi-threading program that adds and removes elements in an ArrayList. Producer button will creates a producer thread that adds elements in to the ArrayList. The maximum number of elements can be added to this ArrayList are 100 elements and the producer thread has to wait until the consumer thread/threads (creates by pressing consumer button) removes elements from the ArrayList. Then Producer thread starts to add more elements to the ArrayList.
  • Sorting using MultithreadingNov 13, 2002. This is simple multithreading application that sort integers values in an array.
  • The "ins" and "outs" of Using Stored Procedures in C#Jan 27, 2003. This article reviews the creation of stored procedures with parameters using the Visual Studio IDE.
  • Creating a Web User Control in .NETFeb 05, 2003. One of our C# Corner readers gave me the idea of converting my Add/Remove Control from a Windows Form control to a User Web Control, so we will use this control as an example for this tutorial
  • Basics of Extending Your Working Environment in Visual StudioApr 10, 2003. All of us have used Macros in Microsoft Office and Add-ins in Visual Studio 6 and I am very sure all of us have been impressed as well by their power to control their own working environment.
  • Developing Secure Web Site with ASP.NET and IIS: PartIIMay 07, 2003. Authentication is a very important element of developing secure sites. It is the starting point of a secure environment for the protected resources. I have discussed several authentication mechanisms available in ASP.NET and how they join with IIS to provide a secure platform to develop sites in Part I of this article. I will be looking at Form Authentication and how to implement it in several sample web applications.
  • Using C# .NET in Excel 2003May 08, 2003. This article shows how you can take advantage of Visual Studio 2003 tools to write .NET applications that work with Office 2003.
  • Dynamically Setting Properties of a Class from a DatabaseMay 12, 2003. This example demonstrates a powerful feature of Reflection that will allow you to dynamically set the values of a class.
  • Talking to the Outside World in Excel 2003May 14, 2003. This code sample shows how to connect to the internet inside of Excel 2003. The idea is when the workbook opens the code behind the workbook searches for quotes on NASDAQ and then populates the spreadsheet with the data.
  • Change Color of a Column Based on Column ValuesMay 15, 2003. In this article we'll see how to change the color of column based on the column value.
  • DataGrid and CheckBox ControlsJun 17, 2003. How to have checkbox that is checked or unchecked depending on a field value stored in the Database, and then allow the user to click on it and record the new checkbox state in the database.
  • C# Methods : Part II Jul 07, 2003. This article completes our discussion of methods. In this article, you will learn parameter passing, reference and value type parameters, and method overloading.
  • Format DateTime Values in XML Extracted From DataSet Jul 17, 2003. In this article we'll see how to specify the format of DateTime values extracted from the ADO.NET DataSet and to verify we will write formatted contents in xml file.
  • Handling Null Values in DataGridJul 17, 2003. This article shows you how to handle no data found or null values in an ASP.NET DataGrid control.
  • Boxing and Unboxing of Value Types : What You Need to Know?Jul 21, 2003. Programmers new to C# can encounter less than ideal performance and even unexpected results due to boxing and unboxing of value types.
  • Deleting a DataGrid Data Based on a Column ValueJul 24, 2003. In this article we'll see how to delete the records of a DataGrid based on a column value in the database table.
  • C# MethodsAug 05, 2003. This article explains hot to define and use methods in C#.
  • EggTimer in C#Aug 26, 2003. This simple timer app will count down from whatever value is set in the textbox.
  • Export ASP.NET DataGrid to ExcelSep 08, 2003. Export to Excel is one of the most common functionality required in ASP.NET pages. Users can download the data from the DataGrid into an Excel spreadsheet for offline verification and/or computation.
  • Enter Null Values for DateTime Column of SQL ServerSep 26, 2003. Inserting a null value to the DateTime Field in SQL Server is one of the most common issues giving various errors. Even if one enters null values the value in the database is some default value as 1/1/1900 12:00:00 AM.
  • Stock Paper Trader in C# and .NETNov 11, 2003. The attached source code project is a paper trading application that allows you to place imaginary trades on real data. I thought this would be fairly easy to duplicate having already written a stock capturing program into Excel.
  • Office11 Solution using .NET - A White PaperNov 25, 2003. This detailed white paper contains the information about Office 11 support for Microsoft .NET. It also explains Office 11 object model and how to access Word and Excel documents using Visual Studio .NET.
  • Display Alphabetically Sorted Data in a Data GridDec 24, 2003. This code sample shows you how to display data sorted alphabetically based on the values in the database.
  • Debugging a Compiled ComponentFeb 02, 2004. After an assembly is compiled into a dll in a release mode, it is very difficult to gather information from it such as runtime performance, parameters values, etc.
  • DataTable in C#Feb 17, 2004. The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have changed, their new values and their original values, and can store custom information in its Extended Properties collection. The DataSet can be exported to XML or created from an XML document, thus enabling increased interoperability between applications.
  • Data Binding in DataGrid Control using C#Feb 17, 2004. The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have changed, their new values and their original values, and can store custom information in its Extended Properties collection. The DataSet can be exported to XML or created from an XML document, thus enabling increased interoperability between applications.
  • DataSet in C#Feb 17, 2004. The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have changed, their new values and their original values, and can store custom information in its Extended Properties collection. The DataSet can be exported to XML or created from an XML document, thus enabling increased interoperability between applications.
  • DataAdapter in C#Feb 17, 2004. The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have changed, their new values and their original values, and can store custom information in its Extended Properties collection. The DataSet can be exported to XML or created from an XML document, thus enabling increased interoperability between applications.
  • DataView in C#Feb 17, 2004. The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have changed, their new values and their original values, and can store custom information in its Extended Properties collection. The DataSet can be exported to XML or created from an XML document, thus enabling increased interoperability between applications.
  • DataReader in C#Feb 17, 2004. The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have changed, their new values and their original values, and can store custom information in its Extended Properties collection. The DataSet can be exported to XML or created from an XML document, thus enabling increased interoperability between applications.
  • DataTable Events in C#Feb 17, 2004. The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have changed, their new values and their original values, and can store custom information in its Extended Properties collection. The DataSet can be exported to XML or created from an XML document, thus enabling increased interoperability between applications.
  • Constructing a DataTable using C#Feb 17, 2004. The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have changed, their new values and their original values, and can store custom information in its Extended Properties collection. The DataSet can be exported to XML or created from an XML document, thus enabling increased interoperability between applications.
  • Extreme Programming (XP)Feb 18, 2004. Extreme Programming (XP) is a discipline of software development based on values of simplicity, communication & feedback. It works by bringing the whole team together in the presence of simple practices.
  • Generating Microsoft Excel Reports in .NETMar 01, 2004. Microsoft Excel is installed on most computers these days since it is part of Microsoft office, and you can create detailed reports with Excel, but it will take some doing. I will attempt to show you how to create a simple report in Excel and some of the problems you may encounter along the way, this will work with Excel 97-2000.
  • An introduction to Matisse, a post-relational database for .NET - Part 1Mar 06, 2004. When it comes to database for .NET, there are several options in addition to the well known ones such as SQL Server or MySQL. One of them is Matisse, a post-relational database by Matisse Software.
  • The Matrix Class and TransformationsApr 01, 2004. Matrices play a vital role in the transformation process. In GDI+, the Matrix class represents a 3×2 matrix that contains x, y, and w values in the first, second, and third columns, respectively.
  • Normal Distribution Implementation in C#Apr 13, 2004. The attached source code is a C# normal distribution class. The probability density function (PDF) and cumulative distribution function (CDF) can be computed for a given x-value.
  • University Student Registration Application in ASP.NETMay 03, 2004. The aim of this project is to implement a Web application, where students can register for an online course. If the user is an administrator, he can add and remove courses and modify the student information.
  • Accessing Excel Spreadsheet in C#Jun 01, 2004. Most of the time you will use SQL, Oracle, Access or some other database to store data. But it is possible to use Excel spreadsheet much like a database to stored data. This article and code will explain how to do this in C#.
  • Setting Ink Overlay Properties in Tablet PCJun 02, 2004. In this article, I will write an application that allows us to set the Ink Overlay properties dynamically based on the values selected by the user.
  • Refactoring in Visual Studio 2005Jun 11, 2004. Refactoring allows developers to use the built-in feature of Visual Studio to rename and convert and change the signatures and definitions of a class members. In this article, I will show you how refactoring feature provided by Visual Studio 2005 can be a handy tool when you are reorganizing or optimizing your existing projects.
  • Removing Incoming Emails from MS Exchange in C#Jul 23, 2004. The purpose of one of our projects was MS Exchange handler for processing incoming emails and remove some of the incoming emails.
  • Difference between passing reference types by ref and by valueSep 02, 2004. We all know the difference between passing value types byval and byref, if the variable is passed byval any change to the variable value in the called function is not reflected back in the callee.
  • Passing Values between User Controls and ASPX PageJan 20, 2005. This article is for beginners who are learning. NET. This will be really helpful for them. Beginners will be wondered how to pass values between User Controls and ASPX page .In this article I have listed some of the ways through which you can access and set the User control values in an ASPX page.
  • Query Tool to Excel using C# and .NETFeb 03, 2005. This article show how to use .NET's interoperability feature to pull the data directly into the spreadsheet.
  • Will swap work if C# Manipulates Objects by Reference?Feb 15, 2005. C# does manipulate objects by reference, and all object variables are references. On the other hand, C# does not pass method arguments by reference; it passes them by value. Thus, a regular swap method will not work!
  • Digging Deeper - Structures in C# Feb 22, 2005. Structures in C# are similar to structures in C and C++ but with several prominent differences. In C#, structures are value types.
  • Out and Ref Parameters in C#Feb 27, 2005. The out and the ref parameters are used to return values in the same variables that you pass an an argument of a method.
  • Mapping Microsoft Excel columns with XML data (XML data integration) programmatically using a .Net Application.Apr 21, 2005. Using this program you can map Excel columns programmatically and generate an XML file containing the cell values that you had in your Excel document. After generating the XML file we can read it into a dataset.
  • How to Maintain a CodeGroup in Security Policy at Runtime?Jul 05, 2005. Whenever protected resources are accessed by an assembly, it’s permissions are determined by the code access security system of CLR. Each permission set granted to an assembly is based on the assembly's evidence (such as its URL or publisher certificate, strong name), which in turn is based on configurable security policy.
  • Creating a Dynamic Configuration Dialog in C# and .NETJul 10, 2005. This article will show you how to create a configuration dialog that builds itself from the existing application configuration name-value pairs contained in the appSettings of the app.config file.
  • Building WebParts in ASP .Net 2.0Aug 08, 2005. Web Parts is a framework built into ASP.NET 2.0 for building highly customizable portal-style pages. End users can customize Web Parts pages by changing the page layout, adding and removing Web Parts, editing Web Parts properties, establishing connections between Web Parts, and more. I would like to share how to build web parts in ASP .Net 2.0. I am providing the source code of application as well.
  • C# 2.0 Feature: Nullable TypesAug 28, 2005. C# 2.0 allows you to assign null values to primitive types including boolean and integer, which wasn't possible in previous version of C#.
  • How do I Convert a String to an Enum Value?Sep 10, 2005. In this How do I, you will learn how to convert a string to an enum value in C#.
  • ASP.NET Session StateSep 21, 2005. Session state is nothing more than memory in the shape of a dictionary or hash table, e.g. key-value pairs, which can be set and read for the duration of a user's session.
  • Convert an Enum to a StringOct 24, 2005. This article shows how to convert an enum value to a string value.
  • Windows Forms 2.0 ActiveDocumentHost ControlNov 10, 2005. The ActiveDocumentHost control provides the ability to host OLE Documents within your application. This enables you to create applications that allow in-place editing of documents such as Microsoft Word and Excel.
  • Hashtable in C#Nov 14, 2005. Hashtable is useful when you need to store data in a key and value pair. This article shows how to use hashtable in C#.
  • New Features of Visual Studio 2005 EditorNov 16, 2005. In my previous articles, I discussed various new features introduced in Visual Studio 2005. This article is another addition to the same series. In this article, I discuss some new features of Visual Studio 2005 editor.
  • ColorReliefButtonDec 14, 2005. My idea was to create a button that can be used as a colourful decoration for any application. The look of the ColorReliefButton can be determined by changing property values. The main attraction should be a cool look (Relief) of the controls text. Like this almost any font (TrueTyp) can be used to decorate a button and there is no need to use bitmaps.
  • Generating Excel Reports using ASP.NET and C#Dec 29, 2005. This article and code snippet shows how to generate Excel reports from ASP.NET using Excel objects in .NET Framework.

About remove-duplicate-values-in-excel

NA

SPONSORED BY

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!
Visual Studio Live - Redmond 2016