C# Corner

Resources  
  • Get a database table propertiesJan 22, 2001. Get a table properties such as column names, types etc using DataColumn and DataTable.
  • Similarities and difference with C# and Other LanguagesSep 24, 2001. You should know that many C/C++ developers have been asking this question: Is C# a new programming language or a new version of C/C++. My answer to both questions is that none of these definitions is true.
  • Sorting MultiColumn ListView Windows Forms ControlMay 20, 2002. If you want to sort on the first column of a ListView, simply click the Sorting in the properties Window and choose Ascending or Descending as a value. If you want to do sorting in all the columns of a ListView, you need to write custom sorting using the ListViewItemSorter property.
  • 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.
  • Welcome to COBOL.NET, corner of the C# CornerJul 01, 2002. This column will hopefully help those of you looking to use Fujitsu NetCOBOL for .NET. We are going to present some "How To" articles beginning with the basic information about the environment, the interaction with Visual Studio.NET, the Designers and the COBOL language.
  • Editable ListView in C#Jul 01, 2002. Based on the similar technique used my previous article, the Editable Listbox, we can edit columns and rows of a ListView control.
  • 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
  • Welcome to DX-CornerAug 14, 2002. In this column we will explore the COM interoperability of DirectX and focus on game programming with C#.
  • DataGrid Customiztion Part-III:Implementing Search Feature in a DataBound GridAug 21, 2002. In this article, I will show you how to exchange two DataGrid columns by dragging and dropping.
  • DataGrid Customization Part-IV:Exchanging a DataGrid Columns using Drag and DropAug 21, 2002. This article covers customized sorting and a DataGrid column hiding programmatically.
  • Working With DirectDraw and Bitmap ImagesSep 05, 2002. This month in the C-sharp DirectX column, we will be adding bitmap image support to our game engine.
  • Persist ListView Settings with SerializationDec 13, 2002. In this article, I'll show you how to persist the column order and width settings by using Serialization, binary serialization to be more specific. And you won't believe how easy it is.
  • 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 Add a Counter Column to the DataGrid?May 08, 2003. This article explains how to add functionality to add a counter column to the DataGrid.
  • Change Color of a Column Based on Column ValuesMay 15, 2003. In this article we'll see how to change the color of column based on the column value.
  • 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.
  • 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.
  • Generating Combo Box in DataGrid ColumnsJan 09, 2004. DataGrid programming in .NET is real fun. And that too if you’re trying to get it programmed in a Windows Forms world its double the work. You got to write a whole lot of code for a simple extensibility of the existing features of datagrid. One good example is having a combobox in one of the columns of the datagrid.
  • 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.
  • 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.
  • 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.
  • The Matrix Class and TransformationsApr 01, 2004. Matrices play a vital role in the transformation process. In GDI+, the Matrix class represents a 3×2 matrix that contains x, y, and w values in the first, second, and third columns, respectively.
  • Revise-Generating ComboBox in a DataGrid ColumnJun 10, 2004. This article and attached source code shows how to add a ComboBox column to a DataGrid control.
  • Refactoring in Visual Studio 2005Jun 11, 2004. Refactoring allows developers to use the built-in feature of Visual Studio to rename and convert and change the signatures and definitions of a class members. In this article, I will show you how refactoring feature provided by Visual Studio 2005 can be a handy tool when you are reorganizing or optimizing your existing projects.
  • Validating Input Xml Data FilesJun 28, 2004. In this article we'll discus two strategies for validating input XML data files. The validation of an XML input file could occur at various instances of processing.
  • 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.
  • How to Insert a Date Into DateTime Column Using ADO.NET & C#Feb 04, 2005. In this article, we will show how to insert a date into a date column using ADO.NET and C#.
  • Mapping Microsoft Excel columns with XML data (XML data integration) programmatically using a .Net Application.Apr 21, 2005. Using this program you can map Excel columns programmatically and generate an XML file containing the cell values that you had in your Excel document. After generating the XML file we can read it into a dataset.
  • Creating Reports in C# using Crystal Reports with Xml data DefinitionsMay 22, 2005. This article explains how to extract data into a Crystal Report created outside a C# project using xml data definitions and data sets.
  • OOPs Concepts and .NET Part 1: Classes, Objects, and StructuresJun 22, 2005. The following article kicks off a three-part article series that will present definitions and samples for different Object-Oriented Programming concepts and its implementation in .NET. The first part will examine the concepts of classes, objects, and structures. The second part will examine the concepts of inheritance, abstraction, and polymorphism. The third and last part will examine the concepts of interface, multiple interface inheritance, collections, and overloading.
  • OOPS Concepts and .NET Part 1: Classes, Objects, and Structures Jun 22, 2005. The following article kicks off a three-part article series that will present definitions and samples for different Object-Oriented Programming concepts and its implementation in .NET.
  • OOPS Concepts and .NET Part 2: Inheritance, Abstraction, & PolymorphismJun 22, 2005. The following article is the second of a three-part article series that presents definitions and samples for different Object-Oriented Programming (OOP) concepts and its implementation in .NET. The first part examined the concepts of classes, objects, and structures. This part examines the concepts of inheritance, abstraction, and polymorphism. The third and last part will examine the concepts of interface, multiple interface inheritance, collections, and overloading.
  • OOPS Concepts And .NET Part 2: Inheritance, Abstraction And PolymorphismJun 22, 2005. The following article is the second of a three-part article series that presents definitions and samples for different Object-Oriented Programming (OOP) concepts and its implementation in .NET
  • Building Stacks with C#Jun 23, 2005. The following article presents a general definition of the stack data structure and its most common functions. This article explores a sample stack implementation as a .NET class in C#, as well as some interesting usage scenarios.
  • Building Stacks with C#Jun 23, 2005. The following article presents a general definition of the stack data structure and its most common functions. This article explores a sample stack implementation as a .NET class in C#, as well as some interesting usage scenarios.
  • Selecting and Highlighting Multiple Columns in a Data GridJul 21, 2005. This article shows how to select multiple columns in a DataGrid and highlight the columns selected.
  • Adding a ComboBox Column Style to a DataGrid in Windows Forms Jul 30, 2005. The sample introduces how to add the Combobox DataGrid Column Style into a DataGrid on your .NET Windows form.
  • 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.
  • Presenting Child Data along with Parent Row in Data GridNov 10, 2005. This article explains how we can bind the parent and child data to a Data Grid with minimum code effort using the Repeater control.
  • Important Aspects about ComponentsJan 12, 2006. In this article, I wil discuss some properties and key definitions about component programming.
  • Using XML and XSLTJan 18, 2006. XML Stylesheet Transformation(XSLT) is defined as a language for converting XML documents to other document formats. This article shows how to perform the transformation using classes of .NET Framework.
  • Code Access Security using C# in VS.NET 2005Feb 17, 2006. This article will focus on the definition and configuration of the Code Access Security Policy.
  • DataReader And DataSetMar 20, 2006. ADO.NET is part of Microsoft.NET which comprises a set of tools and object model for accessing a data source. The objects definition appears under the System.Data namespace. It allows applications to store, manipulate and retrieve data. In this article I’m going to talk about the two different objects for accessing data sources in two common contexts of your application: the connected and disconnected environment.
  • Generic DataGridViewJul 05, 2006. DataGridView is a new control which is more flexible for coding than simple datagrid. However, there are a lot of developer having diffulties about DataGridView Calendar, Mask, ComboBox and also validations.
  • Tip: How to Print a CheckBox for a Boolean Column in Crystal Reports?Jul 21, 2006. Crystal Reports does not provide a CheckBox conrol. This small tip shows how to create a CheckBox for a boolean column in Crystal Reports.
  • Tip: How to format a column value of a Report programmatically?Jul 21, 2006. In one of my reports, I had to change the format of a column programmatically depending on the value of the column.
  • The .NET 2.0 Framework Provider PatternAug 11, 2006. The Provider Model Design Pattern was first introduced with the .NET 1.1 framework, specifically in the ASP.NET starter kits and was formalized in ASP.NET Whidbey as a membership management provider API (Application Program Interface). It's primary purpose is to separate the definition for an API from the implementation. This keeps the API flexible by enabling the core functionality to be flexible and easily changed.
  • Retrieve Oracle BLOB and Save as a JPG Using ASP.NET 2.0Sep 01, 2006. The attached code snippet in this article shows how to retrieve Oracle BLOB column data and save as a JPEG file using ASP.NET 2.0 and C#.
  • Pull a column value from another list in your site in Sharepoint Portal ServerSep 21, 2006. In document and form libraries, you can create custom columns or metadata properties and interestingly, you can autopopulate these columns with data that can be hardcoded or extracted from other lists that are part of the same site where your document library is located.
  • Using Expression Property to create Columns with Dynamic ValuesOct 09, 2006. This article shows how to create columns with dynamic values using expression property.
  • Crystal report with Dynamic ColumnNov 03, 2006. The objective of this article is to provide a process which can be followed to develop a crystal report with dynamic columns using parameterized column fields and formula fields. Before going for this the developer has to decide the maximum number of columns he/she has to display and as per the no. of columns the size of the paper. The developer can define the size of the paper by selecting Printer Setup in File menu.
  • 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.
  • ASP.Net 2.0: Export GridView to Excel - Part IIApr 04, 2007. In this version of the article, we will include the handling the Hyperlink columns in the GridView export to Excel and also re-factor our original logic to use more general features of Reflection.
  • Enhanced Oracle Explorer in C# and .NET Using Windows FormsApr 27, 2007. This application will allows to do multiple simple activities on oracle database like running select statements and getting selected procedure's definition simultaneously in a thread-based GUI.
  • Implement Sorting in Reports using Report ViewerMay 10, 2007. This article shows how to implement sorting on columns in a report using Report Viewer.
  • Get the Sum of a particular column values in a DataGridJun 12, 2007. This article shows how we can get the total of a particular column of a DataGrid.
  • 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.
  • Host a combo box column within a DataGridView control Feb 26, 2008. In this article I willl show how to host a data grid view combo box column within a data grid view control.
  • Dispaly a Picture in Grid CellFeb 29, 2008. This article helps to load picture in Grid Cell.
  • 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.
  • How to Define and Configure a Grid Control Within a WPF Aplication Using XAML: Part IAug 13, 2008. In this article, I will try to make a representation of the Grid object witch is directly derived from the Panel abstract class and we can say that is a flexible area that contains rows and columns, it plays a role of container in a given WPF window.
  • Site Definition in SharePointJan 08, 2009. This article will explain about Site Definition, why we do need custom site definition ?and how to create and deploy a custom site definition.
  • WPF ComboBox at a Glance - Overview Jan 13, 2009. This is a simple article to show the data into Combobox usinf WPF, you can use multiple columns in a combobox.
  • JSON FundamentalsFeb 02, 2009. A new data format which is built on JavaScript is called JavaScript Object Notation[JSON]. It is a lightweight data format based on JavaScript syntax. JSON definitions can be included within JavaScript files. This post speaks about basic syntax of JSON.
  • WCF Features in .NET Framework 4.0Feb 08, 2009. WCF providing a way to define service contracts and to configure endpoint definitions using the declarative XAML in .NET Framework 4.0.
  • Column Chart in SilverlightFeb 23, 2009. This article shows how to create a column chart in Silverlight 2.0 using Silverlight Tooklit.
  • Silvelight Datagrid Auto SizingMar 26, 2009. This articles describes how to autosize a Silvelight Datagrid and its columns.
  • BizTalk Mapping. Using the Database Lookup FunctoidApr 06, 2009. In this article, I will show how to use the Database Lookup functoid to map incoming XML node to a database table column whose result value is set to a target XML node.
  • SharePoint Quick Start FAQ: Part VApr 09, 2009. This is the 5th tutorial of SharePoint FAQ series. This series will mainly concentrate on custom columns, content types and document list library. I am sure once your read this article your thinking of how SharePoint organizes document centralization will change.
  • A Programmer's Guide to Starting a Software Company and Building an Enterprise Application - Article 3Jun 20, 2009. This is the third in a series of columns in which I will tell you how I started SplendidCRM Software, Inc.
  • Tip: How to Highlight Rows in a DataGrid Using a CheckBoxJun 25, 2009. This code snippet shows how to select or highlight selected rows in a DataGrid based on a CheckBox column similar to yahoo or hotmail emails.
  • GridView Multicolumn sortingJul 09, 2009. GridView's built-in sorting can be enabled by setting a data source and AllowSorting property to true. Click on column header to sort based on the SortExpression specified in the Gridview column. However, Gridview does not support multi column sorting which is required in day to day application. So here is how I tried to create one:
  • Rows.Count, Column.Count and IEnumerator using ADO.NET with C# and Database ServerJul 29, 2009. In this article I will explain you how to make a SQL database connection and show information in data grid. Count the number of rows and columns in the table and show the records in text boxes using IEnumerator interface.
  • Exploring Grid Panel in Silverlight 3 Using Blend 3Jul 29, 2009. In this article we will explore how can we add Rows and Columns in Silverlight 3 using Blend 3.
  • Look at Code Definition Window in Visual Studio 2008Aug 21, 2009. This article explains about Code Definition Window and its features in Visual Studio 2008.
  • Creating Custom Fields in SharepointSep 27, 2009. This article shows how to add custom fields to Sharepoint.
  • Creating Data Adapters with the Data Adapter Configuration Wizard Oct 14, 2009. This article will help you in understanding Creating Data Adapters with the Data Adapter Configuration Wizard.
  • Data Column in ADO.NETOct 30, 2009. In this article I will explain about Data Colum in ADO.Net.
  • Charting in SilverlightNov 10, 2009. This tutorial demonstrates how to use charting applications in Silverlight using Silverlight Toolkit. First you will learn how to get started with the Silverlight Toolkit and then create bar chart, line chart, pie chart, column chart, and scatter chart in a Silverlight application.
  • Working with XMLNov 17, 2009. This article begins with basic definitions of Hypertext Markup Language (HTML), XML, and other Web-related technologies.
  • XML NamespacesNov 18, 2009. In this article I will explain you about XML namespace, DTD and schemas and Extensible Hyper Text Markup Language.
  • Radio Button in Silverlight 3.0 Data GridNov 19, 2009. In this article, I will explain how to put Radio Button as one of the column in Silverlight Datagrid. I will also show how to work with radio button as column of Datagrid.
  • DOM Overview Nov 20, 2009. In this article I will explain you about DOM.
  • Radio Button Column in Datagrid in Silverlight 3Nov 24, 2009. In this article we will see how we can add a Radio Button Column to the DataGrid in Silverlight 3.
  • Column Chart in WPF Nov 26, 2009. This article demonstrates how to draw column charts using WPF and C#.
  • Charting in WPFNov 28, 2009. This tutorial demonstrates how to draw various charts including line chart, bar chart, column chart, area chart, scatter chart, and pie chart using WPF and C#.
  • DataGrid Column Resize in Silverlight 3Dec 01, 2009. In this article, we will see how we can resize the DataGrid Column after row delete operation from the DataGrid.
  • Multi Select Delete in DataGrid in Silverlight 3Dec 01, 2009. In this article we will see how we can have a CheckBox Column. And with the help of CheckBox we can multiselect rows and perform delete operation.
  • Datagrid TemplateColumn Sorting in Silverlight 3Jan 07, 2010. In this article we will see how we can sort different column in DataGrid Custom Coulmns including TemplateColumn.
  • Table and Column Mapping in ADO.NETJan 13, 2010. In this article I will explain about Table and Column Mapping in ADO.NET.
  • Cascading dropdown column in a SharePoint 2007 ListFeb 08, 2010. This article will show how to use codeplex project to achieve Cascading drop down columns in SharePoint list.
  • DataGrid and Datalist Controls in ASP.NET Feb 08, 2010. In this article I will explain DataGrid and Data list Controls in ASP.NET.
  • Hide & Un-Hide DataGrid Column(s) In WPFFeb 19, 2010. In this article we will see how we can hide or unhide the columns in a DataGrid.
  • Seven quick points in Understanding SharePoint 2007 list definitionFeb 22, 2010. This article will give basic 7 theatrical points on SharePoint List definition.
  • Hide/Un-Hide Columns using Context Menu in DataGrid in WPFFeb 24, 2010. In this article we will see how we can add a ContextMenu for the Header and that will perform our Hide/Un-Hide function in Datagrid.
  • Using Silverlight Grid ControlMay 03, 2010. The Grid control is the most flexible layout panel, and supports arranging controls in multi-row and multi-column layouts. It is conceptually similar to an HTML Table element.
  • Dynamically creating bound and template columns in GridView using ASP.NetMay 03, 2010. Here in this article I will explain how one can develop or implement runtime dynamically create bound column as well as template column of a GridView control and also how to bind data into the dynamically created GridView.
  • Using Report Service and Server Business Intelligence DevelopmentMay 07, 2010. This article will show steps for using report service and Server Business Intelligence Development.
  • Fancy GridView SortingAug 17, 2010. We will describe a GridView sorting method we used in recent projects. Each GridView column can be sorted in ascending or descending order. An arrow indicates which column is being sorted, and in which direction.

About Column-Definitions

NA

SPONSORED BY

Custom Software Development
MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.
European SharePoint Conference