C# Corner

Resources  
  • Get a database table propertiesJan 22, 2001. Get a table properties such as column names, types etc using DataColumn and DataTable.
  • Mail Merge ProgramMar 16, 2001. This is a simple mail merge program. This program reads from 3 different text files (by default) and merge all the info to produce mail documents.
  • Web Request ClassApr 04, 2001. This is a simple application that the gets the source of a webpage via the WebRequest Object.
  • .NET is the FutureJul 19, 2001. This has been a long time in coming. I couldn't write any more article because of some problems but finally I thought I should talk about the future of .NET. The reason is very simple, I'm getting almost 50 mails a day in my inbox just asking about the future of .NET and the comparison with other technologies. So I'm presenting my own views about the future possibilities of this technology.
  • File Info on Mobile Aug 30, 2001. Here is an example of Accessing the Information in a File to be given to Mobile User.
  • 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.
  • 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.
  • Getting NASDAQ Quotes with a Pocket PCMay 22, 2002. If you have been lucky enough to get the Compact Framework or Smart devices extension beta for April 2002 you may be wondering what you can do with it.
  • An Editable GridView Control in C# and .NET - Part 1May 28, 2002. I've gotten a lot of e-mail about my GridView control Article, so I've decided to write a follow up article on a more powerful control that allows you to edit the cells within the control and change the colors of the cells.
  • 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.
  • Getting System InformationSep 26, 2002. The attached source code returns the system information for your machine such as machine name, operating system, current user and logical drives.
  • 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.
  • Automating the Process of Getting Latest Files from VSSJan 22, 2003. In this article, I will show you how to write an automated process of taking VSS backup. Initially, this application was written with some hard coded settings such as user name, password. and VSS path.
  • Getting Official DayTime using NIST TimeServerApr 21, 2003. This program shows how to create a simple socket to a NIST timeserver (Port 13) and using the Daytime Protocol, gets the official time.
  • 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.
  • 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.
  • 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.
  • Getting Started With Exception Handling in C#Jul 14, 2004. This article explores exception handling mechanisms in C#, including an explanation of exceptions and why we need to catch exceptions.
  • Extreme ProgrammingSep 16, 2004. Extreme Programming is new development technique getting adopted in the software development and the key strength of this methodology is simplicity, team work, quality and testing.
  • 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.
  • Getting Web Statistics for Instant Downloads in ASP.NETNov 05, 2004. One of the most important website activity parameters is the resource access statistic. Such information is necessary for many purposes - optimizing of the website content, marketing campaigns improvements and also for some diagnostic tests.
  • 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.
  • MouseStick Control.May 13, 2005. The attached source code is a MouseStick control written in C# and Windows Forms. The MouseStick control gets its name from the fusion of a joystick with a mouse. Think of the line in the MouseStick as a joystick that is controlled with your computer's mouse.
  • 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.
  • Getting Data Providers Details in ADO.NET 2.0Aug 19, 2005. In ADO.NET 2.0, there is a new addition of DB provider factory classes, which allow developers to get the information about the data providers available (installed) on a machine.
  • 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.
  • 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."
  • C# Interface Based DevelopmentMar 06, 2006. When trying to build maintainable, reusable, and flexible C# code, the object oriented nature of C# only gets us 50% of the way there. Programming to interfaces can provide us with the last 50%. Interfaced-based design provides loose coupling, true component-based programming, easier maintainability and it makes code reuse much more accessible because implementation is separated from the interface.
  • Internationalization Getting StartedMar 09, 2006. This article introduces the concept of Internationalization in application development. Starting off with the basics of character encoding and Unicode, the article discusses the best practices to be followed in writing culture aware code and designing Internationalized user interfaces with adequate examples in .NET (C#).
  • Building applications with DLinq DesignerJul 01, 2006. DLinq designer is the visual design surface to create the entity objects and bound the controls to the dlinq objects with relationships. We can easily create the windows form using the designer. The developer need not take more time to design the User Interface. The designer itself suggests you the controls suitable for the selected fields.
  • Using LINQ in Visual Studio 2005Jul 03, 2006. LINQ (.Net Language Integrated Query) is the general-purpose standard query operators that allow traversal, filter and projection operations to be expressed in a direct yet declarative way in any .Net programming language.
  • 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.
  • .NET Language Integrated Query for XMLJul 17, 2006. This is the overview of .NET Integrated Language Query for XML. This Article explains some of the features of XLINQ with example.
  • 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.
  • System Date Time Check FormatOct 18, 2006. This program executes the system date time format. Is it in dd/mmm/yyyy or other format and the which cultuerInfo is the system running on.
  • 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.
  • Getting Started with AJAX 1.0Feb 09, 2007. After fruition of this article, you will have a better understanding of AJAX 1.0 extensions and will learn how to build AJAX enabled Web applications using ASP.NET 2.0 and Visual Studio 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.
  • Getting Started with ReportViewer ControlApr 05, 2007. I could not be more happier when I saw the ReportViewer control as a part of Visual Studio 2005 controls. This article is an introduction to the ReportViewer control and how to write a simple report using the ReportViewer control in Visual Studio 2005.
  • 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.
  • Multi-threaded Asynchronous Programming in C#... Getting started.May 12, 2007. Trying to build better solutions and growing as a developer has always been fun for me and I’m always looking for ways to build more scalability and robustness in the software I am writing. I had a revelation that I’ve been doing a lot of C# tweaking but not taking advantage of the core performance enhancements cooked right into C# and it all comes down to one thing: Asynchronous multi-threaded programming.
  • 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.
  • Select Items with Where in LINQ and C#Jun 21, 2007. This article shows how to select exact match and in between items from a collection using LINQ and C#.
  • Reading and Writing XML using XLinqJun 21, 2007. XLinq is a new API to work with XML using LINQ. XLinq is more flexible, simple, and faster programming model to read, write, manipulate, and traverse XML documents.
  • Think in LINQ: Yahtzee Score Calculator Using LINQ TechnologyJul 23, 2007. This article revisits the yahtzee program I wrote in 2002 and reimplements scoring using LINQ technology. It compares the old way of scoring with LINQ and shows you the advantages of using LINQ.
  • Data Binding using LINQ to SQL in C#Aug 09, 2007. LINQ to SQL allows developers to work with databases using LINQ. This article discusses how to get, add, update, and delete data in a DataGridView control using LINQ to SQL.
  • AJAX AutoCompleteExtenderOct 04, 2007. In one of the Ajax project while using <ajaxToolkit: AutoCompleteExtender> I was getting following error: Error Creating control - autoComplete1. This control cannot be displayed because it's tag prefix is not registered in the web form.
  • 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.
  • Getting Started with silverlightDec 04, 2007. This article explains you how to use silverlight and also gives you a brief history behind silverlight.
  • Chapter 1: Introducing ASP.NetJan 07, 2008. This article tells the features and frills of Asp.Net 3.5 and .Net framework.
  • Functional Programming in C#: CurryingJan 13, 2008. Currying is a way to re-write a function with multiple arguments in such a way as it can be called as a chain of functions each with a single argument. This article covers using a few simple utility methods you can use to curry your methods.
  • 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.
  • Functional Programming with C#: Lazy CalculationJan 20, 2008. I ran across Mike Gold’s nice algorithm for finding primes using LINQ syntax and thought I’d use his idea as a base from which to demonstrate one of the more subtle features in functional programming: lazy calculation.
  • Chapter 1: Hello LINQFeb 06, 2008. This is an exert from Joseph C. Rattz, Jr.'s book Pro LINQ. Here you learn how to use Linq in your application and also depicts the benefits of using Linq.
  • Chapter I: Getting your toolsFeb 14, 2008. This article tells you how to access databases with C# 2008.
  • 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.
  • Getting Started With F#Mar 22, 2008. This is the first in a series of articles discussing the F# programming language. I cover how to get your dev environment set up to develop with this awesome NET Framework language
  • 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#.
  • Using LINQ to Objects in C#May 26, 2008. This article provides an introduction to employing LINQ to Objects queries to support a simple win forms application; the article addresses the construction of LINQ to Objects statements and then goes on to describe how one might use LINQ to Objects within the context of an actual application.
  • Passing and retrieving parameters from windows workflowJun 09, 2008. Basically this article gives an idea about how to pass the parameters and getting output parameters from the workflow.
  • Convert a LINQ Query Resultset to a DataTableJun 24, 2008. After a long struggle I find out the way to convert a Linq Query resultset to DataTable object. The attached source code shows how to do it.
  • Cascading Deletes in LINQ to SQLJul 03, 2008. This article will discuss alternative methods for performing cascading deletes using LINQ to SQL. Cascading delete refers to the action of removing records associated by a foreign key relationship to a record that is the target of a deletion action.
  • Generic Data Access using LINQ to SQL and C#Jul 22, 2008. This article discusses the construction of a generic data access layer built on top of a LINQ to SQL implementation.
  • Attaching a Digital Certificate (Public Key) to an HTTPS RequestAug 10, 2008. This article will guide you on how to post data to an HTTPS (i.e., secure connection) URL from a Windows application (.NET) by attaching a digital certificate from a certificate file and getting the response back.
  • 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.
  • SQL Server Stored procedures and UDF within LINQ context-PartIISep 03, 2008. In the first article, SQL Server Stored procedures and UDF within LINQ context-Part I, I exposed 2 scenarios of how to deal with stored procedures using LINQ, in this second part, I will accomplish the task by demonstrating how to call a user defined function UDF using the same way adopted in the first part.
  • SQL Server Stored procedures and UDF within a LINQ context-Part ISep 04, 2008. In this two parts particle, I will give techniques of how to deal with stored procedures and user defined functions UDF from within a LINQ context rather than ADO.Net.
  • Error 501/505: Not implemented or not supported.Sep 14, 2008. Read this article if you are getting Error 501 not implemented or not supported.
  • Silverlight Tutorial: Creating a data centric Web Application with DataGrid, LINQ, and WCF Web ServiceSep 15, 2008. This step-by-step tutorial is a guide for creating a silverlight Web application capable of submitting and retreiving data from a database.
  • LinqDataSource Control in ASP.NET 3.5Sep 16, 2008. This article shows that how to use LindDataSource Control in ASP.NET 3.5.
  • Getting started with ADO.NET Entity Framework in .NET 3.5Sep 30, 2008. This article contains a very simple ADO.NET Entity Framework application to display and add the data to the database using ADO Entity Framework.
  • Getting started with ADO.NET Entity Framework in .NET 3.5 - Part IIOct 06, 2008. This article contains a very simple ADO.NET Entity Framework application to update and delete the data to the database using ADO Entity Framework.
  • Getting started with ADO.NET Entity Framework in .NET 3.5 - Part IIIOct 13, 2008. This article show us how to do conditional query and paging in ADO.NET Entity Framework.
  • Getting started with the Workflow FoundationOct 21, 2008. This article shows how to get started with the Workflow Foundation in .NET 3.5 and Visual Studio 2008.
  • Tracking Clicks by IP Address Using C# and XMLNov 20, 2008. This is a very simple and easy article, which gives an idea for track the IP address and for getting the number of cliks from a particular system.

About Getting-Column-Info-Through-LINQ

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