User talk:Monu khan99

Microsoft .NET Framework, ASP.NET, Visual C# (CSharp, C Sharp, C-Sharp) Developer Training, Visual Studio

i am working on C# form and Have axPivotTable Control.

for Databinding i am Using This Code

SqlConnection cn=new SqlConnection("database=durdu;user id=sa;pwd=");

              SqlDataAdapter cmd=new SqlDataAdapter ("select * from marksheet",cn);
              DataTable dt=new DataTable();
              cmd.Fill(dt);
              axPivotTable1.DataSource=(msdatasrc.DataSource)(object)dt;

this throws an error -specified cast is not valid.

i have done lots of googling and does not found single satisfied answer

please tell me how to bind data to a pivot table

its very urgent .

Please ask your questions on the C# Online Forum.

--Editor 02:19, 23 July 2008 (EDT)