以编程方式填充数据透视表 [英] Populate Pivote Table programmatically

问题描述

大家好，
我对数据透视表感到震惊，谁能告诉我如何使用c#以编程方式从sql数据库中填充数据透视表，并在可能的情况下还根据参数更新表，因此，我真的很累...:(

Hello guys,
I am struck with pivot tables, can anyone tell me how can I populate pivot tables from sql database programmatically using c# and also update the table based on parameters if possible, i am really tired with this... :(

推荐答案

SQL Server 2005和更高版本将在T-SQL中创建数据透视表.帮助文件(在线图书)显示了示例.
噢，我听起来不权威.除了我上周才发现这一点，我自己. :-p

SQL Server 2005 and later will do pivot tables in T-SQL. The help file (Books On Line) shows examples.

Ooooo, don''t I sound authoritative. Except I just found this out last week, myself. :-p

这篇关于以编程方式填充数据透视表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！