C# Corner

Resources  
  • 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.
  • Deploying Programs in C#Mar 08, 2001. Deploying projects in Visual Studio.NET is fairly straightforward. Most of the process is automated for you through some convenient wizards so it doesn't require much effort. Keep in mind, though that you probably need the Windows Component Update Beta 1 on the machine you are deploying to. I suspect you also need the Microsoft .NET Framework, as well (for now).
  • 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.
  • 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.
  • Drag and Drop Using C#Mar 30, 2001. Drag and Drop in C# has been a question on the UseNet and many websites on C# so I have decided to tackle the problem here. This is an update of the directory tree component download on this web site.
  • Web Scanner Part-1Jun 01, 2001. My favourite technology web site is updated throughout the day. I thought it would be nice to have a program that checked every 30 minutes for updates and told me what stories were there.
  • 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.
  • 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.
  • Live News feed For Mobile SiteSep 05, 2001. Current News are read from a text file, which is being updated regularly after certain interval time.
  • 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.
  • 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.
  • Reading and Writing XML in C#Oct 29, 2001. In this tutorial, you will learn how to read and write XML documents in Microsoft .NET using C# language.
  • 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.
  • Yahtzee Program Using C#: Part IIJan 31, 2002. This is an update of the Yahtzee program for VS 2005. Included in this version is a Game Reset and a High Score Tracker. The Top Ten High Scores are tracked using an Array with sortable components. In this article we will talk about the IComparable interface used to make an object stored in an array sortable.
  • World Weather Update on Your MobileFeb 04, 2002. In this article, I would like to discuss the "Weather Update" on Your Mobile.
  • 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.
  • Macro to Update References of all Projects in a SolutionJul 24, 2002. When working in enterprise development there are occasions when you have a solution file with 10 or more projects in it all using private assemblies.
  • Macro to Add Strong Names to VS.NET ProjectsAug 06, 2002. When writing class libraries in Visual Studio .NET that are going to be placed into the GAC you will need to add strong name to the assembly. This is normally done by dropping out to a dos prompt and running the .NET utility sn.exe and then updating the assembly to reference the newly created .snk file.
  • 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.
  • Synchronized Threading in .NETDec 11, 2002. Threads are a powerful abstraction for allowing parallelized operations: graphical updates can happen while another thread is performing computations, two threads can handle two simultaneous network requests from a single process, and the list goes on. Since threads are pretty simple to understand, conceptually, but, practically, they are a cause for programmatic headaches, I decided to write this program to describe how to make use of threads.
  • 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.
  • Ray Tracking in C# and .NET UpdatedDec 17, 2002. In this article, the author adds (fixes) new features to the code.
  • Events in C# Made Easy - Lesson1Jan 02, 2003. Events are useful for updating a user interface with changed data, or causing a piece of code to run after another piece of code has completed. .NET has brought us a powerful model for programming events.
  • 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.
  • Updated ReshuffleColumns MethodMar 20, 2003. Here is an updated version of 'ReshuffleColumns' method of article DataGrid Customization by Mahesh Chand.
  • How to Display Data Vertically?May 08, 2003. This article explains how to display data vertically rather than typically horizontal rows.
  • 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.
  • 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.
  • In Depth ASP.NET using ADO.NET: Part IIINov 18, 2003. In this article we will discuss a number of ways to retrieve, show, and update data with ASP.NET forms using ADO.NET. Also, we will have a clear idea about the most common server controls in ASP.NET.
  • In Depth ASP.NET using ADO.NET: Part IINov 18, 2003. In this article we will discuss a number of ways to retrieve, show, and update data with ASP.NET forms using ADO.NET. Also, we will have a clear idea about the most common server controls in ASP.NET.
  • In Depth ASP.NET using ADO.NET: Part VNov 18, 2003. In this tutorial we will discuss a number of ways to retrieve, show, and update data with ASP.NET forms using ADO.NET. Also, we will have a clear idea about the most common server controls in ASP.NET.
  • In Depth ASP.NET using ADO.NET: Part IVNov 18, 2003. In this tutorial we will discuss a number of ways to retrieve, show, and update data with ASP.NET forms using ADO.NET. Also, we will have a clear idea about the most common server controls in ASP.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
  • 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 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 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.
  • 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.
  • 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.
  • Bulk Data Transactions using OpenXMLOct 13, 2004. OPENXML is a new function added to SQL Server 2000 that provides a rowset view over an XML document. Since a rowset is simply a set of rows that contain columns of data, OPENXML is the function that allows an XML document to be treated in the familiar relational database format. It allows for the passing of an XML document to a T-SQL stored procedure for updating the data.
  • Language Extensions in C# 2.0Apr 21, 2005. This article intends to the C# 1.x developers and covers what-why-how the new enhancement .The philosophy behind the document is to have quick update on C# 2.0 and leverage this in your day to day development work.
  • 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.
  • Space Invaders for C# and .NETJun 29, 2005. This is an update of the space invaders game posted on C# Corner 3 years ago for Visual Studio 2005. This version adds spiraling bombs and a ship lives indicator.
  • Learning Visual Studio 2005 IDE - Integrated FxCop and Accessibility OptionsJul 23, 2005. Visual Studio 2005 IDE brings you many new and updated features and Project Properties dialog is one of the areas where you will see some new additions. In this article, I will discuss Accessibility and FxCop features of Project Properties dialog.
  • Adding a ComboBox Column Style to a DataGrid in Windows Forms Jul 30, 2005. The sample introduces how to add the Combobox DataGrid Column Style into a DataGrid on your .NET Windows form.
  • Top 10 New Features in ADO.NET 2.0Aug 19, 2005. This article summarizes the new and updated features of ADO.NET 2.0, which ships with .NET Framework 2.0. In my following articles I will discuss these features in more details with sample examples.
  • 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.
  • Drawing XY Plot Graph in C#Sep 30, 2005. The attached code is an update of Mike Gold's XY Plot graph.
  • 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#.
  • Creating a Blog in ASP.NET and C#Dec 02, 2005. Blogs can be a fun way to express your thoughts to others on the web. This article will show you how to create your own blog application so you can get started in the world of blogging. (This is an update from VS2003 to VS2005).
  • ADO.NET Enhancements in .NET Framework 2.0 for SQL Server Data Provider: Part IJan 04, 2006. ADO.NET 2.0 includes enhancements for SQL Server client application developers. Understanding these enhancements will help you design and implement effective client applications on the .NET Framework 2.0 platform
  • ADO.NET Enhancements in .NET Framework 2.0 for SQL Server Data Provider: Part IIJan 05, 2006. ADO.NET 2.0 includes enhancements for SQL Server client application developers. Understanding these enhancements will help you design and implement effective client applications on the .NET Framework 2.0 platform
  • Update Database using DataSetFeb 06, 2006. In this article, we will see how to update a database using a Data Adapter's Update method using C# and ADO.NET.
  • 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).
  • 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.
  • ASP.Net 2.0 - Dynamic Fragments in Cached Web PagesAug 29, 2006. In this article we will explore various techniques for including dynamic fragments within cached web pages. This feature is described as Post Cache Substitution and provides a personalized experience for the end user, while taking advantage of the benefits of Caching.
  • 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.
  • 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
  • Poorman's iPod MP3 Player in C# and .NETJan 18, 2007. This article is an update to an article written by George Steeves on how to create an MP3 player using C# and .NET using the moon valley mp3p.ocx control.
  • Access Sharepoint Portal Server using Web Services in .NETFeb 05, 2007. This article discusses how we can leverage Sharepoint Portal Web Services to work with WSS in Microsoft .NET. The sample code used in this article shows how to access Lists Web Service to get the available lists in WSS. The sample code also shows how to add and update list items.
  • Auto-Update as a Simple Custom ControlMar 02, 2007. This article describes an easy way to implement automated page refreshes through the use of a custom control.
  • ASP.Net 2.0 AJAX Extension 1.0 ApplicationMar 21, 2007. This article will explain you in dept of creating AspNet Ajax-Enabled Application I have explained with the help of product management example, where you can add new product, edit, update & cancel the product related activity.
  • 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.
  • 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.
  • 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.
  • Using SQL Server 2005 system SP to change extended property values of database objectsAug 01, 2007. In this article, that is the logical continuation of the earlier published articles, I will show how you can update the value of an existing extended property or add a new extended property to a database object with the help of the system stored procedures of SQL 2005. The examples are written using T-SQL.
  • 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.
  • Generate XML based Resource Files on the fly in ASP.NET 1.x applicationsSep 11, 2007. If internationalization was not part of your application’s initial development cycle, but required to extend it globally at a later point of time, then creating resource files from all the UI elements is a very tedious & manual process in ASP.NET 1.x. The framework presented in this article saves a developer from manually updating the resources and keeps the resx files in sync with the webforms and user-controls by automatically generating the resx files.
  • 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.

About updating-table

NA

SPONSORED BY

Spire.Doc - Free .NET Word API
Use Spire.Doc to create, read, write, print, and convert word documents to OpenXML, RTF, TXT, XPS, EPUB, EMF, HTML, Image and PDF.
Download Free eBooks