C# Corner

Resources  
  • C# IndexerJan 15, 2000. An indexer is a member that enables an object to be indexed in the same way as an array.
  • ADO.NET Database ExplorerJan 20, 2001. The sample connects to the SQL server database and shows you a tree view like interface of all the tables.
  • Get a database table propertiesJan 22, 2001. Get a table properties such as column names, types etc using DataColumn and DataTable.
  • Database Explorer-IVJan 25, 2001. This is version IV of the Database Explorer, which include the support for Access Database with SQL Server.
  • Using the ref ParameterMar 06, 2001. The ref keyword on a method parameter causes a method to refer to the same variable that was passed as an input parameter for the same method. If you do any changes to the variable, they will be reflected in the variable.
  • 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.
  • 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.
  • Mail Merge Program - Part 2Mar 21, 2001. This is a simple mail merge program (Part 2). This program reads from the access database (by default) from a specified table.
  • Naming Guidelines in .NETApr 20, 2001. Commenting and following a uniform naming guidelines in your code is one of good programming practices to make code more useful.
  • 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.
  • The out and ref Paramerter in C#Jun 12, 2001. The out and the ref parameters are used to return values in the same variables, that you pass an an argument of a method. These both parameters are very useful when your method needs to return more than one values.
  • Using ref and out ParameterJun 20, 2001. When we pass a parameter as ref to a method, the method refers to the same variable and changes made will affect the actual variable.
  • What & Why : Properties :: Part 2Jul 09, 2001. In the part 1 of this series, I discussed about the get method of the properties, with the help of which you can make your variable so that nobody can modify the value of the variable.
  • Populating and Editing a DataGrid in ASP.NETAug 17, 2001. I will show here , how to develop DataGrid, which is able to retrieve data from joined tables and editable.
  • Is there any need to Boxing and UnboxingSep 21, 2001. With Boxing and unboxing one can link between value-types and reference-types by allowing any value of a value-type to be converted to and from type object. Boxing and unboxing enables a unified view of the type system wherein a value of any type can ultimately be treated as an object.
  • Oracle Database ConnectivitySep 26, 2001. This is a GUI based data entry application which shows how to add, modify and delete records using Oracle Database.
  • Oracle Database ViewerOct 17, 2001. 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.
  • Pointers in C#Oct 25, 2001. C# also supports pointers in a limited extent. A pointer is nothing but a variable that holds the memory address of another type. But in C# pointer can only be declared to hold the memory address of value types and arrays.
  • Mapping Objects to Relational DatabasesNov 01, 2001. The application generates C# Class files for each table in a relational database. I have used Mysql and ODBC.NET for this project. The application only supports MySQL right now.
  • 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.
  • Developing a Record Navigation Form with Unbound ControlsDec 26, 2001. Developing a record navigation form with unbound controls. The form enables you to navigate through the records one at a time. In this application we have used a combo box, two text boxes and various command buttons.
  • C# Discussion Forum from Harrison LogicJan 29, 2002. Threaded Discussion Forum that utilizes the .NET framework, with C# as the ASP.NET server side language. Uses MS Access Database for data.
  • 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.
  • A Shaped Windows Forms Application with Variable OpacityMar 11, 2002. This application demonstrates two simple techniques that beginners might find useful in developing creative new looks for Windows applications.
  • .NET Remoting: The Interface ApproachMar 26, 2002. In this article, we will create a remote object, and access this object using the Interface. The object returns rows from a database table.
  • Reflecting Data in .NET Classes - Part IV: From Database TableApr 08, 2002. In this article, we will be looking at how to "reflect" data from the most common data source - Database tables.
  • DataGrid Customization: Part-1Jun 25, 2002. In this article, I will discuss some DataGrid customization tips such as how to I get the name and index of the column headers and how do I find out if mouse click right click was on a column.
  • DataGrid Customization Part-II: Custom Sorting and DataGrid Column HidingAug 13, 2002. How to I get the name and index of the Column headers? How do I find out if mouse click right click was on a column
  • TWINXBASE ServiceSep 09, 2002. This service scans in a directory by using FileWatcher component and when a file arrives, then the service will check the extension of the file, if the file has the extension .DBX then it will read the contents of the file and communicate with the database (C:\FILESERVICE\DB\MyDB.mdb) and insert / update / delete the records in the database -table.
  • Working with COBOL Data Groups in C#Sep 11, 2002. In this article we will begin with a C# console application calling a COBOL DLL file. The C# application will pass it a number of occurrences to create in the table (much like a user requesting a specific number of months to report on).
  • Using DTS from C#Sep 16, 2002. In this article I will concentrate on enumerating, executing and changing properties or global variables of DTS package.
  • Accessing Text Files using ODBC Data ProviderNov 12, 2002. In this article, I will show you how to access Access database files using ODBC data provider.
  • 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.
  • 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.
  • Iterations and Performance in .NETApr 15, 2003. I’ve been implementing numerical libraries in .NET and have come to some conclusions about iteration performance.
  • 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.
  • How to Display Data Vertically?May 08, 2003. This article explains how to display data vertically rather than typically horizontal rows.
  • 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.
  • 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.
  • 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: 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 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.
  • Using Index Server for ASP.NET Site SearchJan 23, 2004. This projects highlights how to add search facility to your ASP.NET page using ADO.NET to browse index server search catalogs.
  • 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.
  • DataSets in Microsoft .NET - Part 2Mar 09, 2004. This article explains sorting, searching and filtering support provided by dataset and data table objects.
  • 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.
  • Difference between passing reference types by ref and by valueSep 02, 2004. We all know the difference between passing value types byval and byref, if the variable is passed byval any change to the variable value in the called function is not reflected back in the callee.
  • How to Populate a DropDownList insides a DataGrid through an XML FileNov 16, 2004. In this article, we will show how to fill a DropDownList inside a DataGrid through an XML file. We will also show how the contents of one DropDownList changes dynamically as we change the index of second DropDownList (both inside the grid).
  • Will swap work if C# Manipulates Objects by Reference?Feb 15, 2005. C# does manipulate objects by reference, and all object variables are references. On the other hand, C# does not pass method arguments by reference; it passes them by value. Thus, a regular swap method will not work!
  • Out and Ref Parameters in C#Feb 27, 2005. The out and the ref parameters are used to return values in the same variables that you pass an an argument of a method.
  • 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.
  • ASP.NET Session StateSep 21, 2005. Session state is nothing more than memory in the shape of a dictionary or hash table, e.g. key-value pairs, which can be set and read for the duration of a user's session.
  • 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.
  • How To Get All Database Tables and TableColumns in Oracle Nov 08, 2005. In this article, I will show how can I fetch all tables and corresponding columns from an Oracle database using C# and Oracle .NET Data Provider.
  • Hashtable in C#Nov 14, 2005. Hashtable is useful when you need to store data in a key and value pair. This article shows how to use hashtable in C#.
  • Learning Delegates in C#, an IntroductionJan 03, 2006. There is this thing in C# called a delegate, which is going to be crucial to build interactions between our objects. What’s a delegate, you ask? Good question. A delegate is a pointer to a method. What’s that mean? Just like you can pass variable by reference, you can pass a reference to a method. Let me give you an example.
  • How to Overcome Error "Access to the Path Containing 'hash.web' is Getting Denied."Jan 08, 2006. The article is about how to overcome with the error that reads "Access to the path containing 'hash.web' is getting denied."
  • Types of VariablesJan 14, 2006. In this article we'll cover the behaviors of variables to Reference Types.
  • C# Heap(ing) Vs Stack(ing) in .NET: Part IIJan 15, 2006. Having a basic understanding of how memory management works will help explain the behavior of the variables we work with in every program we write. In this article I'll cover some of the behaviors we need to be aware of when passing parameters to methods.
  • C# Heap(ing) Vs Stack(ing) in .NET: Part IIIJan 15, 2006. Having a basic understanding of how memory management works will help explain the behavior of the variables we work with in every program we write. In this article we’ll cover an issue that arises from having reference variables in the heap and how to fix it using ICloneable.
  • C# Heap(ing) Vs Stack(ing) in .NET: Part IVJan 30, 2006. Having a basic understanding of how memory management works will help explain the behavior of the variables we work with in every program we write. In this article we’ll look further into Garbage Collection (GC) and some ways to keep our applications running efficiently by using static class members.
  • 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.
  • Use Customized IndexersMar 14, 2006. Many of you are aware of indexers and its properties. For those unaware of it want to know that indexers are used to represent objects using indexes or even using keys. I.e. we can represent an object of a class by the way an array is using.
  • 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.
  • Deploying ASP.NET 2 Web Site to Production Server: Part IIApr 10, 2006. On the first part we discussed in detail how to move our database which contains the membership tables from the default aspnetdb Database to our database. On this part we will show how to change the default settings of asp.net membership and role providers to read from tables which stored on our database.
  • Using static variable and Activated Event for Building "Home" Button of Windows applicationApr 10, 2006. In this tutorial I will share experience how , just with the help of a few clicks and a few lines of code , to build a windows application with "Home" button, that allows to return to "Home" form (in fact to close all opened forms by one click) . The examples are written using C#.
  • Accessing Crystal Report in ASP.NET using C#May 01, 2006. This article is for web-developers who want to access crystal reports in ASP.Net by using multiple tables or views etc. This application might help them and save their development time.
  • 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).
  • Nested Repeater : Display Hierarchal Data in Web Form by Using ASP.Net RepeaterJun 02, 2006. This article features how to display hierarchal data from multiple tables using an ASP.Net repeater control in a web form.
  • Server.Transfer : Passing Values from One Page to Another PageJun 19, 2006. Some times, we want to pass values from one page to another page. There are many ways by which we can do this like: by using query string, or session variable, or Server.Transer etc. This article shows you, how to pass values from one page to another page by using Server.Transfer method.
  • Introduction to Common Table Expressions – SQL Server 2005Aug 03, 2006. This article delves into the concepts of Common Table Expressions (CTE) in SQL Server 2005 and their usage.
  • Maintaining Transactions in Enterprise applications using ADO.NET Transactions Aug 07, 2006. This article explains usage of System.Transactions to update tables of two different databases with two different data providers (SqlClient and OleDB) in Atomic(ACID) way.
  • Working of Reference Type and Value TypeSep 18, 2006. This article shows you all the difference between reference and value type variables.
  • How to Extend User Profile in ASP.Net 2.0Oct 03, 2006. This article will give you guidelines to extend user profile in standard table format which created from aspnet_regsql command by creating a detail table which will be linked to the main user table.
  • Working with HashTable in C# 2.0Nov 13, 2006. We often need to store more than one dimension data in a list and data may not be an integer or string. This article shows how to use the HashTable class to store object type data.
  • Tip related to sub containers and SqlDataSourceDec 06, 2006. This article provides some tips when working With Master page or SqlDataSource insert function In VS 2005.
  • Strategy for querying Microsoft Access as an In-Memory Database using DataSets and ADO.NETJan 09, 2007. This article describes how you can read tables in from MSAccess up front in your application and then query the tables in-memory using some powerful features of the DataSet and ADO.NET
  • How Do I Bring a Microsoft Word Table into a DataGridView?Jun 12, 2007. This Article will answer the question: "How do I import a table in MS Word into a DataGridView using Visual Studio's built in Tools for Office.
  • Windows Communication Foundation callbackJun 12, 2007. This article is intended to illustrate how to implement callback operations in WCF through a common business scenario where the service needs to notify that some events has happened to the client. During a callback, in many aspects the tables are turned: the service becomes the client, and the client becomes the server.
  • WPF Database Communication Adding new Record to the DatabaseSep 06, 2007. WPF Database communication Adding new record to the database (XAML-MS-Access), I have a XAML form with FirstName, LastName, Email & Contact fields in it on click of submit button it will first check if the same email address is exists in the table else it will add new record I have made use of OleDbTransaction to perform add functionality.
  • Solution for "A Graphics Object cannot be Created from an Image that has an Indexed Pixel Format"Sep 10, 2007. In this article, you can learn how to avoid the issues/errors when you access/edit indexed pixel format images using few steps.
  • Retrieving Middle Rows from a TableOct 16, 2007. This article helps in retrieving middle rows of a particular table irrespective of its columns and data types.
  • View database structure using C#Jan 16, 2008. This article describes an easy approach for examining all of the tables, views, and columns in a database.
  • SQL Server backup utility using VB.Net and SQL-DMOFeb 05, 2008. This article allows you to take backup of any SQL Server database using SQL-DMO library. It allows you to take backup of selected tables, views or stored procedure.
  • Using XSL and .NET To Display Database Tables in your Web BrowserFeb 07, 2008. This article describes how you can leverage .NET and XSL as a powerful and flexible means to rendering database reports into your Web Browser.
  • XML in SQL Server Part 1Feb 27, 2008. This article gives you an overview of working with XML in SQL Server.
  • F# Tuples and Binding (and more Binding)Mar 26, 2008. Binding in F# is similar to using variables in C# but there are some big differences. This article discusses one of the most used keywords in F# for binding ("let") and how it is different than setting a C# variable. I also cover the tuple F# data structure.
  • Using OUTPUT Clause for Getting Deleting Information from Several Tables.Apr 01, 2008. In this article I will explain how you can use such a T-SQL (SQL Server 2005) feature as OUTPUT clause in order to get information about rows, which were affected, when deleting process is executed for several tables, “connected” by foreign keys. The examples are written using T-SQL and C#.
  • The Concept of Shopping Cart in ASP.NET with C#Jul 16, 2008. This article will just give you the brief idea how to make simple shopping cart with dropdown GridView and data table.
  • SQL Server Effective Database Tune up and MaintenanceAug 08, 2008. Here are a few tips for developers that are not a professional DBA but have been assigned the responsibility for the database for some reason.
  • Working with WPF Table using XAML - Part IAug 12, 2008. In this article, I will use WPF table in XAML format. This one defines a flexible grid area that contains rows and columns. At the contrast of the Grid object witch is defined in the System.Windows.Controls, the table object is defined in the System.Windows.Documents namespace.
  • Working with WPF Table using C# - Part IIAug 26, 2008. In the previous article, Working with WPF Table using XAML - Part I, we discovered how to perform this task using XAML. Now, we will see how to do the same using C#.
  • Physical Data Organization and IndexingOct 07, 2008. This article is intended to explain the main storage structures used in database systems through examples in Microsoft SQL Server and Oracle Database.
  • Simulating Autonomous Transactions in Microsoft SQL ServerOct 10, 2008. In the article, I will cover how to use table variable techniques in order to simulate the autonomous transaction behavior of Oracle databases in Microsoft SQL Server.

About Indexing-Table-variables

NA
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!
VSLive! Anaheim