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.
  • 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.
  • Rotation SampleApr 24, 2001. After reading Mike Golds article on transforms I thought I would get things moving a bit!
  • Tic Tac ToeJul 16, 2001. TicTacToe is a demonstration of the AI game playing minimax algorithm. The game plays out every possible combination of moves from each position and consequently is unbeatable. This example uses .NET Beta 2 and was written using a text editor.
  • Eater Game in C#Jul 31, 2001. This is a simple game written in C# in which the user moves a packman like player around the form and gobbles up red dots. The object is to get all the dots in as quick a time as you can.
  • Move Grid PuzzleAug 15, 2001. This is a console based application the user will be prompted for move such as L-Left, R-Right, U-Up, D-Down, E-Exit.
  • 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.
  • Mouse and Key EventsSep 11, 2001. This article explains the usage of key and mouse events. The following code shows you how you can read mouse position on mouse move.
  • 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.
  • CartWheel Man - Animating GraphicPathsNov 27, 2001. This simple application illustrates how GraphicsPaths can be animated to look like something is moving across the screen.
  • 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.
  • An Animation Component using C#Feb 08, 2002. Sometimes its desirable to get those graphics moving a bit and this article show the control to implement it.
  • 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).
  • Eater Game II - The Stone MazeOct 02, 2002. This program combines the designs of the Eater Game and the Maze Generation Program to create a more challenging game, Eater Game II. In this game, you move a pacman-like character through a maze and eat as many stones as you can before time runs out. You have a minute and a half to try to eat stones before the pac-man simply freezes-up and accepts his quota of stones.
  • 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.
  • Implementing Prim's Algorithm using GDI+Dec 31, 2002. Prim's algorithm is an algorithm used in the graphics development to calculate the shortest route in a network when an object is moving from a source node to the destination node.
  • 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.
  • Creating Extensible and Flexible Hosted Applications: Part 1Apr 02, 2003. Moving from procedural programming languages such as ASP and Visual Basic to .NET object-oriented languages enables programmers to build systems that are highly extensible and flexible.
  • 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.
  • Meet Microsoft .NETSep 30, 2003. Before writing applications in C#, understanding the .NET is very important. Usually, beginners who are moving to C# don’t care about understanding .NET? In this article, I will try to explain .NET in general and its components.
  • Migrating from ASP to ASP.NETJan 05, 2004. This document covers some of the more powerful features that can simplify Web development while providing a more scalable, stable, and productive environment.
  • 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.
  • Moving to ASP.NET: Part 1Aug 24, 2004. The attached white paper, Moving to ASP.NET, examines trends in the adoption of ASP.NET, and provides guidelines for selecting the migration approach that best meets specific business needs.
  • Moving C Structures into .NET with Custom MarshalingDec 17, 2004. Microsoft provides several attributes for marshaling C to C#. In our example we will take the case where we have hundreds of structures and only a few API calls, so we only need to generate the marshaled code for the structures.
  • Sokoban Pro Game in C#Jan 21, 2005. Sokoban Pro is a modern version of the classic Sokoban puzzle game. The game rules are extremely simple, yet the game is very challenging and addictive. The rule of the game is to move all the boxes in the right places. You can only push a box, not pull.
  • Joystick ControlMay 13, 2005. In this article and the attached source code project written in C# and Windows Forms, the author shows how to build a Joystick control that allows an object to move via the joystick control.
  • 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.
  • Examining Organizational Workflows under the hood of .NETAug 18, 2005. In this article we will firstly we will see what organizational workflows are and how they fit into organizational hierarchy and make information move within this hierarchy.
  • 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.
  • Migrating from Java to C# Oct 03, 2005. Microsoft has created a tool called Java Language Conversion Assistant (JLCA), which automatically converts Java code into C# for developers who want to move existing applications to the .NET Framework.
  • 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).
  • 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.
  • 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.
  • Packing List for the Pocket PC in the .NET Compact FrameworkNov 10, 2006. This article demonstrates a pocket pc packing list application to help you track moving inventory. The application is written in C# for the .NET Compact Framework (1.1) and shows you how to overcome some limitations in the framework such as scrolling a form and searching nodes in XML.
  • 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
  • Animating your XAML AppsApr 05, 2007. This article will describe how to do 2D Animation using XAML Scripts. In the article we will describe how to implement transforms on XAML shapes and then how to move them around in your form.
  • .NET and Active DirectoryApr 19, 2007. This article outlines connecting to AD from .Net using ADO and System.DirectoryServices and also forming a unique ID from AD, moving entries from AD to a database and forming AD queries (also date formatting for AD).
  • Introduction to XNA: The Microsoft 2D and 3D Game Development PlatformApr 20, 2007. This article introduces you to the XNA Framework that makes game development easier than it ever was before. This sample features a star trek ship which you can move around the screen and shoot at the enemy Klingon Ship. The demo comes complete with authentic sound.
  • Star Trek -Part II: Adding moving 3D Objects to your XNA GameMay 06, 2007. This article describes how to work with 3D Objects in your XNA game. In the article you will learn how to add a rotating planet to Star Trek to enhance the background. It also talks about how to add text to your game.
  • 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.
  • 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.
  • 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.
  • Ajax AnimationExtender ControlFeb 01, 2008. In this article we are going to discuss about AJAX AnimationExtender control. It provides good animation effect such as moving an ASP Control to a new place, resizing it, modifying its color, or making it fade in or fade out. In this article I m going to use fade in or fade out animation.
  • 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.
  • AJAX DragPanelExtender ControlFeb 26, 2008. AJAX DragPanel allows you to move your panel one place to another place around a Web page. This article and attached code shows how to use DragPanelEtender control in ASP.NET 2.0.
  • 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#.
  • Save TreeView Nodes ExpansionJun 24, 2008. We frequently use an ASP.NET TreeView as a navigation menu. This works well on a single page but if you include the control on a Master Page, it looses its expansion state as you move from one content page to another.
  • 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.
  • 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#.
  • Area sensitive helpAug 27, 2008. This article tells you how to create a help window which appears when your mouse moves on a particular web page area.
  • 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.
  • Introduction to Page Layout using DIV elementFeb 03, 2009. This article explains about benefits of using DIV tag over TABLE in page layout design.
  • 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.
  • 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
  • Silverlight FAQ part 2 (Animations and Transformations)Jun 23, 2009. This FAQ is completed dedicated to animations and transformations using Silverlight. The tutorial starts with animation basics like timelines and storyboard. Later the article moves ahead to talk about different animations supported and we finally end the tutorial with a simple rectangle animation.
  • Rows.Count, Column.Count and IEnumerator using ADO.NET with C# and Database ServerJul 29, 2009. In this article I will explain you how to make a SQL database connection and show information in data grid. Count the number of rows and columns in the table and show the records in text boxes using IEnumerator interface.
  • Swapping GridView rows Up and DownAug 22, 2009. In this article I am posting code about swapping GridView rows Up and Down using Data Tables.
  • WPF Animations Part I- Color AnimationSep 07, 2009. WPF is a new framework that has many advanced capabilities. Animations are one of those capabilities, where an object can be animated via rotating, stretching, scaling, moving it across the screen, changing its color, etc. In this article I am going to show color anmiation on a coltrol.
  • Common Table Expression(CTE) in Sql server 2005Sep 14, 2009. This article explains about Common Table Expression(CTE) in sql server 2005 with sample sql queries.
  • SQL Server Important System Views and TablesSep 21, 2009. This article list out the important system tables, stored procedure and views.
  • Clearing the Console Screen using API Sep 27, 2009. Learn how to clear the Console screen using Win32 API calls. Also learn additional techniques like how to clear a specific portion of the screen or to move it.

About Move-table

NA

SPONSORED BY

Custom Software Development
MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.
European SharePoint Conference