Hi guys,
I have been stucked in a situation where i need to use MSHFlexgrid control in VB.NET 2005 that was there in VB 6.0
I m trying to bind it to SQL Server database as if we do for Datagrid and datagridview. But It shows me casting error “Unable to cast object of type DataSet/DataTable/DataView to msdatasrc.DataSource”.
Hence, Kindly please help me to get the solution so that i can bind to the SQL SERVER database using mshflexgrid control in VB.NET.
Note: I want to use MSHFlexgrid control only because i need to merge the header cell across 2 or 3 or 4 columns. which i guess is not possible with Datagrid or datagridview control.
Please specify the complete code for database connection from scratch to displaying records in flexgrid.
Thanks to all of you in advance.