C# Corner

Resources  
  • Building the Middle Tier in the Microsoft .NET FrameworkJan 16, 2000. Building the middle tier in the Microsoft .NET Framework.
  • 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.
  • Database Explorer : Part 2Jan 22, 2001. Attached is a C# program which is a enhanced version of the previous article on ADO.NET.
  • ADODataReader- Writing DataSets to XMLFeb 04, 2001. This file uses ADODataReader and other objects to write DataSets to XML and filling data from the XML files.
  • Schedule Program Using C#Feb 22, 2001. The Scheduling program consists of three main classes. The Form, the DatabaseController used to read and write scheduled events into the database and RowData which corresponds to data extracted from a row in the database.
  • 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.
  • 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.
  • 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.
  • ADO.NET DataSet ProgrammingMar 20, 2001. A sample project shows you how to add, edit, delete, navigate, save records in a database using DataSet.
  • Developing Web Applications in VS.NET Mar 29, 2001. This tutorial describes about Step-by-step tutorial guides you towards developing your first web application.
  • 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#..
  • Working with Relational Data in ADO.NETMay 03, 2001. Working with hierarchal data was not that easy with the previous version of ADO.
  • SQLDataReader Vs. DataSetMay 11, 2001. To compare and contrast SQLDataReader and SQLDataSetCommand.
  • Working With OleDb Data Adapters Jun 19, 2001. This step by step tutorial guides you to create your database applications using OleDb Data Adapters in VS.NET.
  • Working with OleDb Data AdaptersJun 20, 2001. This step by step article guides you to create your database applications using OleDb Data Adapters in VS.NET.
  • Displaying data in a ListBox Web ControlJul 06, 2001. Sample example for how to display data in a ListBox Web control.
  • Mobile with Access DatabaseJul 14, 2001. Till now we had done the Programming using SQL Server and XML as Database.
  • Generating XML from SQL databaseJul 30, 2001. Some Days Back i posted the article dealing XML as a Middle tier but i guess the People didn't get the clear funda.
  • Basic Database Operations in ADO.NETAug 08, 2001. This Article will show the basic database transactions select, insert update and delete.
  • 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.
  • XML Web Services Type MarshalingFeb 20, 2002. This article illustrates that various data types can be passed to and returned from Web Service methods.
  • 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.
  • N-Tier Development with Microsoft .NET : Part IIIFeb 25, 2002. The last installment in this series detailed more on the middle tier – business – façade and how to create a Web Service Export Proxy to have a physically separated middle tier.
  • Publication Application Developed in C#Mar 07, 2002. This program retrieves publishers, title and author information from the SQL Server "pubs" Database.
  • SQL Server Database ExplorerMar 20, 2002. This application connects to a running SQL Server 2000 and displays all the available databases in it.
  • Saving and Reading Object to/from a DatabaseMar 25, 2002. An object is a memory stream, which is hard to write using the normal methods. In this article, I show how you can save objects in a database and read back from the database.
  • Returning a DataSet From a Web Services: Step-by-StepApr 01, 2002. This Example Shows how to create a Web service which returns a DataSet object and a Client which displays the DataSet in a Grid.
  • In-Depth Series - Web Services: Basics and BeyondApr 09, 2002. This article series shall attempt an explanation that will go beyond the basics of web services.
  • Web Services: Basics and Beyond Part 2Apr 30, 2002. This part shall demonstrate how a simple web service can be created quickly using Visual Studio.Net.
  • Performance Comparison of XslTransform InputsMay 02, 2002. To transform XML into HTML for use on a Web site or to transform it into a document that contains only the fields required you could use the XSLTransform class (found in the System.Xml.Xsl namespace).
  • A Simple Contacts List for Pocket PCMay 19, 2002. I have implemented a simple contact list application that is capable of adding and viewing contact details.
  • Programming Template in Web Server ControlsJul 15, 2002. Templates play a major role in managing the layout and format of the data being displayed in ASP.NET data bound controls.
  • Master-Detail Display using Nested Repeater Web Forms ControlAug 05, 2002. In this example, we will create a web page that displays a formatted view of data with a master detail hierarchy using nested Repeater controls. We will use the Northwind sample for our example. There are many different ways to accomplish this task. We will use data binding and data relations in an effort to get a simple solution.
  • A Virtual Photo Album in C# and .NETAug 05, 2002. This album allows you to drag your images directly from Windows Explorer into the spot you want your picture to occupy. You can also edit the captions by clicking on the labels under the pictures.
  • Master-Detail Display Using Nested Repeater Web Forms ControlAug 05, 2002. In this example, we will create a web page that displays a formatted view of data with a master detail hierarchy using nested Repeater controls. We will use the Northwind sample for our example. There are many different ways to accomplish this task.
  • The GetChanges of DataSet and DiffGramsAug 09, 2002. This article discusses the basics of DiffGrams and how DiffGram format is utilized by a DataSet to in this context.
  • User Management Utility for Web Form AuthenticationSep 06, 2002. This article deals with the management of user login and password information for a Forms Authentication in ASP.NET.
  • Personalizing Mobile Web ApplicationsSep 16, 2002. In this example, we will personalize the settings for a mobile web application based on the user logged into the site.
  • ADHelper - An Active Directory ClassSep 18, 2002. Working on my latest project required quite a degree of development against the Active Directory.
  • Viewing and Writing XML Data using ADO.NET DataSetsNov 01, 2002. Based on a real world project this article shows how to handle XML data in .NET using C# DataSets and DataViews.
  • ADODB Services in .NET Applications Using C#Dec 31, 2002. With the advent of ADO.NET, the .NET Framework lets you work with your data in a paradigm shift.
  • 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.
  • Designing and Implementing a Versatile Data Access Tier Jan 16, 2003. In this tutorial, we will drill down deeper in to the design of a n-tier architecture and our focus will be on the data access tier(DAT). Our goal is to design and implement an appropriate data access tier(DAT) for scalable, reliable and interoperable web application.
  • 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.
  • Change Color of a Column Based on Column ValuesMay 15, 2003. In this article we'll see how to change the color of column based on the column value.
  • Implementing Custom Paging in ASP.NET DataGrid ControlJun 01, 2003. This article shows you how to implement custom paging in ASP.NET DataGrid control.
  • Sorted List and Web Server ControlJun 09, 2003. This article shows you to take advantage of SortedList in data binding with Web Server controls.
  • DataGrid and Client Side EventsJun 17, 2003. This article shows you how to use DataGrid client side events including mouse over, on click and so on.
  • Data Access Layer based on dataSetsJul 01, 2003. This article aims to introduce the reader to several conceptual problems encountered in the development of a generic Data Access Layer (from now on referred to as DAL).
  • Customizing the Display of DataJul 02, 2003. This article shows you how to customize data display in a DataList control.
  • Data Access Component for SQL Server in C#Jul 07, 2003. The attached source code a data access component for SQL Server that contains methods to get a DataSet.
  • Creating ASP.NET Controls DynamicallyJul 10, 2003. This article shows you how create ASP.NET controls dynamically and fill data from a database.
  • Building a Navigation System in ASP.NETJul 16, 2003. This article shows you how to display single record per page and navigate through single record using ASP.NET.
  • Handling Null Values in DataGridJul 17, 2003. This article shows you how to handle no data found or null values in an ASP.NET DataGrid control.
  • Format DateTime Values in XML Extracted From DataSet Jul 17, 2003. In this article we'll see how to specify the format of DateTime values extracted from the ADO.NET DataSet and to verify we will write formatted contents in xml file.
  • 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.
  • Using Calendar Control in ASP.NETJul 29, 2003. In this article we'll see how to use Calendar control in ASP.NET.
  • Working with DropDownList and ListBox Controls in ASP.NETJul 29, 2003. In this article we'll see how to use DropDownList and ListBox Web controls to display data in various formats.
  • Formatting Chemical Formulae in DataGridSep 25, 2003. In this article we'll see how to format chemical formulae in DataGrid Web Server Control.
  • 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.
  • In Depth ASP.NET using ADO.NET: Part IIINov 18, 2003. In this article we will discuss a number of ways to retrieve, show, and update data with ASP.NET forms using ADO.NET. Also, we will have a clear idea about the most common server controls in ASP.NET.
  • Edit/Update a Chosen Database RecordDec 09, 2003. This article and available source code shows how to edit and update a database record through a DataGrid control
  • Display Alphabetically Sorted Data in a Data GridDec 24, 2003. This code sample shows you how to display data sorted alphabetically based on the values in the database.
  • 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 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.
  • 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.
  • DropDownList Selection as you type inFeb 09, 2004. The ASP.NET DropDownList server control allows positioning within the list by typing the first character. This method does not require a trip to the server.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • Dynamic Database Creation - 2May 06, 2004. This article explains how we can display data using Dataset and DataGrid control after the database is created.
  • LDAP, IIS and WinNT Directory ServicesAug 05, 2004. Directory Services have gained a lot of traction over the last few years. Directories are repositories of information and can be utilized in many different ways.
  • Query Tool to Excel using C# and .NETFeb 03, 2005. This article show how to use .NET's interoperability feature to pull the data directly into the spreadsheet.
  • Mapping Microsoft Excel columns with XML data (XML data integration) programmatically using a .Net Application.Apr 21, 2005. Using this program you can map Excel columns programmatically and generate an XML file containing the cell values that you had in your Excel document. After generating the XML file we can read it into a dataset.
  • 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.
  • ASP.NET Whidbey FeaturesNov 10, 2005. ASP.NET 2.0, the latest version of ASP.NET has many improvements that greatly increase developer productivity. This article gives you a peek into many of these new features available in ASP.NET Whidbey.
  • Databinding with Pocket PCNov 11, 2005. This articles shows how to write data-driven applications for Pocket PC using ADO.NET and .NET Compact Framework.
  • Creating a Blog in ASP.NET and C#Dec 02, 2005. Blogs can be a fun way to express your thoughts to others on the web. This article will show you how to create your own blog application so you can get started in the world of blogging. (This is an update from VS2003 to VS2005).
  • 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.
  • ASP.NET Caching: SQL Cache Dependency With SQL Server 2000Jan 30, 2006. SQL cache dependencies are one of the most wonderful new features in ASP.NET 2.0, the ability to automatically invalidate a cached data object (such as a DataSet or Custom Data Type) when the related data is modified in the database. This feature is supported in both SQL Server 2005 and in SQL Server 2000, although the underlying plumbing is quite different.
  • Update Database using DataSetFeb 06, 2006. In this article, we will see how to update a database using a Data Adapter's Update method using C# and ADO.NET.
  • Writing Dataset to Excel in ASP.NETMar 01, 2006. This article is helpful for those who would like to write dataset contents to a excel file and try to display it in the browser.
  • Generate ASP.NET Crystal Report using DataSetMar 02, 2006. This article will help us to create Crystal Report in ASP.NET/C# using Dataset.
  • 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.
  • DataReader And DataSetMar 20, 2006. ADO.NET is part of Microsoft.NET which comprises a set of tools and object model for accessing a data source. The objects definition appears under the System.Data namespace. It allows applications to store, manipulate and retrieve data. In this article I’m going to talk about the two different objects for accessing data sources in two common contexts of your application: the connected and disconnected environment.
  • 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).
  • Methods for Transforming data to a XML fileMay 16, 2006. This articles mentions different ways to tranform data to XML file.
  • Building Custom Paging Web FormAug 21, 2006. Sometimes we may need to build our own data objects instead of using DataSets & DataTables. But in this case, we will lose all paging and sorting facilities that is represented using DataSets & DataTables. To overcome this small issue we'll have to write our own custom paging feature as well as with sorting.
  • 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.

About DataSet

A Data Set is a collection of information which is used in the form stream of bytes in logical record and block structures. Data Set is is firstly used by IBM mainframe operating systems. All the record of Data Set are in the form of organization, record format and other parameters. The physical structure of each record is almost same as Data Set records. Data Set can be organized into a splitter into another Data Set and there have multiple members that have another sub data. Data Set organization is similar to files being organized into directories or folders. PDSs are often used for executable programs and source program libraries. A PDS is analogous to a zip file in a file system, but the data is not compressed.

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