C# Corner

Related resources for System.Data
  • Enter Null Values for DateTime Column of SQL Server4/8/2019 4:39:46 AM. Inserting a null value to the DateTime Field in SQL Server is one of the most common issues giving various errors. Even if one enters null values the value in the database is some default value as 1/1
  • Exploring System Databases in SQL Server7/21/2015 6:08:29 PM. This article explains the types of databases, their purpose, what are all the things stored in those databases and so on.
  • ADO.NET FAQ's: Part I9/15/2014 6:33:26 AM. This is the Part I of ADO.NET. In this section we will touch base on one of important concepts in ADO.NET.
  • Compiled Queries in LINQ2/11/2014 3:02:11 PM. This article explains the use of compiled queries to improve performance when a query is fired many times.
  • How to Insert a Date Into DateTime Column Using ADO.NET & C#1/16/2014 12:39:24 PM. In this article, we will show how to insert a date into a date column using ADO.NET and C#.
  • View database structure using C#7/31/2013 9:05:34 AM. This article describes an easy approach for examining all of the tables, views, and columns in a database.
  • Create a SQL Server CE Database From SQL Schema File10/5/2012 8:04:02 AM. In this article, I will explain how to create a SQL Server CE .sdf database file from a database schema defined in .sql scripts.
  • Concurrency violation: the UpdateCommand affected 0 records. 9/30/2012 4:06:02 AM. When you use a DataAdapter object to write changes back to a database by means of a stored procedure, you may receive the following error message: Additional information: Concurrency violation: the UpdateCommand affected 0 records.
  • Mobile Page View Unit5/19/2012 6:53:46 AM. This addition to the site retrieves the unit and shows the content of that page.
  • Horoscope Unit of Mobile Site5/19/2012 6:53:14 AM. Horoscope Service for Your Mobile.
  • Word Jumble In Mobile5/19/2012 6:40:38 AM. Here is an application where u can Play Word Jumble in Mobile.
  • Transaction Web Site5/19/2012 6:39:00 AM. When I started working with this technology I faced a problem dealing with session as in any transaction or Database oriented portal this is a must requirement to deal with.
  • Error: System.Data.DBConcurrencyException: Concurrency violation: the UpdateCommand affected 0 of the expected 1 records5/29/2011 5:38:28 AM. This article will help you to resolve the error UpdateCommand affected 0 of the expected 1 records.
  • AutoCompleteCustomSource in C#5/26/2011 3:36:52 PM. Sample use of AutoCompleteCustomSource with data obtained from values in a column of a database table.
  • SQL Server Default/System Databases2/4/2011 5:08:58 PM. 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.
  • Introduction about SQL Transaction10/7/2010 6:13:26 AM. This article explains about the SQL Transaction and need of this transaction.
  • Backup and recovering system databases2/15/2010 12:25:23 AM. In this article, I will cover how to backup and recover system databases.
  • Viewing Data in a DataGrid Control in ADO.NET 1/25/2010 1:03:40 AM. In this article I will explain Viewing Data in a DataGrid Control in ADO.NET.
  • Creating Your First ADO.NET Web Application1/21/2010 10:52:23 PM. In this article I will explain Creating Your First ADO.NET Web Application.
  • Table and Column Mapping in ADO.NET1/13/2010 10:39:20 PM. In this article I will explain about Table and Column Mapping in ADO.NET.
  • Connecting to a MySQL Database in ADO.NET12/22/2009 7:14:23 AM. In this article I will explain Connecting to a MySQL Database in ADO.NET.
  • How Do I Choose a Data Provider?12/21/2009 7:15:27 AM. In this article I will explain about How Do I Choose a Data Provider?
  • Using ADO.NET Data Providers12/18/2009 4:57:41 AM. In this article I will explain about using ADO.NET Data Providers.
  • ADO .NET Disconnected Classes10/28/2009 1:24:04 AM. In this article I will explain about the ADO.NET Disconnected Classes.
  • ADO .NET Class Hierarchy10/28/2009 12:04:12 AM. In this article I will explain about the ADO.NET class hierarchy provided by the .NET Runtime class library. These classes represent ADO.NET components.
  • Writing ADO.NET Applications10/7/2009 7:28:45 AM. In this article I will explain you basic steps required to write an ADO.NET Application.
  • Overview of ADO.NET Namespaces and Classes10/6/2009 1:07:49 AM. In this article I will explain about ADO.NET namespaces and classes.
  • Using Index Server for ASP.NET Site Search7/7/2009 2:20:28 AM. This projects highlights how to add search facility to your ASP.NET page using ADO.NET to browse index server search catalogs.
  • Generic 'T, K' Database Component5/28/2009 2:05:20 AM. 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.
  • Real Life SQL and .NET :Using SQL with C#: Part VIII10/27/2006 1:15:53 AM. 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.
  • ADODB Services in .NET Applications Using C#8/31/2006 6:11:24 AM. With the advent of ADO.NET, the .NET Framework lets you work with your data in a paradigm shift.
  • ADO.NET: What's changed in .NET Beta 2?8/31/2006 5:47:22 AM. ADO.NET API is one of the changed APIs. In this article, I've covered some of ADO.NET changes in Beta 2.
  • Presenting Child Data along with Parent Row in Data Grid2/27/2006 12:02:43 AM. This article explains how we can bind the parent and child data to a Data Grid with minimum code effort using the Repeater control.
  • Developing Web Applications in VS.NET 2/17/2006 12:27:46 AM. This tutorial describes about Step-by-step tutorial guides you towards developing your first web application.
  • Meal Scheduler in C#2/6/2006 6:23:35 AM. In this application once you enter your meal timings. A message box will appear on the screen while you are working and remember you about your meal with light sound.
  • Real Life SQL and .NET: Part XII2/5/2006 11:48:16 PM. 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 IX2/5/2006 11:08:35 PM. 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.
  • Simple Game Developed in C#2/2/2006 6:57:37 AM. This article contains the code for a simple game developed using csharp. This game is all about arranging the shuffled numbers in ascending order.
  • Using OLEDB in ADO.NET with COBOL1/30/2006 12:10:49 AM. The SqlClient class was created by Microsoft and is used primarily to access a SQL Server database.
  • Meal Scheduler in C#1/13/2006 5:15:24 AM. This service reminds you when it time to eat your lunch, BF or dinner.
  • Edit/Update a Chosen Database Record1/3/2006 1:08:02 AM. This article and available source code shows how to edit and update a database record through a DataGrid control
  • Mail Merge Program12/28/2005 2:24:11 AM. This is a simple mail merge program. This program reads from 3 different text files (by default) and merge all the info to produce mail documents.
  • Mail Merge Program - Part 212/28/2005 2:17:57 AM. This is a simple mail merge program (Part 2). This program reads from the access database (by default) from a specified table.
  • ADODataReader- Writing DataSets to XML12/19/2005 1:47:36 AM. This file uses ADODataReader and other objects to write DataSets to XML and filling data from the XML files.
  • Write Relational Data to an XML File12/19/2005 12:42:30 AM. This article shows you how you can write data from a database to an XML file using DataSet.
  • ADO.NET DataSet Programming12/19/2005 12:01:32 AM. A sample project shows you how to add, edit, delete, navigate, save records in a database using DataSet.
  • Connect to an Oracle Database12/17/2005 7:55:35 AM. This sample code shows you how to connect to an Oracle database using C#.
  • Compute Feature of DataTable12/17/2005 6:49:45 AM. The following code is for implementing least known feature of DataTable Compute() method.
  • Accessing Oracle Database12/17/2005 4:54:56 AM. This source code shows you how to connect to an oracle database and do operations such as select, insert, update and delete.
  • Oracle Database Connectivity12/17/2005 4:44:24 AM. This is a GUI based data entry application which shows how to add, modify and delete records using Oracle Database.
  • Oracle Database Viewer12/17/2005 4:21:29 AM. 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.
Source Code: Graphics Programming with GDI+
Graphics Programming with GDI+ is the .NET developer's guide to writing graphics appl...
Download