Create JMP datatable from C# DataTable variable

ChrisM_X

What is the most effecient way of creating a JMP datatable from a C# DataTable variable?  I am presently using the windows clipboard to paste all the information into JMP. (C# first filling the clipboard)  This works, but Windows clipboard is not reliable and sometimes comes-up empty.

 

I sent a support ticket a few months back and got this messsage..

 

Support Message:

...........................

 Also, you can use the GetTableHandleFromIndex or GetTableHandleFromName methods to get a C# reference to DataTable automation object, as documented here.

...........................

I didn't really understand what this meant, when I read the link and was clueless as what to do?

 

Basically C#  JMP automation code I want to do somethign like this:

 

CreateJMPDatatable (DT)

 

where DT is a variable of type DataTable (C#)

 

I could try nested for loops to loop through columns and rows and have JSL populate cell by cell and create needed columns and rows, (which I will try soon) but wondering if there is a quicker and easier way to achieve the same result?   (100,000 rows and 100 columns, so I want something quick and effiecient)

 

Thank you,

Justin_Chilton

Hi Chris,

I believe I was the one who helped you out a few months ago. The snippet you provided from our conversation was in reference to creating a C# DataTable object from a JMP data table, not the other way around. Below is what I said about going from C# to JMP.

There is not a direct path for converting a C# data table object to a JMP Data Table. Instead, you will need to use JMP Automation methods to create an empty table, loop through columns of the C# table, creating the JMP columns, and then loop through the rows of the C# table, adding the row/column values to the JMP Data Table.

Here is something I threw together that loops through the columns and rows to create a JMP.DataTable:

class Program
    {
        static void Main(string[] args)
        {
            Program p = new Program();
            // call method to get sample C# data table
            DataTable dt = p.GetTable();

            JMP.Application myJMP = new JMP.Application();
            myJMP.Visible = true;
            myJMP.EnableInteractiveMode(true);

            JMP.DataTable jmpDT;
            jmpDT = myJMP.NewDataTable("Example");
            Object jmpCol;
            
            // add each column to the JMP table
            foreach (DataColumn col in dt.Columns)
            {
                // if its an integer, create numeric column (you may need to check for other Types, such as Decimal or DateTime)
                if (col.DataType == System.Type.GetType("System.Int32"))
                {
                    jmpCol = jmpDT.NewColumn(col.ColumnName, JMP.colDataTypeConstants.dtTypeNumeric, 0, 8);
                }
                else
                {
                    jmpCol = jmpDT.NewColumn(col.ColumnName, JMP.colDataTypeConstants.dtTypeCharacter, 0, 8);
                }
            }
            
            // add rows to the table
            jmpDT.AddRows( (Int16) dt.Rows.Count, 0 );
            int i = 1;
            foreach (DataRow row in dt.Rows)
            {
                foreach (DataColumn col in dt.Columns)
                {
                    jmpDT.GetColumn(col.ColumnName).SetCellVal(i, row[col.ColumnName].ToString());
                }
                i++;
            }

            

        }
        // From:  https://msdn.microsoft.com/en-us/library/9ha04z01(v=vs.110).aspx
        private DataTable GetTable()
        {
            // Create new DataTable.
            DataTable table = new DataTable();

            // Declare DataColumn and DataRow variables.
            DataColumn column;
            DataRow row;

            // Create new DataColumn, set DataType, ColumnName
            // and add to DataTable.    
            column = new DataColumn();
            column.DataType = System.Type.GetType("System.Int32");
            column.ColumnName = "id";
            table.Columns.Add(column);

            // Create second column.
            column = new DataColumn();
            column.DataType = Type.GetType("System.String");
            column.ColumnName = "item";
            table.Columns.Add(column);

            // Create new DataRow objects and add to DataTable.    
            for (int i = 0; i < 10; i++)
            {
                row = table.NewRow();
                row["id"] = i;
                row["item"] = "item " + i;
                table.Rows.Add(row);
            }
            return table;
        }
    }

I hope this is helpful. Let me know if you have any further questions.

Thanks!