VB6 With Spread 3.0 - Looking to update to VB.NET

VB6 With Spread 3.0 - Looking to update to VB.NET

Posted by: kencuvar on 8 September 2017, 2:47 pm EST

• 

  kencuvar

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 2:47 pm EST

  A year ago I adopted a system that was written in Visual Basic 6 and used Farpoint Spread 3.0 components to display content from a teradata database.

   My organization is pushing for an upgrade to Visual Basic .NET.  i found a utility for upgrading VB6 code to VB.NET code.  However, the utility couldn't handle the spread code.  Is there a utility for updating the spread code to be .NET compatible?

   Will I need a newer version of the spread software?

   Any help on this is appreciated.

  Thanks
  
  

• 

  paul1960

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 2:47 pm EST

  To answer your question there is no such utility, are you using the Spread 3 COM component or the Spread Winforms 3 .Net component? If your company wants to go .Net you can use the COM product in .Net applications, if you want to use the .Net component though and you currently don’t have a .Net component our latest is Spread 6 for .Net

• 

  kencuvar

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 2:47 pm EST

  we're using spread for windows forms.

   I'm looking for a solution that will require little or no re-writing of the code.
  
  

• 

  deepaksharma14

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 2:47 pm EST

  Hello,

  As Paul said that there is no utility which can help you to convert your project which used Spread for COM to a VB.Net project using Spread for Windows. You would need to manually write the code for Spread. You may go through "Spread COM File Member Equivalents" in the online help for Spread for Windows.

   

  Thanks,

   

   

• 

  mjuras

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 2:47 pm EST

  Great Migrations offers a programmable software re-engineering tool called gmStudio that can help you rewrite VB6 to VB.NET (and C#) including automating custom COM API replacements.  I used gmStudio to upgrade Spread3.0 for COM to Spread 4.0 for .NET as part of a VB6 to C# upgrade project a couple years ago.   

  The heart of that particular app was VB6 UserControl that contained a dynamically allocated and configured control array of Spread3.0 controls.  In that case the  logic with respect to the Spread control was quite extensive and quite complex (about 10,000 LOC just for the UserControl).  We did not want to change that logic any more than necessary so we implemented a .NET UserControl derived from the .NET Spread.  This derived class for example exposed the same interface for the grid coordinate system and for row/column headers as the COM version, but it was all .NET on the inside.  The equivalents doc from this site was useful.  This AxControl was embedded in a couple dozen ASP pages -- which were also automatically migrated to ASP.NET/C#.  

• 

  consultor19

  • Post Options:
  • Link
    Copy

  Posted 28 August 2018, 10:46 am EST

  Hello

  I have a similar case. I have Virtual Machine with Windows XP i’m using there an app in VB 6.0 with a Spread 3 but i want to install that spread in windows 10 but is not compatible . What i can do?