C# Corner

Resources  
  • View Relational Data in a DataGridMar 15, 2001. This article explains you how easy is reading a database and displaying in a grid using DataSet.
  • 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.
  • Complex Numbers ClassMar 20, 2001. This small example demonstrates using some of the interesting language elements of the C# language.
  • Working with Relational Data in ADO.NETMay 03, 2001. Working with hierarchal data was not that easy with the previous version of ADO.
  • Operator Overloading ExampleMay 14, 2001. The code uses the feature of Operator Overloading in C#. It shows how different operators are overloaded and can be used in a easy manner.
  • Super String in C#Aug 20, 2001. Today I realized that I miss those Visual Basic/Visual C++ type operators. You know the ones: Left, Mid, Right.
  • Operator Overloading in C#Sep 10, 2001. The Source code below shows how to use Operator Overloading in C#. Operator Overloading is pretty useful concept derived from C++ by C#.
  • 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.
  • Operator Overloading in C#Dec 03, 2001. All unary and binary operators have pre-defined implementations, that are automatically available in any expressions. In addition to this pre-defined implementations, user defined implementations can also be introduced in C#.
  • .NET Math Expression ParserApr 22, 2002. This is a math expression parser written in C#, which evaluates mathematical expressions.
  • Comparison of C# with Java: A Developer PerspectiveMay 29, 2002. The .NET is a language and operating system (on Windows as of now) independent platform pretty similar to Java.
  • Using Genetic Algorithms to Design Logic Circuits in C#Feb 05, 2003. The article goes to explain that GA (Genetic Algorithms) have been used by various programmers to come up with 15 previous patented inventions + (and here is the startling part) some new ones! I can see the running joke in the patent office now.
  • 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 : Using SQL with C#: Part IXJan 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 XIIJan 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 : using SQL with C#: Part XJan 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 VIJan 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 :Using SQL with C#: Part VIIIJan 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 : using SQL with C#: Part XIJan 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.
  • Real Life SQL and .NET: Part IIJan 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 VJan 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 : SQL Subqueries: Part VIIJan 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.
  • Directory Services Vs RDBMSFeb 06, 2004. When storing user information, developers can have two choices to choose from - Active directory and a relational database. This article sheds lights on usefulness of each of these and when to use one over the other and vice versa.
  • 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.
  • Constructing a DataTable using 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.
  • DataView 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.
  • Data Binding in DataGrid Control using 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.
  • DataSet 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.
  • DataReader 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.
  • DataAdapter 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.
  • DataTable 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.
  • SQL Server Reporting ServicesFeb 25, 2004. SQL Server Reporting Services is a comprehensive, server-based platform for creating, managing, and delivering reports that contain data from relational and multidimensional data sources. This article explains the features that are supported by SQL Server.
  • An introduction to Matisse, a post-relational database for .NET - Part 1Mar 06, 2004. When it comes to database for .NET, there are several options in addition to the well known ones such as SQL Server or MySQL. One of them is Matisse, a post-relational database by Matisse Software.
  • 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.
  • SQL Server Reporting ServicesFeb 25, 2005. SQL Server Reporting Services is a comprehensive, server-based platform for creating, managing, and delivering reports that contain data from relational and multidimensional data sources. This article explains the features that are supported by SQL Server.
  • 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.
  • Writing C# 2.0 Unsafe CodeFeb 23, 2006. We will see that C# allows suspending the verification of code by the CLR to allow developers to directly access memory using pointers.
  • AndAlso & OrElse Operators in C#Mar 13, 2006. Hi all, in a very short note I am trying to explain some interesting logical operators in C# and their VB.NET counter part. You must ware of the differences between these operators for a better usage of them.
  • 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.
  • F# Types and the Forward Pipe OperatorMar 22, 2008. Looking at F# Types (Especially Functions) and the Forward-Pipe Operator.
  • Cursors in Database Management SystemsJul 23, 2008. This article is intended to show the principles and uses of cursors in relational database management systems. We’re going to discuss how cursors are implemented in Microsoft SQL Server and Oracle database and how you can use it in your applications.
  • How to Use the EXCEPT and INTERSECT Operators in SQL Server 2005Sep 28, 2008. This sample shows how to use EXCEPT and INTERSECT operators in SQL Server 2005.
  • Using NHibernateMar 04, 2009. NHibernate is an open source project for Object/Relational mapping to persist objects in a relational database. This article is a step by step tutorial on how to work with NHibernate.
  • Using PostgreSQL from Microsoft.NETJun 04, 2009. PostgreSQL is one of the most important relational database systems in the open source world. It is released under a BSD style license. I’ve seen a few documents talking about the development of .NET application with PostgreSQL as the back-end server. That’s why I’m writing this article to illustrate how you can access to the PostgreSQL database system using C#.
  • Type Conversions in C#Jun 04, 2009. In this article I will explain about one of the main topics in C# - Data Types. You will also learn about the value and reference types, type conversions and other features related to data types.
  • Wildcards in SQL Server 2005Oct 27, 2009. SQL wildcards are used for searching data’s in a database, which were used with LIKE operator.
  • Expressions and Operators in C#Nov 19, 2009. In this article I will explain you about expression and operator.
  • Overloading in C#Dec 01, 2009. In this article I will explain you about overloading in C#.
  • SQL Query Optimization FAQ Part 1 (With video explanation)Feb 02, 2010. In this article we will first try to understand what is a SQL plan, how is it created and then we will move towards understanding how to read the SQL plan. As we read the SQL plan we will try to understand different operators like table scan, index seek scan, clustered scan, RID lookup etc. We will also look in to the best practices associated with clustered and non-clustered indexes and how they function internally. We will practically see how indexed views increase performance and in what scenarios we should use the same.
  • As Operator in C#Feb 24, 2010. The As operator in C# is used to convert from one type to another. You can use casting to cast one type to another but if you apply casting on incompatible types, you will get an exception.
  • Is Operator in C#Feb 24, 2010. The Is operator in C# is used to check if a type of an object is compatible with the other type. If type is not compatible, you will also see C# compiler will through an error in Visual Studio IDE.
  • Select and SelectMany: LINQ projection operatorAug 16, 2010. Projection transforms the query result into the form defined by the developer. There are two projection operators in LINQ
  • LINQ Operators and Lambda Expression - Syntax & ExamplesSep 08, 2010. LINQ is a cool feature in C# 3.0. Most of the developers are struggling for the syntax and examples. Here I have collected various examples for each operator in LINQ and the equivalent Lambda Expressions.
  • Different Kind of Operator OverloadingOct 24, 2010. In this article we will learn how to use Different Kinds of Operator Overloading.
  • Connection Strings for SQL Server 2005Dec 20, 2010. SQL Server 2005 includes native support for managing XML data, in addition to relational data. It introduced MARS (Multiple Active Result Sets), a method of allowing usage of database connections for multiple purposes. It also introduced data mirroring and DMVs (Dynamic Management Views).
  • Oracle Connection String using C#Dec 21, 2010. Oracle is a powerful relational database management system that offers a large feature set. Along with Microsoft SQL Server, Oracle is widely regarded as one of the two most popular full-featured database systems on the market today. Oracle is made up of a set of processes running in your operating system.
  • Connection strings for IBM DB2Dec 21, 2010. IBM DB2 primarily runs on Unix, Linux IBM I, z/OS, and windows server. It is a relational database management system that comes in a variety of versions, running on devices ranging from handhelds to mainframes.
  • Connection Strings for SQL Server Compact EditionDec 22, 2010. SQL Server Compact Edition (SQL CE) is a compact relational database produced by Microsoft for applications that run on mobile devices and desktops.
  • Linq Aggregate OperatorsJan 15, 2011. LINQ provides many operators that support making various types of queries with any type of object.
  • SQL Server Default/System DatabasesFeb 04, 2011. SQL server is a relational model database server designed for client/server use, It is a computer application used to create desktop and maintains a set of system-level databases.
  • Windows Mobile Utility on the Move, (Works For Indian Region only)Mar 01, 2011. This application can be used by any user to search the STD Code, Mobile operators circle easily throughout India. It's a very handy application which runs on Windows Mobile 6.1 & 6.5 professional devices.
  • CRUD Operations on Relational Data (Multiple table) using RIA with Silverlight 4Mar 02, 2011. Relational/Hierarchical data and CRUD operation against them using RIA Service with a real time example.
  • String Concatenation and Scope Resolution Operator in SQL Server 2008 R2Mar 03, 2011. Here you will learn String Concatenation and Scope Resolution Operator in SQL Server 2008 R2.
  • Type casting with is and as operator in C#Mar 21, 2011. Many developers are casting using the "is" operator. We also have the "as" operator for type casting.
  • Oracle: JDBC (Java Database Connectivity)Apr 20, 2011. JDBC (Java database connectivity) is the specification of the standard application programming interface that provides a standard library for accessing relational databases like MS-Access, Oracle or Sybase.
  • WPF-Validations On All Database OperationsApr 27, 2011. This article shows how to use validation whenever a user enters data. By using validation you will stop entering the wrong data into the database and avoid exceptions.
  • SQL Azure ArchitectureMay 17, 2011. SQL Azure, which resides in the Microsoft Data Center, provides relational databases to applications with four layers of abstraction.
  • Select Query With Logical Operator in a Mongo Database Using C# DriverMay 23, 2011. In this article I will describe how to do a select query in a Mongo database using C# driver.
  • Fetching Mobile Operator Name in Windows 7.1 Phone [Mango]Jun 10, 2011. Here you will see how to fetch the mobile operator's name in Windows 7.1 Phone.
  • SQL SERVER 2005 : Using Special Characters (Wild Characters) in LIKE And NOT LIKE OperatorJun 24, 2011. Special Characters are used for finding a specific character string using the LIKE operator in SQL SERVER.
  • The Is and As Operators in C#Jul 05, 2011. In this quick article you will take a look at the "is" and "as" operators in C#.
  • Silverlight 4 LINQ to SQL Classes in VS 2010Jul 14, 2011. LINQ to SQL is an ORM (stands for Object Relational Mapper/Mapping), which provides a data access layer for the application.
  • Types of Operators in F#Jul 15, 2011. This article demonstrates operators; Infix operators, Prefix operators and types of operators. Have a quick review for learning operators.
  • Concept of Sequence in F#Jul 20, 2011. This article is a demonstration regarding Sequence, Sequence comprehension, Range expression and Sequence Module aggregate operators. It also contains lazy evaluation of Sequence elements. Have a quick review to learn.
  • Populating the TreeView Control With XMLDataSourceSep 09, 2011. The TreeView is a .NET DataBound Control which is used to display hierarchical data. It can be bound with the The Nodes of this control with the help of XML, tabular or Relational Data. In this example we use XMLDataSouce to bind the TreeView.
  • Working with Hibernate - Display , Insert, Update and Delete in JAVASep 28, 2011. Hibernate is a framework to implement object relational mapping. It provides facility to persist the state of object. Here you will learn how to Display, Insert, Update and Delete records using Hibernate.
  • Windows Azure - SQL Azure - Using ADO.NET Entity Framework - Creating DataModelOct 23, 2011. ADO.NET Entity Framework is an ORM (Object Relational Mapping) framework from Microsoft. In this article we have explored the scope of using ADO.NET Entity Framework on SQL Azure.
  • LINQ to XML in a NutshellNov 01, 2011. Data may exist in many forms.  You may have data in relational tables residing on a relational database or portable data in the form of XML.  Since data exists in many forms, obviously there are many ways to manipulate or access it.  One of the most popular ways of sharing data is as XML.
  • BabyCacheNov 02, 2011. As you surely know, a cache is a component that stores data as it were a little database. Original data are always stored in a file, typically a relational database, and accessing it every time you need them could negatively affect your overall application performance.
  • Working With SQL JSTL TagNov 28, 2011. The JSTL SQL tag library is used to access the relational database used in the JSP pages. The SQL tags are used for the rapid prototyping and developing web applications.
  • Variables & Operators in MySQLNov 30, 2011. In this article we will learn how variables & operators are used in MySQL.
  • Abstract Factory PatternDec 02, 2011. In this article I would like to explain the Abstract Factory pattern. This pattern is essential for learning the Factory Method and Bridge patterns.
  • Working with Union in MySQLDec 09, 2011. This article describes the functionality of the union operator in MySQL.
  • MySQL Operators And Comparison FunctionsJan 12, 2012. Here we will show how to work with the Operators and Comparison Functions in MySQL
  • Entity Framework: Part 1Jan 18, 2012. The Entity Framework facilitates the development and conceptual use of application models for development instead of directly using relational storage schema.
  • Operators in PHPFeb 13, 2012. In this article you will see the types of operators available and how to use them in PHP.
  • SQL Limit in PHPMar 05, 2012. In this article you will see, how to execute a LIMIT operator of mysql in PHP. 
  • Concept of Join in SQL ServerMar 13, 2012. In this article we are show different types of joins in SQL Server. A Join in SQL is used to combine two or more tables. We use the Join operator to gather the data in a single query.
  • Working with a Local Database in Windows Phone 7Apr 25, 2012. In this article we are going to see the usage of Isolated Storage by creating a local relational database and save the data locally that are accessible to the specific Windows Phone 7 application.
  • How to use Operator Overloading in C#Jun 02, 2012. In this article, we will discuss about the operator overloading in C#. It means that we are defining the operator for a class.
  • Compound Operators in SQL Server 2008Jul 25, 2012. In this article you will learn some basics about Compound Operators of SQL Server 2008.
  • Overload Operator Using C#Aug 16, 2012. In this article we will try to understand how to overload operator == for our convenience.
  • Asynchronous Programming in Windows Store AppAug 21, 2012. In this article I will explain how to use await operator for asynchronous programming in Windows Store Apps.
  • Object Relational Mapping (ORM) Using NHibernate - Part 1 of 8Sep 24, 2012. To establish the ideas of Object Relational Mapping Internals, Nhibernate fundamentals, Intemediate and Advanced coding concepts using NHibernate more clearly (for me and hopefully to readers).
  • Predicates in SQL Server 2012Sep 27, 2012. This article demonstrates use of predicates with SQL queries in a SQL Server database.
  • Object Relational Mapping (ORM) Using NHibernate - Part 2 of 8Sep 28, 2012. This article provides examples of mapping collections of Value Types.
  • Object Relational Mapping (ORM) Using NHibernate - Part 3 of 8Oct 08, 2012. Firstly in part 1 of this article series, it had been shown that in ORM, while mapping a one to one association between objects to their corresponding tables, the primarykey of one table is posted as a foreign key of the other table. But in ORM, mapping a one to many association is done differently
  • Object Relational Mapping (ORM) Using NHibernate - Part 5 - A of 8Oct 16, 2012. This is Part 5A of the article series, which concentrates on Many-to-Many Entity Association with a commonly used example but the model and code is a little different.

About Relational-operators

NA
File APIs for .NET
Aspose are the market leader of .NET APIs for file business formats – natively work with DOCX, XLSX, PPT, PDF, MSG, MPP, images formats and many more!
Download Free eBooks