Another issue just found was that the returned table name was always 9.4, not the real file name. ... View more

That's great, just test it and works well, except one minor issue when imported cell with null value, I just added the if statement  as follows and works well now.    foreach (var obs in xds.Observations) { var dr = dt.Rows.Add(); foreach (var c in obs.Cells) { if (!(c.Value is null)) { dr[c.Column] = c.Value; } } }    Cheers, Stanley ... View more

Yes, used in VB.NET. Below is the code, I tried to use Tables, DataTables, Tables(0), DataTables(0) but neither works, saying Tables.DataTables not the member of DataSets. I just would like to think about a more efficient way to import the data and bind with a datagridview, the codes in the second part works but might not be the best way. Please advise. Thanks a lot~~ Regards, Stanley ... View more

Yes, I did convert it to VB format but says datatable or table is not a member of datasets. ... View more

Happy New Year AlanC!   Thanks for your suggestion to switch C# and I will take it seriously. 😀. As for the datatable property, I tried to use that but seems not available in VB.NET, only tolist or to array could be accessable within datasets, is DataTable specifically designed for C# only?   Regards, Stanley ... View more

Thanks Alan for your quick response, I just want to import the XPT file and bind the data object with a datatable/datagrid view, below codes work but I am wondering whether there would be a more efficient way to bind the object directly, instead of the current for loop statement.     Dim engine = New Savian.SaviTransport.Engine() Dim options = New Savian.SaviTransport.Options() With { .XptFile = strFileName } Dim xptLib = engine.Process(options) For Each xpt In xptLib.DataSets        For Each v In xpt.Variables            dgvMain.Columns.Add(v.Name, v.Label)        Next        Dim intRowIndex As Integer = 0        For Each r In xpt.Observations            dgvMain.Rows.Add()            For i = 0 To dgvMain.Columns.Count - 1                 dgvMain.Rows(intRowIndex).Cells(i).Value = r.Cells(i).Value            Next            intRowIndex = intRowIndex + 1       Next Next     ... View more

Thanks for this excellent and powerful package. Very useful~~ Just a quick question that if it is possible to bind the data object to a datatable directly? I could use the property observations and cells to retrieve the data from each row respectively, but have no idea about the direct bindling with a datatable. Any advice would be highly appreciated. Thanks again! Stanley ... View more