C# Corner

Resources  
  • Binary Search Using ArrayList Jan 10, 2000. The ArrayList class provide binary search algorithm and more...
  • Add, Edit, Delete, View data using ADO+Jan 04, 2001. Free to use Tutorials on using ADO+ on Microsoft's .NET Platform in C# as programming language.
  • ADO.NET DataSet ProgrammingMar 20, 2001. A sample project shows you how to add, edit, delete, navigate, save records in a database using DataSet.
  • 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.
  • 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.
  • Editing, Deleting, Sorting and Paging in DataGrid Web ControlAug 08, 2001. The following article is about techniques for editing, deleting, sorting and paging using web Datagrid control.
  • Basic Database Operations in ADO.NETAug 08, 2001. This Article will show the basic database transactions select, insert update and delete.
  • Automatic Generated DataGrid CommandsAug 15, 2001. This article illustrates how to update, insert, and delete in the windows DataGrid control by using automatic generated commands.
  • 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#.
  • Accessing Oracle DatabaseSep 21, 2001. This source code shows you how to connect to an oracle database and do operations such as select, insert, update and delete.
  • Working with Windows RegistrySep 25, 2001. In this small tutorial, I'll show you how to read, write and delete Windows Registry.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • Querying COM+ through Web ServicesMar 12, 2003. The most COM+ common administrative tasks (creating a COM+ application, installing/deleting a component, setting a component attribute) can be accomplished manually with the Component Services administrative tool from Management Console.
  • FTP Client Utility Apr 04, 2003. This is an FTP Client Utility to transfer Files and directories between hosts. It provides the casic FTP features and also some advanced features like uploading directories with the subdirectories and deleting directories with the subdirectories.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • Display Sorted Records in Crystal ReportsOct 03, 2003. This article shows you how to use Crystal Reports options to sort a report records.
  • 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.
  • 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.
  • Real Life SQL and .NET: Part IVJan 13, 2004. Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management. Alas, for the reason that it is first necessary to provide a background of SQL and cover some preliminary concepts that we need to know, the majority of this article is text in paragraph format.
  • 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#.
  • Tablet PC Ink Editing Modes - Select and Delete InkJun 25, 2004. In my previous articles, I discussed how to use Ink and set its properties to draw on a Windows Forms and Windows controls. In this article, I will discuss some more features of Tablet PC Ink including selecting and deleting ink, Ink collection, and Ink object.
  • Using ListBox in C#Dec 28, 2004. The source code demonstrates how to use a listbox control in C# - adding, deleting and altering strings.
  • 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.
  • 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.
  • Insert Master-Detail Data using Transact-SQLJun 24, 2005. Microsoft SQL Server 2000 SQLXML allows among other things to manage batch operations in a database, which reduces significantly the need of more than one round-trip to a database. OpenXML is a Transact-SQL statement that allows to represent data in XML format and can be used to insert, update, and delete more than one row (represented by an element) in a table or group of tables.
  • 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.
  • 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.
  • Monitoring System Usage using Windows ServiceMay 29, 2006. This article shows how to record system usage using Windows Service in C#.NET
  • Embedded Datagrids with Add, Edit and Delete funtionalityJun 02, 2006. This article features an embedded Datagrids with Add, Edit and Delete funtionality.
  • 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.
  • 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.
  • Update and Delete Rows in a DataTableAug 24, 2006. This how do I shows how to update and delete rows when looping through a DataTable.
  • 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).
  • User Confirmation before Deleting Items in ASP.Net 2.0Oct 12, 2006. This article describes how ASP.Net 2.0 allows setting client-side functions for Button controls through the use of the OnClientClick property and additionally, the event can be handled on server-side depending on the user response.
  • 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.
  • Excel Automation in .NetJan 08, 2007. This article explains how to achieve excel automation in .Net.
  • Import data from Excel to Access using ADO.netMar 05, 2007. Data interoperability with Microsoft office applications has become easier with ADO.net.
  • 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.
  • 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
  • C# Asynchronous, Multi Threaded Development... Digging In. Part IIMay 13, 2007. In this article we'll dig a bit deeper into what is actually happening when we use the asynchronous calls using C#. Just as in my previous article, we'll simulate a long running I/O bound process as if we were fetching records from a database, making a web service call or reading or writing from a file and see how we can write more performant code by letting the main thread continue on and not wait for the results. 
  • On-line Address Book in ASP.NET 2.0May 25, 2007. This is an On-line Address Book project. This project is very useful to keep the record and addresses of person. Here in this project we can view all record, edit any record, delete any record, search a record and update any record. This project will be very useful to those who are new or going to his/her first ASP.NET project.
  • Whose Online in ASP.NET 2.0Aug 06, 2007. I had problem in one of the project to show who is onlne & how to track multiple login/prevent from multiple login. I had gone back and forth so many time and finally am here with small snippet of code, I guess eveyone should read this article!
  • Data Binding using LINQ to SQL in C#Aug 09, 2007. LINQ to SQL allows developers to work with databases using LINQ. This article discusses how to get, add, update, and delete data in a DataGridView control using LINQ to SQL.
  • Creating a Dynamic Excel Using HTMLAug 30, 2007. This article includes some sample programs to show how to implement various excel functionalities with the help of HTML.
  • WPF Database Communication Adding new Record to the DatabaseSep 06, 2007. WPF Database communication Adding new record to the database (XAML-MS-Access), I have a XAML form with FirstName, LastName, Email & Contact fields in it on click of submit button it will first check if the same email address is exists in the table else it will add new record I have made use of OleDbTransaction to perform add functionality.
  • Generic Data Layer - One time creationSep 06, 2007. This article will explain how to create a generic data layer that can be used with very less amount of coding. It is a known fact that, most of the time we create applications for Create , Select , Update, Delete. And every time, we end up with writing similar set of code for every execution of our stored procedures.
  • Introduction to Building a Plug-In Architecture Using C#Sep 10, 2007. In this article we'll take another look at how we can use the state pattern to build a plug-in architecture that will allow us to change the behavior of our application by placing differnt plug-ins into a folder.
  • How to display the records in DataGrid by using the PagingSep 11, 2007. Through this article you will learn the concept of Paging in detail. You can display the large records in DataGrid by using Paging.
  • Edit, Delete and Update in a DataGrid in Visual Web developer 2005Sep 26, 2007. Here in this article I am going to show, how to edit, Delete and update data in a DataGrid.
  • DetailsView Rich Data ControlFeb 01, 2008. DetailsView is a data-bound control that renders a single record at a time from its associated data source.
  • How to Convert XLS File into CSV File in C#Feb 27, 2008. The article shows you a simple way to convert an XLS file into a CSV file by using a small C# program
  • Using OUTPUT Clause for Getting Deleting Information from Several Tables.Apr 01, 2008. In this article I will explain how you can use such a T-SQL (SQL Server 2005) feature as OUTPUT clause in order to get information about rows, which were affected, when deleting process is executed for several tables, “connected” by foreign keys. The examples are written using T-SQL and C#.
  • Working with Parameter Fields in Crystal ReportsJun 24, 2008. This article is intended to illustrate how to use Parameter Fields in Crystal Reports. Parameter fields enable the creation of reports that could be used in a variety of ways, prompting the user for all kinds of information specifically for record selection and report titles.
  • Connect to an Excel file as a data source via OBDCJun 30, 2008. This article provides answer to questions asked about how to connect to an excel file as a data source for a given application, I provide the solution via this ten steps walkthrough.
  • Cascading Deletes in LINQ to SQLJul 03, 2008. This article will discuss alternative methods for performing cascading deletes using LINQ to SQL. Cascading delete refers to the action of removing records associated by a foreign key relationship to a record that is the target of a deletion action.
  • Silverlight 2 use ADO.NET Data Services to access dataJul 19, 2008. In this article will show how to perform CRUD (Create, Retrieve, Update, Delete) operations in Silverlight 2 using ADO.NET Data Services.
  • Insert, Update and Delete in Silverlight DataGrid using ADO.NETJul 22, 2008. In this article will show how to perform CRUD (Create, Retrieve, Update, Delete) operations in Silverlight 2 using ADO.NET Data Services.
  • Generic Data Access using LINQ to SQL and C#Jul 22, 2008. This article discusses the construction of a generic data access layer built on top of a LINQ to SQL implementation.
  • Enhanced Desktop Recorder in .NET using C# and Windows FormsJul 22, 2008. This application provides features that will allow Desktop recording, sharing and broadcasting etc easier.
  • Integrate WPF Control in your Excel SolutionsAug 11, 2008. In this article, I will show that it is possible to host a WPF control in a excel solution even that Visual studio and the .Net framework doesn’t provide us a way to host directly a given WPF control in an Excel application. To know how to realize such task, then follow this walkthrough.
  • LinqDataSource Control in ASP.NET 3.5Sep 16, 2008. This article shows that how to use LindDataSource Control in ASP.NET 3.5.
  • Understanding Database Stored ProceduresSep 29, 2008. This article discusses basics of stored procedures and how to create, update, and delete stored procedures in a database.
  • Creating and Working with Views in a DatabaseOct 02, 2008. This article discusses how to create, update, and delete views in a database using SQL.
  • Create, Delete, and Update Triggers in a DatabaseOct 02, 2008. This article discusses how to create and manage triggers in a database using SQL.
  • Getting started with ADO.NET Entity Framework in .NET 3.5 - Part IIOct 06, 2008. This article contains a very simple ADO.NET Entity Framework application to update and delete the data to the database using ADO Entity Framework.
  • Bulk DML With SQL Server 2005 - XML Data TypeOct 15, 2008. This article explains about doing bulk DML on SQL Server 2005 using XML datatype
  • Select, Add, Update, and Delete Data in a ASP.NET GridView ControlNov 23, 2008. This articles describes you how to view, add, update, and delete data using an ASP.NET 2.0 GridView Control in SQL Server database and C#.
  • Import Data from Excel to a SQL Server databaseJan 16, 2009. This article mainly describes about how to import the data from Excel sheet to the SQL Server database.
  • Simple & Complete GridView Functionality in .Net 2.0Feb 18, 2009. This article provides a single GridView which is capable of Displaying Data from database, Updateing it if required, Deleting the existing records from database based on a Confirmation Message and Inserting a new record(which is beyond the implicit usage of GridView).

About Delete-duplicate-record-in-excel

NA

SPONSORED BY

C# Corner Chandigarh DevCon16
Chandigarh DevCon16 is a one-day Developer Conference where programmers, technologists, authors, and members meet, demonstrate, plan, and hang out.
Download Free eBooks