C# Corner

Resources  
  • FileDownloader : Download files using HTTPJan 10, 2000. This application contains a Form and a Class module . From Form we create a thread which execute the procedure to handle the NET download. This application can be enhance to do more down load as in Download manager by creating more threads.
  • 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.
  • A Database Access Class with Overloaded SELECT StatementsJan 24, 2001. A useful database access class with overloaded SELECT and other statements.
  • 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.
  • Copying and Pasting on Clipboard using C#Feb 23, 2001. If you use CTRL+C, some data or files are copied to a system clipboard and stored in system memory and when you use CTRL+V, the data is copied back to wherever you paste it. The Clipboard class provides functionality to place and retrieve data from the system clipboard. Usually
  • 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.
  • Serializing Objects in C#May 14, 2001. In simple words serialization is a process of storing the object instance to a disk file. Serialization stores state of the object i.e. member variable values to disk. Deserialization is reverse of serialization.
  • Mobile Fun with XMLMay 24, 2001. Here is something really wonderful in Mobile field .This example is for authenticating the Mobile Users against his settings stored in XML file. This is really good where all the ease of XML is applied. Function open the XML file and particular node data validate it against user inputs and do the specified.
  • 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.
  • 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.
  • 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.
  • 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.
  • Mobile Page Unit of Mobile SiteSep 19, 2001. This is something like creating WAP Pages it is still as usual my basic starting So here i will be storing only some info but What it exactly is the same as if people heard of WAP Pages and many sites offer you to create your own WAP Pages similar to WebPages but limit it to the device size and strength.
  • GUI Based Opinion PollSep 26, 2001. This is a article on how to create a opinion poll in C#. It creates a Text file on your c drive storing the voting parameters in it.
  • Encapsulation in C#Oct 12, 2001. In Object Oriented programming Encapsulation is the first pace. Encapsulation is the procedure of covering up of data and functions into a single unit (called class).
  • 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.
  • Returning an Array Listing using Remote Procedure CallDec 26, 2001. In this article we will create a Web Service that will return an ArrayList of students.
  • 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.
  • Yahtzee Program Using C#: Part IIJan 31, 2002. This is an update of the Yahtzee program for VS 2005. Included in this version is a Game Reset and a High Score Tracker. The Top Ten High Scores are tracked using an Array with sortable components. In this article we will talk about the IComparable interface used to make an object stored in an array sortable.
  • 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.
  • .NET Static Variables : Better than Application!Feb 22, 2002. In traditional ASP, we always had the Application object to store application-wide variables in.
  • 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.
  • Calling Procedural COBOL from VB.NETAug 28, 2002. Many clients will have existing COBOL source code that they will want to use within the .NET Framework.
  • Using SQL in .NET: Part 1Oct 04, 2002. In this article, I will show you how to execute SQL queries from your C# applications.
  • Remote Procedure Calls using SOAPOct 04, 2002. Here is the sample RPC (remote procedure call) using SOAP ( simple object access protocol).
  • 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.
  • Daleks in .NETDec 11, 2002. The other night my girlfriend dragged me down to the NYC Public Library claiming that they had a huge Science Fiction movie section. Admittedly my taste in movies and my wife's taste in movies can vary slightly, however, I was willing to take a chance, given that rentals at the library are free as opposed to $4 at the local video store.
  • 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.
  • The "ins" and "outs" of Using Stored Procedures in C#Jan 27, 2003. This article reviews the creation of stored procedures with parameters using the Visual Studio IDE.
  • 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.
  • Use Thread Local Storage to Pass Thread Specific DataMar 18, 2003. The specific thread level storage is known as thread local storage or TLS for short. The .NET threading namespace allows .NET developers to use TLS from within their multi-threaded applications to store data that is unique to each thread.
  • 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.
  • 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 CheckBox ControlsJun 17, 2003. How to have checkbox that is checked or unchecked depending on a field value stored in the Database, and then allow the user to click on it and record the new checkbox state in the database.
  • 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).
  • 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.
  • Storing Data in C#Sep 17, 2003. In this article, we will talk about C# data types and how data storage works with different types of data types.
  • 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.
  • Using Web.Config in ASP.NET and ASPJan 09, 2004. Web.config acts as a central location for storing the information to be accessed by web pages.
  • 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: 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: 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 : 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 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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 .NET - Part IMar 24, 2004. This article provides a basic understanding of various methods of developing multilingual applications in .NET.
  • 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.
  • Transporting and Displaying Images using DIME and HTTP HandlersApr 28, 2004. This article shows an example of how to display images stored in a database in a virtual fashion using a Web Service in conjunction with an HTTP Handler.
  • 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.
  • 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.
  • 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.
  • Evolving Numeric Series using Genetic Algorithms in C#Jul 27, 2004. If you ever browsed around the book store, you'll notice these puzzle books or IQ test books and some of the books contain questions asking you to complete a series of numbers.
  • 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.

About SQL-Stored-Procedure

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