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.
  • FileSharing Server in C# and .NETFeb 01, 2001. The server acts as a File Sharing Server, it listens for multiple clients to connect to it. The Clients have a option to either Download any of the Files available with the server for download.
  • 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.
  • Text to HTML ParserApr 05, 2001. If you have been into developing Web Applications then you might have at many times experienced that when you display multiple lines of data from a database you loose the spacing or formatting between multiple lines of data.
  • Stock TrackerJul 18, 2001. This program is a utility to track stock quotes for multiple symbols.
  • 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.
  • Multiple Inheritance in C#Aug 29, 2001. Can you inherit from multiple classes in C#? Simply put, this cannot be done. However there are ways around it. From a design perspective you must ask yourself, will a Class fully represent an object?
  • 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.
  • Exception Handling in C#Oct 17, 2001. Exception handling is a builtin mechanism in .NET framework to detect and handle run time errors.
  • 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.
  • Deevloping a Banking System using VS.NET and Windows FormsDec 26, 2001. This article also focuses on deploying multiple windows forms and shows how to navigate between them.
  • Microscopic Discussion in ClassesJan 02, 2002. This article is going to take a microscopic view of classes, in terms of Inheritance(I) , Multiple Inheritance(MI) and Circular Base Classes (CBC).
  • Developing MDI Applications in C#Jan 16, 2002. In this article, I'll explain how to write MDI applications using C# and Windows Forms.
  • 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.
  • Loading XML File in a TreeView Control using MultithreadingApr 19, 2002. There are many occasions when programmers need to develop multithreading applications, which can load big files in the background and let the user do data entry or other jobs without any interruption. In this article, I'll show you how to create multiple threads to load multiple files.
  • Viewing Multiple ImagesMay 08, 2002. I'm writing this article in response to a question on discussion forums, How do I view multiple images on top of each other?
  • Windows Services Admin: Control Your Windows ServicesMay 20, 2002. In this article, we will create an application to control Windows services on our local computer as well as on remote computers. You can simultaneously Stop or Start multiple Services on the local computer or on the specified remote computer.
  • Writing a Single Event Handler for Multiple ControlsJul 22, 2002. Writing a Single Event Handler for Multiple Controls by Giuseppe Russo. Jul 22, 2002. I have noticed that in many articles, I read, people use a longer method of clearing many textboxes, as well as handling more than one control at the same time.
  • 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).
  • Using Multiple Expressions to derive the Pythagorean TheoremNov 06, 2002. In this article, we will talk about a simpler GA technique for manipulating symbolic expressions and also use it to derive the Pythagorean equation.
  • Client Server Multithreaded ApplicationNov 08, 2002. This is simple Client/Server (multi-threading) program that transfers data. Server can handle multiple clients.
  • 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.
  • MDI Image Viewer with Drag-Drop SuppportNov 21, 2002. MDI Image Viewer with Drag-Drop Support by Sergio Pinon. Nov 21, 2002. The attached source code project is an MDI Image Viewer that not only let you view multiple images simultaneously, it also supports drag and drop feature. To view one or multiple files, just drag some images from the Windows Explorer and drop on this program.
  • 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.
  • 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.
  • Modal Popup Dialog Window in ASP.NETSep 15, 2003. This sample show you how to create modal popup dialog window in ASP.NET that passes and returns multiple parameters.
  • Using Genetic Algorithms to Generate Evolutionary Art in C# and .NETOct 10, 2003. In this article we will experiment a bit with genetic algorithms and creating fitness functions that produce art on a Windows Form.
  • Migrating COM/DCOM Applications in Microsoft .NET FrameworkDec 09, 2003. In the current Internet scenario, various classic applications run on multiple networks. These applications could have been written using different languages like Visual Basic, Visual C++. For example, a retail organization would have different systems, such as an inventory management system, a bill of material systems, and a general ledger system, all implemented using various technologies available for application development. These systems need to be integrated to form a higher-level enterprise information system for an organization.
  • Working with Windows TabControl with C#Dec 16, 2003. Windows TabControl is a useful control that allows you display multiple dialogs tabs on a single form by switching between the tabs. In this tutorial, I will explain how to create and use a TabControl in your Windows applications with C#.
  • 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 .NETFeb 20, 2004. ADO.NET was designed to meet the needs of this new programming model: disconnected data architecture, tight integration with XML, common data representation with the ability to combine data from multiple and varied data sources, and optimized facilities for interacting with a database, all native to the .NET Framework.
  • DataSets in Microsoft .NET - Part 2Mar 09, 2004. This article explains sorting, searching and filtering support provided by dataset and data table objects.
  • Multilingual Applications in .NETMar 24, 2004. This article explains the basic understanding on different methods of developing multilingual applications in .NET. Here emphasis is given on handling multiple languages using resource files.
  • Combine Multiple Streams in a Single .NET Framework Stream ObjectApr 11, 2004. This article represents a simple Stream class whose data is based on the number of another .NET Framework streams.
  • 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.
  • Creating a Managed Automated Information Agent(mBot)Aug 16, 2004. mBot manages multiple RTC Client objects and exposes interfaces to them via .Net Remoting and .Net Web Services so that they can be managed and used remotely by other .Net applications or from entirely different platforms such as a Java J2EE/SOAP application like Jabber running on Linux or Windows.
  • Handling Oracle Max Open Cursor Error when Fetching Multiple Rows in ADO.NETAug 18, 2004. When working with Microsoft technologies, MS SQL Server comes out as a natural choice for the database. While it is a fact that .NET Framework has extensive support for SQL server, when you work with other databases like Oracle the situation might turn out to be a little more tricky than it is with SQL Server.
  • Crystal Reports - Geterogeneus databases: SQL Server, Oracle, Unidata, BtrieveAug 24, 2004. Crystal Reports is the most flexible tool on the market and it has market recognition. Multiple software vendors offer Crystal Reports as the main reporting tool: Microsoft, Best Software, Oracle to name a few. In this article, you learn some tips on using Crystal Reports versus other options.
  • Microsoft Application Center TestOct 13, 2004. Application Center Test (ACT) stress tests Web servers and analyze performance and scalability problems of Web applications. ACT simulates a large group of users by opening multiple connections to the server and rapidly sending HTTP requests. It also supports several other authentication schemes and the SSL protocol, making it ideal for testing personalized and secure sites.
  • How to generate unique integer IDs across multiple systemsNov 30, 2004. This article show to generate unique integers across environments. Generally repeating IDs in different environments are not a problem, but once in a while you need to migrate something from dev to staging, or from staging to production.
  • Multiuser XML 'Database' Web ServiceDec 01, 2004. This article shows multiple users to have simultaneous access to the document just like a database. The critical thing is how can we load a resource once and how can we have multiple users access it without collisions.
  • OOPS Concepts and .NET Part 2: Inheritance, Abstraction, & PolymorphismJun 22, 2005. The following article is the second of a three-part article series that presents definitions and samples for different Object-Oriented Programming (OOP) concepts and its implementation in .NET. The first part examined the concepts of classes, objects, and structures. This part examines the concepts of inheritance, abstraction, and polymorphism. The third and last part will examine the concepts of interface, multiple interface inheritance, collections, and overloading.
  • OOPs Concepts and .NET Part 1: Classes, Objects, and StructuresJun 22, 2005. The following article kicks off a three-part article series that will present definitions and samples for different Object-Oriented Programming concepts and its implementation in .NET. The first part will examine the concepts of classes, objects, and structures. The second part will examine the concepts of inheritance, abstraction, and polymorphism. The third and last part will examine the concepts of interface, multiple interface inheritance, collections, and overloading.
  • 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.
  • MDI (Multiple Document Interface)Jul 05, 2005. This tutorials describes about Multiple Document Interface.
  • Selecting and Highlighting Multiple Columns in a Data GridJul 21, 2005. This article shows how to select multiple columns in a DataGrid and highlight the columns selected.
  • Multi Selection of DataGrid Rows without Ctrl ClickJul 31, 2005. This article shows how to select multiple rows in a DataGrid without using CRTL.
  • Notepad.NET - Printing a Multiline Textbox in C# and .NETJul 31, 2005. Notepad.NET is a file text editor that allows you to edit multiple files at the same time. It also has a few nice features not included in notepad, such as print preview and a most recently used file list. This article describes how printing is performed in this utility.
  • Asynchronous Data Access using Callback ModelAug 17, 2005. The problem with the ADO.Net 1.x is that one thread has to wait for the other thread to complete. So to overcome this problem Microsoft has introduced Asynchronous data access, through which one can execute multiple threads at a time.
  • 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.
  • Introduction to Multithreading in C#Oct 06, 2005. This article is a complete introdution to threading. It explains what is a thread and why it is used in programming. It also talks about common problems with threading, and how to begin writing thread safe code.
  • ASP.NET 2.0 MultiView ControlOct 09, 2005. A View control is a container of multiple controls and a MultiView control works as a container of groups of View controls. In this article, I will discuss how to work with View and Multiview controls.
  • 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#.
  • 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
  • C# using the Proxy Pattern to Define RelationshipsJan 23, 2006. I was recently working on a 2.0 Framework project where we had many types of related objects. However, we needed to ensure that there were not multiple instances of the same object in memory. Usually the GOF Proxy pattern is used to hide or control access to an object, but we can also use it to define relationships between objects.
  • 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.
  • Managing Distributed Transactions with ADO.NET 2.0 using TransactionScopeApr 15, 2006. This article describes how to manage distributed transactions that can span multiple data sources in a Microsoft .NET application.
  • 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.
  • Multiple Form-Based Programming in ASP.NetJun 05, 2006. This article shows how to use multiple forms in ASP.Net page.
  • Multiple Masters Pages in ASP.NET ApplicationJun 16, 2006. This article will explain that how can we use multiple master pages in our application and can access properties at run time.
  • Building applications with DLinq DesignerJul 01, 2006. DLinq designer is the visual design surface to create the entity objects and bound the controls to the dlinq objects with relationships. We can easily create the windows form using the designer. The developer need not take more time to design the User Interface. The designer itself suggests you the controls suitable for the selected fields.
  • Using LINQ in Visual Studio 2005Jul 03, 2006. LINQ (.Net Language Integrated Query) is the general-purpose standard query operators that allow traversal, filter and projection operations to be expressed in a direct yet declarative way in any .Net programming language.
  • .NET Language Integrated Query for XMLJul 17, 2006. This is the overview of .NET Integrated Language Query for XML. This Article explains some of the features of XLINQ with example.
  • Tip: How to use Multiple Page Headers in Crystal Reports?Jul 21, 2006. Recently, I came across a problem in Crystal Reports. I wanted to display a separate page header on the first page of the report than the rest of the page.
  • 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.
  • Dynamic Data Grouping using MS Reporting ServicesAug 07, 2006. This article shows to generate multiple outputs from a single physical report template using dynamic data grouping.
  • 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.
  • Generating a Report from Multiple Data Sources in Crystal ReportsOct 23, 2006. If you have to create a report in Crystal Reports from multiple data sources or provide multiple views of the data, you may find sticky situations because CR does not allow you to have multiple Detail sections in a single report.
  • 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.
  • Using Genetic Algorithms to Determine Calculus Derivative Functions in C# and.NETNov 28, 2006. This article describes how you can use genetic algorithms in .NET to determine derivatives of mathematical functions. The program uses an algorithm called Multiple Expression Programming (MEP) inside the genomes to exercise a function tree.
  • Processing Command Line ArgumentsDec 27, 2006. This article describes an approach to processing multiple command line arguments.
  • Access Row of a file Random bases using C#Jan 01, 2007. In this aritical, we will look how to get a row of a file which contains multiple rows randomly.

About LINQ-for-Multiple-Tables

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.
Download Free eBooks