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 Database ExplorerJan 20, 2001. The sample connects to the SQL server database and shows you a tree view like interface of all the tables.
  • Get a database table propertiesJan 22, 2001. Get a table properties such as column names, types etc using DataColumn and DataTable.
  • Database Explorer-IVJan 25, 2001. This is version IV of the Database Explorer, which include the support for Access Database with SQL Server.
  • Write Relational Data to an XML FileMar 15, 2001. This article shows you how you can write data from a database to an XML file using DataSet.
  • Programming in ADO.NETMar 19, 2001. A simple example shows you how to read a database table in a dataset and display in a list view control.
  • ADO.NET DataSet ProgrammingMar 20, 2001. A sample project shows you how to add, edit, delete, navigate, save records in a database using DataSet.
  • Mail Merge Program - Part 2Mar 21, 2001. This is a simple mail merge program (Part 2). This program reads from the access database (by default) from a specified table.
  • Basic Database Operations in ADO.NETAug 08, 2001. This Article will show the basic database transactions select, insert update and delete.
  • 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.
  • 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.
  • Populating and Editing a DataGrid in ASP.NETAug 17, 2001. I will show here , how to develop DataGrid, which is able to retrieve data from joined tables and editable.
  • 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.
  • Oracle Database ViewerOct 17, 2001. This is a GUI based application which connects to an Oracle database depending upon the DSN, username and password that you provide. It then shows the list of tables on the left hand side in the form of a treeview.
  • Mapping Objects to Relational DatabasesNov 01, 2001. The application generates C# Class files for each table in a relational database. I have used Mysql and ODBC.NET for this project. The application only supports MySQL right now.
  • FlashCards Language Program : How to read and save Images in a Sql Server Database using ADO.NETNov 09, 2001. I thought it would be fun to write a simple program that displayed flashcards from a database and at the same time, show you how to read and write images to the database. This program is a simple flashcard program that talks to a single table in a Sql Server Database.
  • Using Interfaces in .NET RemotingNov 30, 2001. In this article, we will create a remote object that will return rows from a database table. For the sake of simplicity I have used the NorthWind database that is packed with the installation of the Microsoft SQL Server.
  • 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.
  • FlashCards Language Program : How to read and save Images in a Sql Server Database using ADO.NETFeb 19, 2002. I thought it would be fun to write a simple program that displayed flashcards from a database and at the same time, show you how to read and write images to the database. This program is a simple flashcard program that talks to a single table in a Sql Server Database.
  • A Database Web ServiceFeb 22, 2002. This program is a Web service, which contains Web methods that return a dataset after querying a database (any database) given the connection string, the password, the database, the table, the user ID and the SQL commands.
  • Create a SQL Server Database dynamically in C#Mar 05, 2002. In this article, I’ll show you how to create a new SQL Server database and its objects such as table, stored procedures, views and add and view data. I’ll also show you how to change database table schema programmatically. You’ll see how SQL statement ALTER TABLE is useful when you need to change a database table schema programmatically.
  • .NET Remoting: The Interface ApproachMar 26, 2002. In this article, we will create a remote object, and access this object using the Interface. The object returns rows from a database table.
  • Reflecting Data in .NET Classes - Part IV: From Database TableApr 08, 2002. In this article, we will be looking at how to "reflect" data from the most common data source - Database tables.
  • 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.
  • Working with COBOL Data Groups in C#Sep 11, 2002. In this article we will begin with a C# console application calling a COBOL DLL file. The C# application will pass it a number of occurrences to create in the table (much like a user requesting a specific number of months to report on).
  • Accessing Text Files using ODBC Data ProviderNov 12, 2002. In this article, I will show you how to access Access database files using ODBC data provider.
  • ADO.NET, COBOL and Stored ProcedureDec 13, 2002. A stored procedure is basically a series of SQL statements that reside on the database. The procedure could create a new table, retrieve data from one or more tables, update one or more tables or perform many other tasks.
  • Caution When Using SetParentRow of a DataSetJan 13, 2003. I had a serious performance killer when using SetParentRow in the creation of a DataSet in ADO.NET.
  • 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.
  • Add Column Dynamically to DataGrid to Display CalculationMay 08, 2003. In this article we'll see how to create a DataGrid column which displays the calculation of more than one field in the database table. The calculation could be addition, multiplication or even filtering rows.
  • How to Display Data Vertically?May 08, 2003. This article explains how to display data vertically rather than typically horizontal rows.
  • 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.
  • 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.
  • Real Life SQL and .NET: Part IIIJan 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.
  • Real Life SQL and .NET: Part IJan 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.
  • 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.
  • DataSets in Microsoft .NET - Part 2Mar 09, 2004. This article explains sorting, searching and filtering support provided by dataset and data table objects.
  • Dynamic SQL Server Database Creation in .NETMay 03, 2004. This article explains step by step dynamic creation of a SQL Server database, tables and stored procedure using Visual Studio codename Whidbey and VB.NET.
  • 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.
  • 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.
  • 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.
  • 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.
  • Adding and retrieving Images from a SQL Server TableSep 23, 2005. This article describes the process to add and retrieve images from a SQL Server table using ADO.NET.
  • How To Get All Database Tables and TableColumns in Oracle Nov 08, 2005. In this article, I will show how can I fetch all tables and corresponding columns from an Oracle database using C# and Oracle .NET Data Provider.
  • 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#.
  • Displaying Single Table Database Hierarchy with DataSet and DataRelationsMar 03, 2006. Hierarchies can be difficult to store SQL tables and even more difficult to query and display. This Example will show you how you can use DataRelation to convert single table hierarchy in to nested XML and then use XSLT to transform it to nested list.
  • Customized Binding Using CollectionBaseMar 04, 2006. In this article I am trying to explain the use of CollectionBase class. In a simple example I used CollectionBase to bind a DataGrid control with data from Employees table of NorthWind database. So please be sure that your system exists with NorthWind database before using the sample code along with this article.
  • Deploying ASP.Net 2.0 Web site to Production Server: Part IApr 03, 2006. Deploying ASP.NET 2.0 web site is the first issue facing the developer. This part of the article gives you a step by step to how to move membership tables from MS SQL express Edition to your database that you are used on your web site. The second part we will go in details to configure our asp.net web site.
  • Deploying ASP.NET 2 Web Site to Production Server: Part IIApr 10, 2006. On the first part we discussed in detail how to move our database which contains the membership tables from the default aspnetdb Database to our database. On this part we will show how to change the default settings of asp.net membership and role providers to read from tables which stored on our database.
  • Accessing Crystal Report in ASP.NET using C#May 01, 2006. This article is for web-developers who want to access crystal reports in ASP.Net by using multiple tables or views etc. This application might help them and save their development time.
  • Merging data into single table from multiple tables (resultsets)May 15, 2006. This article shows how to reduce the number of trips to improve performance by merging data into single table from multiple tables (resultsets).
  • Embedded Datagrids with Add, Edit and Delete funtionalityJun 02, 2006. This article features an embedded Datagrids with Add, Edit and Delete funtionality.
  • Nested Repeater : Display Hierarchal Data in Web Form by Using ASP.Net RepeaterJun 02, 2006. This article features how to display hierarchal data from multiple tables using an ASP.Net repeater control in a web form.
  • Introduction to Common Table Expressions – SQL Server 2005Aug 03, 2006. This article delves into the concepts of Common Table Expressions (CTE) in SQL Server 2005 and their usage.
  • Maintaining Transactions in Enterprise applications using ADO.NET Transactions Aug 07, 2006. This article explains usage of System.Transactions to update tables of two different databases with two different data providers (SqlClient and OleDB) in Atomic(ACID) way.
  • 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.
  • How to Extend User Profile in ASP.Net 2.0Oct 03, 2006. This article will give you guidelines to extend user profile in standard table format which created from aspnet_regsql command by creating a detail table which will be linked to the main user table.
  • 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.
  • Working with HashTable in C# 2.0Nov 13, 2006. We often need to store more than one dimension data in a list and data may not be an integer or string. This article shows how to use the HashTable class to store object type data.
  • Strategy for querying Microsoft Access as an In-Memory Database using DataSets and ADO.NETJan 09, 2007. This article describes how you can read tables in from MSAccess up front in your application and then query the tables in-memory using some powerful features of the DataSet and ADO.NET
  • 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.
  • Windows Communication Foundation callbackJun 12, 2007. This article is intended to illustrate how to implement callback operations in WCF through a common business scenario where the service needs to notify that some events has happened to the client. During a callback, in many aspects the tables are turned: the service becomes the client, and the client becomes the server.
  • How Do I Bring a Microsoft Word Table into a DataGridView?Jun 12, 2007. This Article will answer the question: "How do I import a table in MS Word into a DataGridView using Visual Studio's built in Tools for Office.
  • 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.
  • 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.
  • 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.
  • 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.
  • Retrieving Middle Rows from a TableOct 16, 2007. This article helps in retrieving middle rows of a particular table irrespective of its columns and data types.
  • View database structure using C#Jan 16, 2008. This article describes an easy approach for examining all of the tables, views, and columns in a database.
  • SQL Server backup utility using VB.Net and SQL-DMOFeb 05, 2008. This article allows you to take backup of any SQL Server database using SQL-DMO library. It allows you to take backup of selected tables, views or stored procedure.
  • Using XSL and .NET To Display Database Tables in your Web BrowserFeb 07, 2008. This article describes how you can leverage .NET and XSL as a powerful and flexible means to rendering database reports into your Web Browser.
  • 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#.
  • 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.
  • The Concept of Shopping Cart in ASP.NET with C#Jul 16, 2008. This article will just give you the brief idea how to make simple shopping cart with dropdown GridView and data table.
  • 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.
  • Working with WPF Table using XAML - Part IAug 12, 2008. In this article, I will use WPF table in XAML format. This one defines a flexible grid area that contains rows and columns. At the contrast of the Grid object witch is defined in the System.Windows.Controls, the table object is defined in the System.Windows.Documents namespace.
  • Working with WPF Table using C# - Part IIAug 26, 2008. In the previous article, Working with WPF Table using XAML - Part I, we discovered how to perform this task using XAML. Now, we will see how to do the same using C#.
  • 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.
  • Physical Data Organization and IndexingOct 07, 2008. This article is intended to explain the main storage structures used in database systems through examples in Microsoft SQL Server and Oracle Database.
  • Simulating Autonomous Transactions in Microsoft SQL ServerOct 10, 2008. In the article, I will cover how to use table variable techniques in order to simulate the autonomous transaction behavior of Oracle databases in Microsoft SQL Server.
  • 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#.
  • Introduction to Page Layout using DIV elementFeb 03, 2009. This article explains about benefits of using DIV tag over TABLE in page layout design.
  • 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).
  • Paging and Sorting ListViews with ASP.NET MVC and jQueryMar 23, 2009. This article provides a simple example of using jQuery along with the jQuery tablesorter and tablesorter.pager plug-ins to provide sorting and paging support for a listview within the context of an ASP.NET MVC application. JQuery has partnered with Microsoft and is now integrated within the IDE to include the availability of intellisense support.
  • Backup utility in .NetApr 03, 2009. This is a article named backup is used to create a backup of your data and can restore your deleted data also.
  • BizTalk Mapping. Using the Database Lookup FunctoidApr 06, 2009. In this article, I will show how to use the Database Lookup functoid to map incoming XML node to a database table column whose result value is set to a target XML node.
  • CRUD Operation on Associated table in ADO.NET Data Service May 27, 2009. This article will explain , how to perform data base operations on associated table in ADO.NET Data Service

About deleting-table

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