C# Corner

Resources  
  • C# Installation and CompilationSep 29, 2000. This article explains what you need to install on your machine to run C# and where to find the downloads.
  • ADO.NET DataSet ProgrammingMar 20, 2001. A sample project shows you how to add, edit, delete, navigate, save records in a database using DataSet.
  • Windows Calculator in C#Mar 27, 2001. This is a simple Calculator application as you will find in a Windows accessories.
  • 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.
  • Find Files in C#May 01, 2001. I have developed a small application in c#, which helps in searching u'r hard disk for files of the desired extention.
  • 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.
  • Basic Database operations using ADO.NETAug 21, 2001. I found very interesting database features incorporated into the .NET as ADO.NET.
  • Web Services between .NET, Java and MS SOAP Toolkit: Part IAug 24, 2001. WinGhost 2.0 application allows you to show and hide applications running on your machine. I find this program useful at my work as I do lot of programming at any given time I can have a bunch windows open. I use it normally to hide just my windows I don't access that often.
  • 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#.
  • Modest Introduction to IL Assembly LanguageSep 03, 2001. Since I received copy of Visual Studio .NET Beta 2 and did not manage to find “ILAssemblyLanguageProgrammersReference.doc” which was included in beta 1 I decided to share my experience with other assembly enthusiasts.
  • Constructor, Destructor and ILASMSep 20, 2001. I find C# a very interesting language and it also comes handy to analyze ILASM code.
  • Oracle Database ConnectivitySep 26, 2001. This is a GUI based data entry application which shows how to add, modify and delete records using Oracle Database.
  • Debugging "Rubber Band Effect"Nov 06, 2001. Bug fixes for Rubber Band Effect in a form by Simon Bond demonstrated a small but useful rubber band effect application. If you play with the application for a while, however, you may find one major problem with it.
  • 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.
  • Developing a Record Navigation Form with Unbound ControlsDec 26, 2001. Developing a record navigation form with unbound controls. The form enables you to navigate through the records one at a time. In this application we have used a combo box, two text boxes and various command buttons.
  • 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.
  • Using MS Agent in C# - Part-IIIJan 09, 2002. In this article, I will show you how to write a program which lists all the animations of the loaded characters which speak to us using synthesized speech, recorded audio, or text in a cartoon word balloon.
  • 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.
  • World Clock Using Windows FormsFeb 11, 2002. I developed a C# application for finding World Timings given the US Central Timing.
  • Marble Solitaire Solution Display in GDI+Feb 13, 2002. The application finds and displays solutions to a game of solitaire. The application was written using Visual Studio.NET Version 7.0.9254. The test suite was written using NUnit, which is a .NET port of JUnit.
  • A Shaped Windows Forms Application with Variable OpacityMar 11, 2002. This application demonstrates two simple techniques that beginners might find useful in developing creative new looks for Windows applications.
  • Tutorial: Capturing and Running IE Instances in a Windows controlMar 15, 2002. In this article we are going to study how to find the running instances of Internet Explorer on your machine.
  • BattleShips GamesApr 02, 2002. This application presents a grid of 100 squares to the user. The user has thirty five attempts to find to find the computers fleet. The computer randomly positions five ships of varying sizes around the board.
  • DNS Resolver using DNSAPI.DLLApr 15, 2002. This is a DNS resolver using the dnsapi.dll, it can do all sorts of DNS lookups and not just simple a record lookup like the Dns class in the .NET framework.
  • Performance Comparison of XslTransform InputsMay 02, 2002. To transform XML into HTML for use on a Web site or to transform it into a document that contains only the fields required you could use the XSLTransform class (found in the System.Xml.Xsl namespace).
  • Performance Comparison of XslTransform InputsMay 02, 2002. To transform XML into HTML for use on a Web site or to transform it into a document that contains only the fields required you could use the XSLTransform class (found in the System.Xml.Xsl namespace).
  • DataGrid Customization: Part-1Jun 25, 2002. In this article, I will discuss some DataGrid customization tips such as how to I get the name and index of the column headers and how do I find out if mouse click right click was on a column.
  • 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.
  • Use CurrencyManager and MemoryStream to Display ImagesJul 01, 2002. This article and attached sample code demonstrates you how to use the CurrencyManager and MemoryStream to display images. The current demonstration displays all the records of the employees with their company and the personal Information.
  • DataGrid Customization Part-II: Custom Sorting and DataGrid Column HidingAug 13, 2002. How to I get the name and index of the Column headers? How do I find out if mouse click right click was on a column
  • TWINXBASE ServiceSep 09, 2002. This service scans in a directory by using FileWatcher component and when a file arrives, then the service will check the extension of the file, if the file has the extension .DBX then it will read the contents of the file and communicate with the database (C:\FILESERVICE\DB\MyDB.mdb) and insert / update / delete the records in the database -table.
  • 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.
  • Recording Sheet Music Using C# and .NETFeb 07, 2003. This is a article that allow you to record and replay the music you performed on the piano.
  • ShootDraw: Managed DirectX Application WizardMar 10, 2003. The Managed DirectX Application Wizard has created this "ShootDDraw" project for you as a starting point.This file contains a summary of what you will find in each of the files that make up your project.
  • Making Thumbnails of Transparent Images in .NET and C#Mar 28, 2003. When I started writing web applications using .NET, I found myself in need to dynamically create thumbnails of images that could be uploaded by the user or pulled from a database.
  • 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.
  • FTP Client Library for C#Apr 26, 2003. Finding a fully working, lightweight FTP Client that had no GUI, was free, and came with source was difficult.
  • 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.
  • 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.
  • 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.
  • Lengthy Operations on Single Thread in .NET ApplicationsJul 08, 2003. In this article I discuss how the lenghty operations can be handled in a .NET application. I also discuss how the stack trace can be examined to find any specific methods.
  • Building a Navigation System in ASP.NETJul 16, 2003. This article shows you how to display single record per page and navigate through single record using ASP.NET.
  • SMTP InternationalizationJul 16, 2003. You can find many articles dedicated to C# SMTP implementation on this or other sites.
  • 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.
  • 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.
  • User Controls in Internet ExplorerAug 13, 2003. WinGhost 2.0 application allows you to show and hide applications running on your machine. I find this program useful at my work as I do lot of programming at any given time I can have a bunch windows open. I use it normally to hide just my windows I don't access that often.
  • 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.
  • Interlocking ThreadsSep 10, 2003. Recently, I was building multi-threaded applications and noticed some intermittent data inconsistency. Soon, I found the culprit was locking mechanism. After doing some research, I gathered the following information and as usual decide to share with you guys.
  • Creating Word Find Pzzules in C# and GDI+Sep 30, 2003. Perusing the newsstands in New York you'll find newspapers, TV-Guides, magazines, and even books. In the magazine section you'll often find crosswords and books containing the puzzles you'll see in figure 1. The books contain pages and pages of puzzles with hidden words contained in the matrix of letters in which you can spend time going blind trying to find.
  • Creating Word Find Pzzules in C# and GDI+Sep 30, 2003. In the past I have been guilty of trying a few of word find puzzles myself, so I figured why not give it a go it .NET. The Word Find creator reads a MSDE database of Words and Categories.
  • Display Sorted Records in Crystal ReportsOct 03, 2003. This article shows you how to use Crystal Reports options to sort a report records.
  • Creating Word Find Puzzles for the Web in C# and GDI+ Part IIOct 06, 2003. In our last article we showed you how to create Word Find Puzzles inside of a Windows Form. This article will show you the migration process of bringing it over to an ASP.NET application.
  • Creating Word Find Puzzles for the Web in C# and GDI+ Part IIOct 06, 2003. This article shows you how to create Word Find Puzzle application for the Web using C#, GDI+, and ASP.NET.
  • 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.
  • Directory Picker Pro in C#Nov 24, 2003. In my latest project I needed a dialog for picking a directory. I searched through the web, but found nothing that looked nice. First of all I wanted a TreeView for display, and I wanted to view all system drives (with correct names and icons).
  • 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.
  • Edit/Update a Chosen Database RecordDec 09, 2003. This article and available source code shows how to edit and update a database record through a DataGrid control
  • DNS Client in C#Dec 22, 2003. The attached source project contains the library and source code for DNS client application. This client supports A, MX, and PTR records.
  • 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.
  • A Macro for Creating Properties from Private FieldsMay 12, 2004. Macros are a useful way of speeding up your coding efforts, however writing them can be a somewhat daunting task. Luckily, .NET gives you a pretty powerful recording feature for recording macros from key strokes.
  • 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#.
  • Writing unsafe code - pointers in C#Oct 13, 2004. In this article I will give a short description of one of the feature of C# which are pointers and so-called unsafe code. This subject is particularly close for C++ programmers. Moreover, it is a feature that we do not find in Java.
  • ClickMania GameDec 21, 2004. This is an old game, first implemented in 1996 or so... It has a great addictive power. You will quickly find out the rules. I used the winmm.dll library for playing sounds, the picturebox.Paint event to draw bitmaps in a Picturebox and a recursive function to check the balls next to each other for the colors.
  • 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.
  • Stack in C#Feb 22, 2005. Stacks are one of the common data structures used in the software world, which follows the First In Last Out paradigm. Stacks are used in various mathematical functions like Towers of Hanoi, finding Fibonacci Sequence , Factorial of a number to name a few.
  • 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.
  • Active Directory and .NETJun 22, 2005. Microsoft Technet offers a script repository to work with AD User Accounts; however, I needed to work with .NET and I could not find samples for all the tasks I needed to program. I promised to myself that one day I would publish the code samples I found and created to help other developers who are working with Directory Services.
  • Custom Error Handling Using ASP.NETJul 07, 2005. Sometimes in your application, you may want to show some decent error messages other than red error messages and some message when page is not found or server is busy. We will see custom error message handling mechanism in this article using ASP.NET.
  • POC for DOM XML ParserJul 21, 2005. The classes found in System.Xml namespace provide functionality to parse and navigate through XML documents. The attached source code shows how to use this functionality in C#.
  • NotePad.NET II - Find and Replace Inside a Document Using Regular ExpressionsSep 04, 2005. This article is a continuation of the discussion about a notepad.net editor which improves upon the current functionality in notepad. In this article we talk about regular expression matching inside the find dialog.
  • 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.
  • 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.
  • Security Setting for ExcelJan 04, 2006. To run the excel report, security settings are required for excel application because while working with the excel application we are going to use some of the classes for manipulating the data inside the file. This article shows how to grant access or rights to those files.
  • Birthday Wish Scheduler in C#Feb 02, 2006. In this article we are going to see how to build a windows service for fetching record from database and wishing the person whose birthday falls on that particular day.
  • Writing Dataset to Excel in ASP.NETMar 01, 2006. This article is helpful for those who would like to write dataset contents to a excel file and try to display it in the browser.
  • Play with the Excel Object Library using .NETMar 02, 2006. In this article we will see usage of several things like how to use WebBrowser control, manipulating Excel object libarary.
  • Data mining and SQL Server 2005Apr 11, 2006. Data mining is a key member in the Business Intelligence (BI) product family in SQL Server 2005 . Data mining is about analyzing data and finding hidden patterns using automatic or semiautomatic means, which can be explored for valuable information. It is about learning the characteristics of data set, which are not possible to discover by simple seeing.
  • Monitoring System Usage using Windows ServiceMay 29, 2006. This article shows how to record system usage using Windows Service in C#.NET
  • Client-Side XML Data Islands Jun 17, 2006. This article demonstrates how to send xml data to the web client, filter records from xml at client side by using XPath expression and populate all products of selected category into product drop-down.
  • Regular ExpressionsJul 05, 2006. The purpose of this article is to build upon the existing pool of regular expression articles by providing an overview of the new regular expression features found in .NET and to offer some guidelines as to when and how to use them.
  • Tip: How to Suppress if Duplicate a Memo Field in Crystal Reports?Jul 21, 2006. If you create a report with memo field in Visual Studio 2003 and check Suppress if Dupliate checkbox, you will notice the suppress on memo field does not work. This tip shows how to do it.
  • Flashing Stock Alert Application using C# and the Basic Stamp IISep 15, 2006. This article describes an application for reading stock quotes into an excel spread sheet and alerting the user when the stock quotes have exceeded or dropped below a certain price threshold. The project uses the SerialPort class to send commands to the Parallax Basic Stamp Microcontroller.
  • Read and write Open XML files (MS Office 2007)Sep 22, 2006. This article shows how to read and write Open XML files (MS Office 2007).
  • Generating a Report from Multiple Data Sources in Crystal ReportsOct 23, 2006. If you have to create a report in Crystal Reports from multiple data sources or provide multiple views of the data, you may find sticky situations because CR does not allow you to have multiple Detail sections in a single report.
  • ASP.Net 2.0: Export GridView to Excel Nov 06, 2006. This article describes how to Export an ASP.Net 2.0 GridView to Excel.
  • A guide to ObjectDataSource controlNov 17, 2006. One of the best new features of the forthcoming ASP.NET 2.0 will be the ObjectDataSource control. However, as I found out in my experimentation what seems like a simple control has some complex behaviours to master to get it working properly. If (like me) you have an existing data access layer you may have to make changes to be able to use ObjectDataSource.
  • Tip related to sub containers and SqlDataSourceDec 06, 2006. This article provides some tips when working With Master page or SqlDataSource insert function In VS 2005.
  • Find and Replace for Multiline TextDec 26, 2006. This article explains how would you find and replace a multiline text.
  • Excel Automation in .NetJan 08, 2007. This article explains how to achieve excel automation in .Net.
  • How to Bring up a Find Dialog in the WebBrowser Control using Managed C++Feb 07, 2007. This article will answers the question, "how do I bring up a find dialog in the Web Browser Control?". As easy as you would think this should be, it actually requires some COMplicated manipulation.
  • Import data from Excel to Access using ADO.netMar 05, 2007. Data interoperability with Microsoft office applications has become easier with ADO.net.
  • AdRotator Standard ControlMar 14, 2007. This article will help programmer, developer to overcome the problem as:"The AdRotator adRtrCtrl/adRotator1 could not find the AdvertisementFile or the file is invalid".
  • Concurrency violation: the UpdateCommand affected 0 records. Mar 27, 2007. When you use a DataAdapter object to write changes back to a database by means of a stored procedure, you may receive the following error message: Additional information: Concurrency violation: the UpdateCommand affected 0 records.
  • ASP.Net 2.0: Export GridView to Excel - Part IIApr 04, 2007. In this version of the article, we will include the handling the Hyperlink columns in the GridView export to Excel and also re-factor our original logic to use more general features of Reflection.
  • TreeView Control in C#Apr 16, 2007. This is an article addressing some of the basics of working with a TreeView control; the article will address dynamically adding TreeNodes to a TreeView control, searching the nodes to find and highlight a single node or a collection of nodes.
  • Implementing Search in Reports using ReportViewerApr 30, 2007. The ReportViewer control provides Find and FindNext methods to find a text in the report. This article explains how you can implement search functionality in reports programmatically.
  • How do I Check for Duplicate Items in a ListView?May 09, 2007. This "How To" Shows you how to Check for Duplicate Items in a ListView

About Find-duplicate-record-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!
Download Free eBooks