OK you've finally got me, X# is very cool!

lumberjack · Post by **lumberjack** » Sat Mar 16, 2019 9:53 am

Thanks Robert, well maybe Wolfgang can add it to his XSharp webpage then... Easy then to just tell people to follow the link and download...
@Wolfgang?

wriedmann · Post by **wriedmann** » Sat Mar 16, 2019 10:25 am

Hi Johan,
it's already there: (the link)
http://www.govulcan.net/portal/Learning ... fault.aspx
on the page
https://docs.xsharp.it/doku.php?id=quickstart_xsharp_vo
Or should the dokument itself being added to the wiki?
In that case we should ask Paul about permission and "refresh" it for X#, and add how to use the samples with Visual Studio and XIDE.
Wolfgang

lumberjack · Post by **lumberjack** » Sat Mar 16, 2019 10:43 am

Hi Wolfgang,
Yes think we need to break links to other sites if possible. I think yes, it might be the way to do it, get confirmation from Paul if we can share it there. I think even for VFP guys getting into X# a couple of the things like I showed Jeff regarding getting a DBF into a datatable is applicable, no worries about indexes, just a pure "select * from dbftable" approach.

wriedmann · Post by **wriedmann** » Mon Mar 18, 2019 7:23 pm

Hi Jeff,

please pay attention to a very important change between the native .NET data objects (DataSet, DataTable) and the way a DBServer works in Visual Objects:
A .NET DataTable is disconnected data, i.e you read all data into memory, and then work on this data. This may not be a problem with small data, but for larger tables this is a problem.
If you use the DataBrowser or bBrowser in VO: these controls read only the data needed to be displayed, so you can browse even large tables.
.NET is SQL based, and therefore you need to define the data you wish to read before you read them.
So for the migration of an application to WinForms or .NET using DBF tables you must take the same considerations as ina migration to SQL.
But my customers are changing what they expect from a database application: in the past incremental index searches were very important, but now they request more and more filters.

Wolfgang

wriedmann · Post by **wriedmann** » Mon Mar 18, 2019 8:13 pm

Hi Jeff,

please find attached a small WinForms application that uses a DBF from the SSA application and DBFNTX.
You can set the path to your local data in the ProgSettings module.
The application is in the XIDE export format, so you need this IDE to import and run the application.
Comments are welcome.

[The extension viaef has been deactivated and can no longer be displayed.]

Wolfgang

FoxProMatt · Post by **FoxProMatt** » Tue Mar 19, 2019 3:08 am

I've downloaded you sample app, but I'm not clear on where I can find the DBF and any other data files that are needed.

Please advise....

wriedmann · Post by **wriedmann** » Tue Mar 19, 2019 4:57 am

Hi Matt,
I'm very sorry, I forgot that not everyone has a VO installation.
Please find attached a zip file with the needed DBF table and NTX index.

Customer_SSATutor.zip: (2.09 KiB) Downloaded 64 times

Wolfgang
P.S. I will prepare another sample the next days, and a few samples (but most wih VO backgrounds) can be found here: https://www.riedmann.it/verschiedenes_xsharp.php

BiggyRat · Post by **BiggyRat** » Tue Mar 19, 2019 6:05 am

Thank you so much Wolfgang, that example has made a MASSIVE difference to my understanding of how that side of things work in X#

wriedmann · Post by **wriedmann** » Tue Mar 19, 2019 6:17 am

Hi Jeff,
you are welcome!
VO had the advantage that the GUI Classes were tightly bound to the DBF sequential data storage, so both the DataBrowser and bBrowser (and GridPro of course) could work very well with this data.
But times have changed and the time of sequential data storage (would it be DBF, Access, Cobol data, and many more) is over, and therefore also the time of databrowsers.
But if you need that type of data access also in a WinForms application: through a compatibility layer in WinForms you could put a bBrowser control on a WinForms window.
Wolfgang

Chris · Post by **Chris** » Tue Mar 19, 2019 8:24 am

BiggyRat wrote:Thank you so much Wolfgang, that example has made a MASSIVE difference to my understanding of how that side of things work in X#

Jeff, just to be clear for anybody else reading this thread, this is only ONE of the ways of how things work in X#. This is how you'd do things using standard .Net clasees with WinForms, but nothing stops you from still using the same DBServer class you are used to in VO, and you can use it the exact same way in X#. Also if you did a WPF app, you'd again use a different approach.

Btw, thanks for the sample Wolfgang, very nice! I would like to include also this in the XIDE samples if you do not mind. Although it would be even better if you can add some comments in the code of how to use it and explain a bit how it works.

Main menu