Attributes and Reflection

Throughout this book, I have emphasized that a .NET application contains code, data, and metadata. Metadata is information about the data--that is, information about the types, code, assembly, and so forth--stored along with your program. This chapter explores how some of that metadata is created and used.

Attributes are a mechanism for adding metadata, such as compiler instructions and other data about your data, methods, and classes, to the program itself. Attributes are inserted into the metadata and are visible through ILDasm and other metadata-reading tools.

Reflection is the process by which a program can read its own metadata. A program is said to reflect on itself, extracting metadata from its assembly and using that metadata either to inform the user or to modify its own behavior

Connect Data ADO NET—ADO NET Overview

http://en.csharp-online.net/Connect_Data_ADO_NET%E2%80%94ADO_NET_Overview

ADO.NET is the part of the .NET Framework that connects applications to data sources and lets you retrieve and update the contained data. ADO.NET supports a variety of different data sources, including relational databases such as Microsoft SQL Server, Oracle, and Microsoft Access, as well as other data sources such as Microsoft Excel, Outlook, and text files.

WCF

http://en.csharp-online.net/WCF_Essentials%E2%80%94Peer_Network_Address

converting rows data into colums using SQL Server

qryStr = " INSERT INTO jpFlatsCardRateComponentsTemp(siteID, flatNo, CardArea, cardRate, cardAmt, schArea, schRate, schAmt, compRate, uID) ";
qryStr += " SELECT siteID, flatNo ";
qryStr += " , SUM(case when compCode='CR' then componentArea end)CardArea ";
qryStr += " , SUM(case when compCode='CR' then componentRate end)cardRate ";
qryStr += " , SUM(case when compCode='CR' then componentAmt end)cardAmt ";
qryStr += " , SUM(case when compCode='SR' then componentArea end)schArea ";
qryStr += " , SUM(case when compCode='SR' then componentRate end)schRate ";
qryStr += " , SUM(case when compCode='SR' then componentAmt end)schAmt ";
qryStr += " , SUM(case when compCode<>'CR' AND compCode<>'SR' then componentRate end)compRate ";
qryStr += " , '" + Request.Form.Get("fUID") + "' ";
qryStr += " FROM jpFlatsCardRateComponents ";
qryStr += " WHERE siteID='" + Request.Form.Get("fSiteName") + "' ";
qryStr += " Group by siteID, flatNo ";