摘要：
2005/2008, the Pivot relationnal operator is used to convert rows into columns data. This feature is frequently used in reports and is pretty easy to work with.Available in SQL Server 2005/2008, the Pivot relationnal operator is used to convert rows into columns data. This feature is frequently used 阅读全文
摘要：
Just add empname, gender in table. So let's fill it with some data.insert into tblGenderEMP values (1, 'mohan', 'M' ,52)insert into tblGenderEMP values (2, 'mohini', 'F',65)insert into tblGenderEMP values (3, 'suraj', 'M',500)insert into tblGenderE 阅读全文
摘要：
Download source file (C#) - 1.6 KBDownload demo - 14.4 KBDownload source [VB.NET] - 1.98 KBDownload demo [VB.NET] - 15 KBIntroductionDisplaying data in tabular form is an essential part of any application nowadays. But sometimes you need to display a huge amount of data in terms of number of rows. I 阅读全文
摘要：
The Pivot MethodsFirst - Simple InversionRead all data, and return all columns as lines and lines as columns.The X axis column provided is used as the column header, and some columns may be ignored in the process, if desired so. Collapse | Copy Code/// /// Gets a Inverted DataTable/// /// DataTable 阅读全文
摘要：
Have a look at ExeclPackagePlus http://epplus.codeplex.comIt's great for these kinds of scenarios. private void DumpExcel(DataTable tbl) { try{ // OfficeOpenXml.ExcelPackage using (ExcelPackage pck = new ExcelPackage()) { //Create the worksheet ... 阅读全文
摘要：
you will want to make certain that if you take a backup of master on a server in your environment that you aren’t interfering with any existing backup plan:BACKUP DATABASE [master] TO DISK = N'C:\SQL\Backups\master.bak'Next we will create a test login as part of our practice run:USE [master] 阅读全文
摘要：
ISSUE:For example, one page accessed as:{physicalPath}/popup/Page1.aspx{projectPath}/popup/Page1.aspx {serverPath}/apsx/external/Page/{id}Route is registered in Global.asax as:routes.MapPageRoute("ViewPage","external/Page/{AccessKey}/","~/popup/Page1.aspx",false,newRout 阅读全文