PivotTable and DataSet
-
Hi Well, my question today is how I could use a dataset into a PivotTable?? I try to use a PivotTable v10 into my C# project, and I wanna bind it from a dataset, but I don't know how. The PivotTable just can be binded from a DataSource :(. If someone work with PivotTable in C#, please help me. Thanks ---- hxxbin
-
Hi Well, my question today is how I could use a dataset into a PivotTable?? I try to use a PivotTable v10 into my C# project, and I wanna bind it from a dataset, but I don't know how. The PivotTable just can be binded from a DataSource :(. If someone work with PivotTable in C#, please help me. Thanks ---- hxxbin
It must bind against an ADO data source, not an ADO.NET data source. In order to do this, you must import the ADO typelib. If you have installed VS.NET, it is recommended that you use the Primary Interop Assembly (PIA) created by Microsoft, adodb.dll. This is found by default in Program Files\Microsoft.NET\Primary Interop Assemblies. You use ADO much like you use ADO.NET: you create connections and commands and execute that command to get back an ADO recordset, which you can then set as the
PivotTable.DataSourceproperty value.Microsoft MVP, Visual C# My Articles
-
It must bind against an ADO data source, not an ADO.NET data source. In order to do this, you must import the ADO typelib. If you have installed VS.NET, it is recommended that you use the Primary Interop Assembly (PIA) created by Microsoft, adodb.dll. This is found by default in Program Files\Microsoft.NET\Primary Interop Assemblies. You use ADO much like you use ADO.NET: you create connections and commands and execute that command to get back an ADO recordset, which you can then set as the
PivotTable.DataSourceproperty value.Microsoft MVP, Visual C# My Articles
-
Thanks, I better try to use ADO :((, I don't know how use PIA :( It's hard to use PIA?? ---- hxxbin
Just add a reference to it and access the classes just like you do with any other assembly.
Microsoft MVP, Visual C# My Articles