I know how to do it in ado. I was just wondering how this can be done in a datatable.
In ADO, i just connect an execute a command with commandtext like Select sum(Quantity) from Purchases where transaction_mode=1 and capture result in a string variable.
So, what I ask, is how table.columns(int).expression(expresion_string) works, if I may use .expression property to return result of query, if this is possible.
And if this is possible, how can I simulate the above SQL string into .expression
Almost done this I guess...
It's the .compute that I need. So it must be like datatable(tablename).compute("sum(quantity)", "transaction_mode=1")
Haven't tried this yet, but I'm almost sure this is it.
I am writing a java program that needs to execute shell commands, so I wrote a function that would take the command to execute as a string (ie: "mkdir ~/Folder1") and execute that command with the shell. Here is the function:
Runtime run = Runtime.getRuntime();
Process pr = ...
Hi, as I was told that my code doesn’t scale well at all, I thought perhaps I’d try to get a better understanding of interfaces/abstract classes and classes and the relationship between them.
I don’t want at this stage work on a big separate project as I've already got plenty ...
Hi. I have a form with list box : lst_product, datagridview : grd_order and button: btn_addline. lst_product has a list of product ids selected from database (MS Acess 2013) , grd_order is by default empty except for 2 headers and btn_addline adds rows to grd_order.