> From: NTMS > Does anyone have any example how to populate Customer > File that reside on jBase server into VB.NET dataset. > The compony I work for going to buy mv.NET and I am > very cautious about the speed to product. > > We have over 100 Pre-define Excel sheet to create a > report and around 5-6 of them have to be real-time > report. We contact mv.NET but I like to hear more > about the product from other than mv.NET.
As an mv.NET Worldwide Distributor, we provide both software and services to assist with this sort of project. We don't like mv.NET because we sell it. We sell it because we like it. There are a couple ways to move jBase data to/from relational. 1) Create an mvSelect item, use that to populate an mvItemList, then use the DataTable method to create a real ADO.NET DataTable. That takes all of about 1 line of code for the raw basics but not many more to refine the process. 2) That doesn't help with well structured data that conforms to a specific schema. So an alternative is to separate the ETL components where you loop to Extract data from jBASE in a couple lines, Transform data types and do other minor manipulation, then Load the data into a DataTable / DataSet with AddRow methods. 3) Another way to do this is with the AdapterObjects library, one of the three primary libraries that comes with the mv.NET product. This allows you to reference your jBASE data as though it were relational, and directly populate mv.NET objects that implement the ADO.NET interfaces. Here the idea is that you're not extracting MV data and transforming to relational, you're looking at all of the data as relational - and without making any changes to your existing file structures. If you're doing Microsoft Office integration, please note that we also write Excel and Outlook addins to create seamless data exchanges with jBASE/MV environments - that means real-time updates of cells, charts, contacts, appointments, etc. HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula R&D sells mv.NET and other Pick/MultiValue products worldwide, and provides related development and training services Keep up with the Blog! : remove.pleaseNebula-RnD.com/blog --~--~---------~--~----~------------~-------~--~----~ Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en -~----------~----~----~----~------~----~------~--~---
