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.
  • Connecting to a Text file using ADO.NET Apr 20, 2001. A simple step by step tutorial shows you how to connect to a text file using ADO.NET and C#..
  • Compute Feature of DataTableAug 01, 2001. The following code is for implementing least known feature of DataTable Compute() method.
  • 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.
  • Data Binding in DataGrid Control - Part 1Feb 05, 2002. When it comes to data-bound controls and database programming, DataGrid control is the most versatile , powerful and flexible control available in Visual Studio .NET.
  • DataGrid Customiztion Part-III:Implementing Search Feature in a DataBound GridAug 21, 2002. In this article, I will show you how to exchange two DataGrid columns by dragging and dropping.
  • 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.
  • Typed DataSets in .NETFeb 03, 2004. As all of we know, we can specify the data type when we create a DataColumn for a DataTable. This is to enforce the runtime type-safety for the column so that only data of specified data type can be stored in the column.
  • 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.
  • 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.
  • Dynamic Database Creation - 2May 06, 2004. This article explains how we can display data using Dataset and DataGrid control after the database is created.
  • Getting Data Providers Details in ADO.NET 2.0Aug 19, 2005. In ADO.NET 2.0, there is a new addition of DB provider factory classes, which allow developers to get the information about the data providers available (installed) on a machine.
  • 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.
  • New Dataset features in ADO.Net 2.0Aug 22, 2005. ADO.NET class libraries are used for accessing data from a wide range of data sources. One of the best features in ADO.Net is DataSet.Even though it was an exciting feature, performance was a concern with DataSet. Lets look some changes made to DataSet in ADO.Net in this article.
  • 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.
  • Generic 'T, K' Database ComponentDec 17, 2005. I have written a C# 2.0 (Visual Studio 2005), Generic <T, K> Database component, The component has simplified the architecture and the implementation by allowing me to keep the number of overloaded methods to a minimum.
  • Reincarnation of DataTable in ADO.NET 2.0Jan 09, 2006. The DataTable in ADO.NET 2.0 is a much improved and powerful than previous versions of ADO.NET. In this article, I will talk about new improvements and features added to the DataTable and how to use them in your applications.
  • Methods for Transforming data to a XML fileMay 16, 2006. This articles mentions different ways to tranform data to XML file.
  • 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.
  • Copying Data from one DataTable to Another using ImportRowJul 09, 2006. I recently have been engaged in an assignment where I had to copy large chunks of data from one DataTable to another. This article talks about how DataTable.ImportRow method may be more effective than copying direct rows.
  • .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.
  • 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.
  • Bulk Copy Operations in ADO.NET 2.0Oct 23, 2006. Bulk copying of data from one data source to another data source is a new feature added to ADO.NET 2.0. Bulk copy classes provides the fastest way to transfer set of data from once source to the other.
  • 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
  • Reading and Writing XML using XLinqJun 21, 2007. XLinq is a new API to work with XML using LINQ. XLinq is more flexible, simple, and faster programming model to read, write, manipulate, and traverse XML documents.
  • Select Items with Where in LINQ and C#Jun 21, 2007. This article shows how to select exact match and in between items from a collection using LINQ and C#.
  • Think in LINQ: Yahtzee Score Calculator Using LINQ TechnologyJul 23, 2007. This article revisits the yahtzee program I wrote in 2002 and reimplements scoring using LINQ technology. It compares the old way of scoring with LINQ and shows you the advantages of using LINQ.
  • 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.
  • Chapter 1: Introducing ASP.NetJan 07, 2008. This article tells the features and frills of Asp.Net 3.5 and .Net framework.
  • Functional Programming in C#: CurryingJan 13, 2008. Currying is a way to re-write a function with multiple arguments in such a way as it can be called as a chain of functions each with a single argument. This article covers using a few simple utility methods you can use to curry your methods.
  • Functional Programming with C#: Lazy CalculationJan 20, 2008. I ran across Mike Gold’s nice algorithm for finding primes using LINQ syntax and thought I’d use his idea as a base from which to demonstrate one of the more subtle features in functional programming: lazy calculation.
  • Chapter 1: Hello LINQFeb 06, 2008. This is an exert from Joseph C. Rattz, Jr.'s book Pro LINQ. Here you learn how to use Linq in your application and also depicts the benefits of using Linq.
  • Using LINQ to Objects in C#May 26, 2008. This article provides an introduction to employing LINQ to Objects queries to support a simple win forms application; the article addresses the construction of LINQ to Objects statements and then goes on to describe how one might use LINQ to Objects within the context of an actual application.
  • Convert a LINQ Query Resultset to a DataTableJun 24, 2008. After a long struggle I find out the way to convert a Linq Query resultset to DataTable object. The attached source code shows how to do it.
  • Cascading Deletes in LINQ to SQLJul 03, 2008. This article will discuss alternative methods for performing cascading deletes using LINQ to SQL. Cascading delete refers to the action of removing records associated by a foreign key relationship to a record that is the target of a deletion action.
  • Generic Data Access using LINQ to SQL and C#Jul 22, 2008. This article discusses the construction of a generic data access layer built on top of a LINQ to SQL implementation.
  • SQL Server Stored procedures and UDF within LINQ context-PartIISep 03, 2008. In the first article, SQL Server Stored procedures and UDF within LINQ context-Part I, I exposed 2 scenarios of how to deal with stored procedures using LINQ, in this second part, I will accomplish the task by demonstrating how to call a user defined function UDF using the same way adopted in the first part.
  • SQL Server Stored procedures and UDF within a LINQ context-Part ISep 04, 2008. In this two parts particle, I will give techniques of how to deal with stored procedures and user defined functions UDF from within a LINQ context rather than ADO.Net.
  • Silverlight Tutorial: Creating a data centric Web Application with DataGrid, LINQ, and WCF Web ServiceSep 15, 2008. This step-by-step tutorial is a guide for creating a silverlight Web application capable of submitting and retreiving data from a database.
  • LinqDataSource Control in ASP.NET 3.5Sep 16, 2008. This article shows that how to use LindDataSource Control in ASP.NET 3.5.
  • Secrets of Extension Methods: Part IIDec 23, 2008. This article explains how Extension Methods are used in LINQ.
  • Using Data in Silverlight 2 Applications - IFeb 05, 2009. In this Article you will learn how to create a data connection, a LINQtoSQL class and a WCF service.
  • SQL Server Compact and LINQFeb 13, 2009. In this article, I will cover how to access data in SQL Server Compact databases (.sdf file) using new development technologies such as LINQ.
  • Easy LINQ to SQL Based Master-Detail Editor C#Feb 22, 2009. This article describes a simple approach to creating a LINQ to SQL based master-detail view with the ability to save changes made to the data. With practically no coding involved, the application below will allow the user to edit the master record as well as the detail records.
  • LINQ FAQ for Newbie's Mar 05, 2009. In this article we will run through basics of LINQ and then see 5 basic LINQ queries which you will always need in your project for queries. While looking at the basics we will also try to learn what problem LINQ solves from the perspective of middle tier business objects.
  • SALT and PEPPER – 3 TIER and LINQMar 26, 2009. There is no pre-requisite (Oh yes even if you do not know LINQ this article will guide you) for this article J what I need from you guys is time to read this article. So block your 10 minutes and rest assured you will understand LINQ in a much better way.
  • Search and selection of data using LINQMay 27, 2009. In this article I will explain how you can use LINQ, when we should search and select some data according to parameters, defined by users.
  • An Introduction to LINQJun 06, 2009. LINQ stands for Language INtegrated Query. Means query language integrated with Microsoft .NET supporting languages i.e. C#.NET, VB.NET, J#.NET etc. Need not to write\ use explicit Data Access Layer.
  • Parallel Extension to LINQ Jun 18, 2009. This article gives you an idea how to utilize Parallel Extension to Linq or PLINQ.
  • One-Many and One-One relationship using LINQ to SQLJul 03, 2009. In this article we will start with a basic LINQ to SQL example and then see how we can implement one-many and one-one relationship using ‘Entityref’ and ‘EntitySet’. We have also attached a source which demonstrates the same in a practical manner.
  • Simple 6 steps to use stored procedure in LINQJul 08, 2009. This is an extremely small article which describes how to flourish LINQ objects using stored procedure. What provoked me to write this article is the ‘ExecuteMethodCall’ function which helps to execute stored procedures in LINQ. As this is a protected function it changes the way you architect the DAL using ‘DataContext’ class and probably you would like to tweak and consider some options here. You can see more details of it when you read through the steps below. I am writing a huge series of LINQ FAQ and these small articles form small sprints to complete the huge FAQ series. I hope you enjoy it.
  • CRUD operations using LINQ EntitiesJul 12, 2009. This is a pretty simple tutorial dedicated to LINQ newbie’s who want to learn how to do CRUD operations using LINQ entities. I am sure many experienced LINQ players would criticize me for such a mild article.
  • LINQ FAQ for Newbie's Jul 13, 2009. In this section we will run through basics of LINQ and then see 5 basic LINQ queries which you will always need in your project for queries. While looking at the basics we will also try to learn what problem LINQ solves from the perspective of middle tier business objects.
  • LINQ FAQ Part 2Jul 14, 2009. This FAQ article is dedicated to LINQ to SQL. In this article we will see a basic example of LINQ to SQL, how to define 1-1 and 1-many relationship using LINQ, how we can optimize LINQ queries, execution of stored procedures using LINQ and finally we will see a simple CRUD example using LINQ to SQL. For past some days I was running small sprint to complete this marathon I hope you will like this article.
  • How to improve your LINQ query performance by 5 X times ?Jul 17, 2009. LINQ has been criticized by many early adopters for its performance issues. Well if you are just going to drag and drop using DBML code generator I am sure you will land up in to mess. Try doing this make a simple LINQ to SQL project using DBML and see your SQL profiler, I am sure you will never like to touch DBML code generator again. In this article we will first look in to how LINQ queries are executed, and then we will touch base on how compiled LINQ queries can help us improve our application performance at least 5 times. My numbers can be 10% up and down as I had come to that figure using my environmental situations.
  • How to handle concurrency in LINQ to SQLJul 20, 2009. In this article we will touch base some important concepts of handling concurrency in LINQ to SQL.
  • ADO.NET Objects: Part IIJul 23, 2009. In this article I will explain about ADO.NET objects. This will help you in understanding them in an easy manner.
  • XML Diff and Patch using LINQ to Xml and LINQ to ObjectsJul 26, 2009. This article focuses on working with XML and how to get best out of LINQ to XML and LINQ to Objects. Focus of this article is to you show the power of LINQ to Xml and get you started on LINQ with practical examples.
  • Migration strategy for simple .NET classes to LINQ classesJul 27, 2009. This article will focus on how we can convert simple existing .NET classes in to LINQ enabled classes.
  • Introduction To linqJul 29, 2009. This article is a basic introduction to LINQ.
  • Using partial class, when working with LINQ to SQL Stored ProceduresJul 30, 2009. In this article I will explain how you can combine using of your own classes to DataContext (dbml file) and partial DataContext class, when working with LINQ to SQL Stored Procedure.
  • Creating and Saving XML Tree Using LINQ to XMLJul 30, 2009. This article explains how to create a XML Tree using LINQ. This will explain the Functional Construction way to create a XML tree.
  • LINQ FAQ Part3Aug 01, 2009. This is the third series in my LINQ FAQ series. In this series we will cover LINQ FAQ’s related to concurrency handling, compiled queries, CRUD implementation and mapping simple .NET classes with XML file configuration. I love to write articles in FAQ format for the only purpose that they are to the point and you can get to know more by reading less.
  • How to create 3 tier application using LINQAug 03, 2009. This article describes how to create 3 tire architecture project in LINQ to SQL.
  • Gridview paging and multiple row delete using checkboxAug 14, 2009. This article describes how to bind GridView using LINQ, dynamic paging and how to delete multiple rows using checkbox selection.
  • LINQ Deferred ExecutionAug 24, 2009. In this article we will see how LINQ defers the execution of the query till you request the results. Plus, learn how to execute the query immediately.
  • Best Practice No 4:- Improve bandwidth performance of ASP.NET sites using IIS compressionSep 16, 2009. Bandwidth performance is one of the critical requirements for every website. In today's time major cost of the website is not hard disk space but its bandwidth. So transferring maximum amount of data over the available bandwidth becomes very critical. In this article we will see how we can use IIS compression to increase bandwidth performance.
  • Understanding ADO.NET ComponentsOct 07, 2009. In this article I will explain about ADO.NET Components.
  • ASP.NET MVC Web Application Using LINQ to SQL ClassesOct 11, 2009. This article will demonstrate how to use an ASP.NET MVC Web Application using LINQ to SQL Classes.
  • Introduction to LINQ, Extension methods and Lambda ExpressionsOct 18, 2009. This article is an introduction of LINQ, Extension methods and Lambda Expressions. In my following articles, I will delve into more details.
  • Show/Delete/Edit data in WPF DataGrid using LINQ to SQL ClassesOct 29, 2009. This article will demonstrates how to Show, Delete, and Edit data in WPF Data Grid using LINQ to SQL Data Classes.
  • DataTable, DataColumn and DataRow classesOct 29, 2009. In this article I will explain about DataTable, DataColum and DataRow classes in ADO.NET.
  • DataTable in C#Nov 02, 2009. In this article, you will learn how to create an ADO.NET DataTable at run-time and use its properties and methods using C#.
  • Using DataSet, DataView, and DataViewManagerNov 09, 2009. In this article I will explain about DataSet, DataView and DataViewManager, Typed and Untyped DataSets.
  • Using PLINQ to Improve Learning AlgorithmsNov 30, 2009. PLINQ is a welcome addition to the .NET 4.0 framework, allowing us to operate on collection elements in parallel. This article examines the performance improvements of PLINQ over LINQ when doing heavy calculations on a large collection of genomes in a particular learning algorithm.
  • Using the Data Form Wizard in ADO.NETDec 17, 2009. In this article I will explain about using the Data Form Wizard in ADO.NET.
  • GridView using LINQ and Convert datetime to shortdate in LINQ.Dec 30, 2009. In this article you will learn how to create a hyperlink in GridView using LINQ and Convert datetime to shortdate in LINQ.
  • DataAdapter in ADO.NETJan 08, 2010. In this article I will explain about DataAdapter in ADO.NET.
  • Applications using Linq to SQLJan 10, 2010. In this article, I want to illustrate the principles, techniques and tools to develop applications using Linq to SQL after a deep research on this topic.
  • Updating the Database Using the Update Method in ADO.NETJan 11, 2010. In this article I will explain about Updating the Database Using the Update Method in ADO.NET.
  • Table and Column Mapping in ADO.NETJan 13, 2010. In this article I will explain about Table and Column Mapping in ADO.NET.
  • Binding using LinqDataSource controlJan 31, 2010. In this article, I will explain how to implement data binding techniques in Web applications using Language Integrated Query (Linq) and LinqDataSource control shipped with ASP.NET 3.5.
  • LINQ to SQL in Silverlight 3Feb 16, 2010. In this article we would see how can we use Linq to Sql ORM in Silverlight 3 Application for interactinig with SQL Server Database.
  • LINQ to XML Part 1 - XAttribute ClassFeb 21, 2010. In this article, I will give explanation on XAttribute class. This class is used to construct Attributes in XML Elements.
  • Using LINQ, when working with images in Web ApplicationFeb 21, 2010. In this article I will explain how you can use LINQ, when working with images in Web Application
  • LINQ to XML Part 3: Functional Construction of XML TreeFeb 22, 2010. This article will give an explanation on how to create a XML tree using Functional Construction method of LINQ to XML.
  • LINQ to XML Part 4: Different way of Parsing string to create XML tree Feb 22, 2010. In this article, I will show different way of parsing string to create XML tree using LINQ to XML.
  • LINQ to XML Part 5: Catching Parsing ExceptionsFeb 22, 2010. This is a very high level article which will explain how to handle exception in parsing XML using LINQ to XML.
  • LINQ to XML Part 2: (XElement Class)Feb 23, 2010. In this article I describe the XElement class. This class is used to construct XML Elements.
  • LINQ to XML in Silverlight 3.0Feb 23, 2010. This article will explain how to use LINQ to XML to read data from a XML file and bind that to Silverlight 3.0 DataGrid.
  • Working with DataTable Events in ADO.NET Feb 25, 2010. In this article I will explain working with DataTable Events in ADO.NET.
  • LINQ to Object Part #2: Filtering and SortingMar 04, 2010. In this article, I am going to show you how we can achieve filtering and sorting using LINQ to object.
  • LINQ to Object Part #1: ProjectionMar 06, 2010. In this article, I am going to show, how we could achieve projection in LINQ to object.
  • LINQ to Object Part #3: GroupingMar 08, 2010. In this article, I am going to show, how we could achieve grouping in LINQ to object.
  • LINQ to Object Part #4: Querying Non- IEnumerable collectionsMar 15, 2010. In this article, I am going to show, how we could apply LINQ to query non-IEnumerable<T> Collections.
  • Custom Functions for DatatableApr 01, 2010. Here is some custom function that can be useful while dealing with datatables.
  • LINQ to SQL Performance ConsiderationsApr 01, 2010. This article focuses on some of the performance issues while working with LINQ to SQL.

About LINQ-to-DataTable

NA

SPONSORED BY

C# Corner Chandigarh DevCon16
Chandigarh DevCon16 is a one-day Developer Conference where programmers, technologists, authors, and members meet, demonstrate, plan, and hang out.
Download Free eBooks