Full DataGridView for LabVIEW - OPEN SOURCE project underway

[Mike King]

Hi LAVAers.  I thought I'd post this up to grab some more eyes and ideas, and maybe contributors if there is interest.  I've started development of an open source datagridview project using .NET in LabVIEW to finally have a well implemented datagrid for use with LabVIEW UIs, data types and event integration.  I have this all working in a sample project and would love more ideas, feedback and and help if anyone wants to contribute.

 

The project is hosted on github,  https://github.com/unipsycho/LabVIEWdotNetDataGrid

 

I started a discussion for it in the LabVIEW NI community site when I started but its a LOT more presentable now, so extending this to LAVA.  The original discussion is here:

https://forums.ni.com/t5/LabVIEW/OpenSource-Project-for-a-NET-Datagrid-for-LabVIEW/m-p/3194273

 

The main premise of the project is to have extended data types, extended features with a event driven datagrid for LabVIEW using .NET.

 

Please let me know what you think or if any questions or ideas to add to this.

[ShaunR]

Have you considered making it an XControl so it is a drop in replacement?

[MikaelH]

Great work, I realy love it.

[Mike King]

Have you considered making it an XControl so it is a drop in replacement?

I haven't because I've really always hated XControls for there bugginess, troubleshooting difficultly and the fact that most people don't or can't develop them well.  I've always hit performance problems with them as well when handling large data and I think the instancing of .NET controls may just add to that in an XControl.   I'm not saying its not possible or even a good idea, just that I don't care to do it myself.  You could certainly contribute that though if you're better in XControls than I am.

 

 

Great work, I realy love it.

Thanks, please add any ideas or thoughts if you test it out more closely then.

[MikaelH]

I tried to add a DatePicker for a Date/Timestamp column, but that was a bit harder. It looks you have to make a child class to the Cell-Class to customize it. It is possible but then you have to have an extra dll to needs to be handled.

[Mike King]

MikaelH, 

 

Yes the date column sets up a date value type right now, but no date picker.  The picker can be done as you say, its a lot more involved though handling custom cell or column templates since there is much more event integration to handle the class differences. Date validation would be nice to add first I think, but certainly the date picker would be the best. Read more here:

https://msdn.microsoft.com/en-us/library/7tas5c80.aspx

[hooovahh]

Very cool, I saw your effort on the NI side and was hoping to see more refinement.  I hate XControls too, but when there is lots of polish, the can make the use of them so much nicer.  I still think this is too early to be thinking about them, but in the future, when this is somewhat feature complete, I'd recommend trying to shove it into an XControl, and make it easy to use.

[djolivet]

Missing VI:

 

[Mike King]

Whoops, sorry about that denis, Thanks for noting that problem. The SubVI was in fact there in the subVI folder but I got it cross linked into another project.  Should be fixed now and committed.

[massimo1167]

I have recently installed your library and I think it is really a great job to be integrated in my projects.
Fortunately you have covered a major gap in the data representation of LabVIEW.

When I'll start working on, I will send my feedback.

[MikaelH]

Hi Mike,

One question, The CellClicked Event gives me the Row and Column index, but after sorting the data, how do I get the Data of the cell?
The DataGridView:Get DataArray.vi, gets me the unsorted order, so Unless I track the sorting my self I'm not sure how to get an sorted grid's cell value based on the CellClicked event.

I'm sure there must be a way to do this.

[Ferrousduke]

On 4/4/2017 at 6:47 PM, MikaelH said:

Hi Mike,

One question, The CellClicked Event gives me the Row and Column index, but after sorting the data, how do I get the Data of the cell?
The DataGridView:Get DataArray.vi, gets me the unsorted order, so Unless I track the sorting my self I'm not sure how to get an sorted grid's cell value based on the CellClicked event.

I'm sure there must be a way to do this.

Instead of reading Data table, read Data grid view cell collection (see the attached). That will give you the sorted data. The only thing is that we don;t get sorted indices, so make an invisible column with incremental numbers - append it to your data. After sorting the table, the invisible column should give you the sorted indices. If there is any better way you have found out, let us know.

 

[MarkCG]

Very nice Mike, I am going to make use of this, it looks so much better than anything you could possibly do with arrays of clusters. Is there a way to prevent a column from being edited by the user?

Edited August 21, 2017 by MarkCG

[MarkCG]

DataGridView.lvclass:Set Cell Enabled State.vi . You have to iterate over the cells to disable the columns you want. Now as far as setting individual cell values programmatically without restarting / redrawing the whole table, does anyone have an idea? Nothing seem obvious

[Michael Castaneda]

Hi Mike,

Do you happen to have an example that updates more quickly? I read that you can bind the data last, but I tried this and I still see some performance issues when loading large amounts of data ~10,000 rows. Even when the data is loaded, scrolling seems to be laggy.

Also by any change is there a way to have an embedded progress bar (with multiple colors) as a column type?

Regards,

Mike C

[Crappy Sean]

I am new to LabView and learning "type sensitive popup". Anyone can help me  directions for learning materials?

[qilei]

hello，How do I set the background color of the control？

[MikaelH]

FYI, I've found the WebVIEW2 WebBrowser integration into LabVIEW + a fancy DataGrid JavaScript library is a much flexible approach.
We've posted the LV-64 bit supported WebView2 support here: https://github.com/ANSCenter/LcWebView2
I use http://tabulator.info/  to make nice DataGrids in LabVIEW.

 

[mcduff]

On 10/18/2022 at 4:10 PM, MikaelH said:

FYI, I've found the WebVIEW2 WebBrowser integration into LabVIEW + a fancy DataGrid JavaScript library is a much flexible approach.
We've posted the LV-64 bit supported WebView2 support here: https://github.com/ANSCenter/LcWebView2
I use http://tabulator.info/  to make nice DataGrids in LabVIEW.

 

Do you have any advice for installing WebVIEW2? I have gotten it to work on one computer but not another for the same exact installation, I think. Thanks

[MikaelH]

I've had issues on Windows 7, but no issues on Windows 10 yet.
When our SW needs it and can't find it we let the user install it on the fly running this exe file:
MicrosoftEdgeWebView2RuntimeInstallerX64.exe
..and that has never failed yet, maybe it could cause issues if you've installed the 32 bit version first?!?