C# Corner

Resources  
  • Write data to an access database using SQL Query and ADO.NETDec 06, 2000. See how to use SQL Statements to write data to an access database.
  • 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.
  • Database Explorer-IVJan 25, 2001. This is version IV of the Database Explorer, which include the support for Access Database with SQL Server.
  • SQL Programming using .NETFeb 01, 2001. This program shows several data objects, some draw backs of each and some interesting things.
  • 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.
  • XML Strengths and Weaknesses with DOM, ASP, and XSLApr 30, 2001. In this article we're going to take a look at some of the terminology that comes with using XML and its related technologies, as well as how to create and transform XML documents with XSL using Microsoft's MSXML parser. To test the code samples shown in this article you should be running Windows NT/2000/XP with IIS installed. You should also have SQL server 2000 installed on the same machine.
  • 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.
  • ADO.NET: What's changed in .NET Beta 2?Jun 20, 2001. ADO.NET API is one of the changed APIs. In this article, I've covered some of ADO.NET changes in Beta 2.
  • 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.
  • 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.
  • Data Transfer from SQL Server to ExcelDec 26, 2001. In this application, we will see how we can transfer data from Microsoft SQL Server into Excel spreadsheet.
  • SharpHSQL - An SQL engine written in C#Jan 08, 2002. .NET! C#! If you haven't been inundated with the marketing of Microsoft's new initiatives, you've been living in your cube without a web connection for quite a while. Like a lot of developers, I had installed the .NET SDK and the Beta 1 of Visual Studio .NET and played with it. However, since its release was so far out in the future and I had deadlines to meet, I soon went back to working with the things my customers needed now.
  • Data Access through Web Services, Stored Procedures and SQL QueriesFeb 12, 2002. Web Services has been the most revolutionary aspect of the .NET framework developed by Microsoft. This article presents the three different modes through which data can be accessed viz. through Web services, stored procedures and SQL query using the power of ADO.NET and XML.
  • 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.
  • Publication Application Developed in C#Mar 07, 2002. This program retrieves publishers, title and author information from the SQL Server "pubs" Database.
  • Creating a SQL Server Database Programmatically using SQLDMOMar 12, 2002. The attached source code creates a SQL Server database programmatically using SQLDMO.
  • SQL Server Database ExplorerMar 20, 2002. This application connects to a running SQL Server 2000 and displays all the available databases in it.
  • A Database Component: Inserting Serializable ObjectsApr 23, 2002. The attached zip file contains two projects - a database component (DLL) project and a Windows forms project called Test. Both projects are written and compiled using Visual Studio .NET version 1.0.
  • Web Services: Basics and Beyond Part 3Apr 30, 2002. This article series shall attempt an explanation that will go beyond the basics of web services.
  • A Generic Data Access Component using Factory PatternJul 30, 2002. the article A Generic Data Access Component using Factory Pattern provides a very good way of creating ADO.Net data provider independent applications, but there is one problem with it. Different ADO.Net data providers use different approaches in labeling of parameters in SQL statement.
  • Sharp HSQL- An SQL Engine Written in C#Aug 01, 2002. .NET! C#! If you haven't been inundated with the marketing of Microsoft's new initiatives, you've been living in your cube without a web connection for quite a while.
  • Using SQL in .NET: Part 1Oct 04, 2002. In this article, I will show you how to execute SQL queries from your C# applications.
  • Data Access with ADO.NETNov 04, 2002. This first article will provide a brief history of data access as well as provide the basic flow for using ADO to access data.
  • 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.
  • Using Stored Procedures in Conjuction with DataAdapterJan 09, 2003. A stored procedure is a named collection of SQL statements that are stored in the database. To the client a stored procedure acts similar to a function.
  • SQL Demo Login in C#Feb 23, 2003. This sample code contains a reusable control that allows you to build a dialog box that queries for SQL-Server connection parameters.
  • Using OLEDB in ADO.NET with COBOLApr 16, 2003. The SqlClient class was created by Microsoft and is used primarily to access a SQL Server database.
  • Building Data Access Helper Component for Microsoft SQL ServerMay 13, 2003. In this article I will be going through the development of a class library similar to Microsoft Data Application Blocks.
  • Kuti.DataJul 02, 2003. The attached source code file has two parts - DataObject directory and Automatic SQL Generator.
  • 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.
  • Error Logging in ASP.NETSep 02, 2003. I have written some code that provide your system with some nice features on error logging in ASP.NET.
  • ODBC usage in .NETSep 24, 2003. This article will provide a template of how to represent a smallint, integer, decimal, varchar and other ODBC data types that are used in the SQL Server environment in COBOL.
  • Enter Null Values for DateTime Column of SQL ServerSep 26, 2003. 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/1900 12:00:00 AM.
  • Oracle Connectivity in .NETDec 03, 2003. This whitepaper takes you through different ways of database connectivity to Oracle database from .NET. This also talks about the advantages and disadvantages of all of these technologies.
  • 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 :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 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 : 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.
  • 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: 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 : 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: 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: 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 : 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.
  • Understanding SQL Server Yukon Service BrokerFeb 25, 2004. The new version of Microsoft SQL Server™ "Yukon" comes together with a set of technologies capable of enlarging the horizon for database applications. One of the most remarkable technologies is the Service Broker that makes it possible to build database-intensive distributed applications. In this article we explore the core concepts of the Service Broker and show how to use its potentialities to build applications with message interchanging.
  • 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.
  • Report Generation in .NETFeb 27, 2004. Report generation is an integral part of enterprise application development. Choosing the right kind of report generation strategy decides the success of the application in terms of cost and performance. The white paper discusses some of the key factors that need to be considered when architecting reporting systems in .NET and C#.
  • 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.
  • Generic database access with Mimer Provider ManagerMar 09, 2004. The Mimer Provider Manager uses different plugins to access different underlying ADO.NET providers. Plugins are developed for Oracle, SQL Server, ODBC, and OLE DB.
  • 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.
  • Multilingual Applications in .NET - Part IMar 24, 2004. This article provides a basic understanding of various methods of developing multilingual applications in .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.
  • 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.
  • Populate SQL Servers and Databases dynamically in C#May 27, 2004. The attached source code is a class that provides methods to populate an array with the available SQL Server and databases on your network dynamically.
  • Accessing Excel Spreadsheet in C#Jun 01, 2004. Most of the time you will use SQL, Oracle, Access or some other database to store data. But it is possible to use Excel spreadsheet much like a database to stored data. This article and code will explain how to do this in C#.
  • Microsoft CRM Programming Secrets - Tips for DevelopersJul 26, 2004. This article is for advanced Microsoft CRM SDK C# developers. It describes the technique of direct SQL programming, when SDK doesn't have the functionality to do the job.
  • Microsoft CRM Development: SDK, C#, SQL, Exchange, Integration, Crystal ReportsAug 04, 2004. In this article, as a software developer, database administrator or a web designer, you will learn how to customize Microsoft CRM according to your needs.
  • 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.
  • Remote Data Access LayerAug 24, 2004. The attached source project is a data access layer library and the main idea of developing such a DAL is to separate the database execution from the client/end user and maintain it on the server side, there by reducing the number of direct simultaneous connection to the 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.
  • TranslateSQLOct 05, 2004. TranslateSQL is a utility for generating SQL-Server SQL scripts based on an existing Oracle schema, in essence 'translating' Oracle schemas into SQL-Server databases.
  • CopySchemaOct 05, 2004. CopySchema is a utility for copying all the data from one Oracle schema to another. Although similar to the exp/imp and bulk load utilities of Oracle, it has the advantage of offering a simple GUI interface and of handling changes to the schema.
  • 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.
  • Storing Images into a DatabaseOct 18, 2004. In order to provide your application with cool pictures you can employ two techniques (at least). One of them is that you can save the pictures in a folder and store the path to each one in a database or configuration file. The other one is to store the entire file into a database, along with its file name.
  • 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.
  • How to Call a .NET Assembly From a SQL Server Scheduled JobApr 27, 2005. This article shows you a step-by-step implementation of a COM client (a SQL Server scheduled Job) using .NET and C#.
  • Session Management in Web Garden using Custom ComponentsMay 17, 2005. This article provides an insight on creating a custom Session Manager component using C#.
  • 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.
  • Custom Assembly in Reporting ServicesJun 30, 2005. This article describes a problem that occurs when you access a custom assembly in your Reporting Services report that does not have sufficient permissions on the resources in your environment. The article also provides simple steps to grant permissions to the custom assemblies that are used in the reports.
  • Programming with .NET Compact Framework 1.0 and SQL CE 2.0 : Part IJul 26, 2005. This article covers various major components for developing application for PDA .Before developing application targets to PDA device its very important to understand .NET compact framework, supported/unsupported features for smart device development, Difference between .NET compact framework and .NET framework and of course SQL CE if you want to store application data in SQL database.
  • SQL Server Reporting ServicesAug 04, 2005. This article describes how to modify the team reports generated by VSTS or BI Studio over SQL Server 2005.
  • Membership ServiceAug 08, 2005. With every new version are added a bunch of new functionality which eases the development of web applications and keeps up to the required security measures to make the applications less susceptible to external threat.
  • SQLCLR DebuggingAug 09, 2005. In SQL Server 2005, CLR integration allows you to write stored procedures, triggers, user-defined types, and user-defined functions using any .NET Framework language, including Microsoft Visual Basic .NET and Microsoft Visual C#. In this article, I will explain how to debug SQLCLR stored procedure or SQLCLR user-defined function.
  • Programming with .NET Compact Framework 1.0 and SQL CE 2.0 : Part IIAug 11, 2005. In this article I am going to talk about garbage collection and JIT process in .NET compact framework and what are the differences between these two model of framework.
  • Enabling Membership Provider for SQL Server 2005Aug 22, 2005. ASP.NET 2.0 brings an important concept called provider model which is used for many new feature i.e. Membership Management, Role Management, Profiles, Web Parts Personalization etc.
  • 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.
  • Building Managed Code Using Common Language Runtime (CLR) Integration in SQL Server 2005Oct 24, 2005. In this article I am going to talk about a cool new feature of SQL Server 2005 called "CLR Integration", its advantages and how to program database objects using managed code with a simple project in Visual Studio 2005 beta 2.
  • SQLCLR DebuggingNov 10, 2005. In SQL Server 2005, CLR integration allows you to write stored procedures, triggers, user-defined types, and user-defined functions using any .NET Framework language, including Microsoft Visual Basic .NET and Microsoft Visual C#. In this article, I will explain how to debug SQLCLR stored procedure or SQLCLR user-defined function.
  • 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
  • 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.
  • Auditing and Logging ExceptionsFeb 01, 2006. This article shows how to handle a SQL Server error condition by using the SQL Server .NET Framework data provider.
  • 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.
  • Starting with SQL Reporting Services in ASP.NET Application: Part IMar 07, 2006. This Article is mainly to know how to start with SQL Reporting Services.
  • 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.
  • Dynamic Document ID's without Maintaining Counters!Apr 04, 2006. An article to demonstrate the creation of business document ids without using stored counters.
  • Data Access Component and the Factory Design PatternApr 05, 2006. A generic Data Access Component implementation written in C# that supports SQL, Oracle, OLEDB and ODBC data providers. Using the Factory design pattern for instantiating the data provider correct and specific objects determined at run time.
  • Data mining and SQL Server 2005Apr 11, 2006. Data mining is a key member in the Business Intelligence (BI) product family in SQL Server 2005 . Data mining is about analyzing data and finding hidden patterns using automatic or semiautomatic means, which can be explored for valuable information. It is about learning the characteristics of data set, which are not possible to discover by simple seeing.
  • Using the System Function fn_listextendedproperty of SQL Server 2005 for .NET Applications: Part IIMay 22, 2006. In this article, divided into two parts, I will compare the system function fn_listextendedproperty of SQL Server 2005 with the similar function of SQL Server 2000 ( Part 1 ), describe using the function for .NET applications ( Part 2 ). The examples are written using Transact-SQL and C#.
  • Using the System Function fn_listextendedproperty of SQL Server 2005 for .NET Applications: Part IIMay 24, 2006. In this article, divided into two parts, I will compare the system function fn_listextendedproperty of SQL Server 2005 with the similar function of SQL Server 2000, describe using the function for .NET applications. The examples are written using Transact-SQL and C#.
  • Streamlining Web Application PerformanceJun 29, 2006. This article discusses some performance tuning tips for those who use ASP.NET as front-end and Microsoft SQL Server as back-end to develop their applications.

About Linq-To-Sql

NA

SPONSORED BY

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