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.
For Each ctrl As Control In Me.Controls("pnlMainPanel").Controls
If ctrl.GetType Is GetType(System.Windows.Forms.Panel) Then
For Each subCtrl As Control In ctrl.Controls
If subCtrl.GetType Is GetType(System.Windows.Forms.TextBox) Then
If subCtrl.GetType Is ...