C# Corner

Resources  
  • Get a database table propertiesJan 22, 2001. Get a table properties such as column names, types etc using DataColumn and DataTable.
  • Compilation and Runtime Execution of a C-Sharp ProgramApr 10, 2001. C-Sharp (C#) is a strongly typed object-oriented programming language designed to give optimum composition of simplicity, expressiveness and performance.
  • 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.
  • ATL COM Component, ASP.NET Web Service, and VB ClientOct 14, 2002. This article describes how to use ATL COM Components in ASP.Net web service and how to consume the ASP.Net Web Service from Visual Basic 6 Client. Ultimately the VB6 client calls the method of the COM component created in Visual C++ through the ASP.Net Web Service.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • Configuring Publisher Policy FileFeb 20, 2004. Versioning in the Microsoft .NET Framework is managed at the assembly level and is only used when locating strong-named assemblies. By default, the common language runtime loads the assembly whose entire version number matches the version number in the calling assembly's metadata.
  • 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.
  • .NET RemotingSep 02, 2004. .NET Remoting provides an infrastructure for distributed objects. It exposes full object semantics of .NET to remote processes using plumbing that is both flexible and extensible.
  • 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 work with Assemblies in InstallShield Developer 7.0Oct 14, 2004. InstallShield Developer 7.0 is the best solution for providing the very easy user interface to author installations having both .NET and side by side components. This article is a step by step walk through of how to create a deployment project using InstallShield.
  • 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#.
  • Comparing Conditional Attributes in C/C++ versus C#Apr 09, 2005. This article compares conditional attibuting in C/C++ 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.
  • 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.
  • 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 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.
  • 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.
  • 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.
  • 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.
  • Exception Handling in WCF using Fault ContractJan 03, 2008. This article demonstrates how to get error information from a service to a client using fault contract in WCF.
  • 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.
  • Encrypt and Decrypt Sensitive Metadata Within Your Config file Jun 18, 2008. In a certain cases, metadata embedded within your configuration file is sensitive. In fact, imagine that you develop an application that uses a data base as data source; all information about this data base is located in the configuration file. What if a hacker success to log into your configuration files and obtains the connection string and other metadata about your data base??
  • 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.
  • 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.
  • Column Chart in SilverlightFeb 23, 2009. This article shows how to create a column chart in Silverlight 2.0 using Silverlight Tooklit.
  • Promoting Schemas Properties in BizTalk ServerMar 18, 2009. A common scenario in a BizTalk solution is to subscribe to a message based on its content or context and make decisions based on the underlying values. This is known as content-based routing. In this article, I will cover the principles and techniques to expose this sort of metadata in BizTalk Server.
  • 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.
  • 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.
  • Tools and Utilities in the .NET Framework Nov 11, 2009. In this article I will explain about the tools and utilities in the .NET Framework.
  • 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.
  • 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.
  • DataGrid and Datalist Controls in ASP.NET Feb 08, 2010. In this article I will explain DataGrid and Data list Controls in ASP.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.
  • 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.
  • 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.
  • Reading Metadata of Images in GDI+ Apr 02, 2010. In this article I will explain about reading Metadata of Images in GDI+.
  • 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 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.
  • 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.
  • MSChart - How to create a column chart or graphAug 18, 2010. Updated Version with samples code attached..This article will help you in creating a column chart or graph using MSChart and how to use MSChart extension with 3.5 framework.
  • ListBox in C#Aug 31, 2010. In this tutorial, we will learn how to create a ListBox control at design-time as well as at run-time. We will also see how to create a multiple-column ListBox control with single and multiple selections.
  • Cascading Dropdown in Share point using JQuerySep 02, 2010. Here I am showing how to make a cascading drop down in share point using JQuery have created two lists Stationary and Items. In Items list Stationary be a look up column from Stationary.
  • How to Display SharePoint Blog Post ArchivesSep 08, 2010. In this article I am showing how to make a share point blog post archive using share point calculated column and Data view. It will be helpful with default SharePoint blog template.
  • Sort a Multicolumn ListView in C#Sep 10, 2010. When you are working with the ListView control, you may want to sort its contents based on a specific column. We will see how to do that.
  • GridView SortingSep 29, 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.
  • Working with SharePoint 2010 Column validationOct 04, 2010. In this article I would show you 2 simple examples of how to use column validation, at the column level, then at the list level.
  • Memory Handling on NULL Values Using Sparse ColumnsOct 11, 2010. Sparse columns is a new feature in SQL Server 2008. Thr feature enables us to store null values effectively. Ideally, if the column is NULL, then the data won't be stored in the database and it's cost effective solution to save the space. If your table has more Null values, we can use this solution.

About Metadata-Column

NA

SPONSORED BY

C# Corner Chandigarh DevCon16
Chandigarh DevCon16 is a one-day Developer Conference where programmers, technologists, authors, and members meet, demonstrate, plan, and hang out.
Download Free eBooks