From column_b first row its value is 25%, column_c is equals to column b. 2nd row column_b is 15%, 2nd row column_c is equals to 40% because the 25% from first row column_c is added to 15% of 2nd row column_b. Sorry I'm confused myself too. And yes it is in Excel and it will be shown from DataGridView
so far all I can do is show the tables from Excel to DataGridView and yes I'm using Dataset in my codes not the item one
Dim cmd As OleDbCommand = New OleDbCommand("SELECT * FROM [Sheet1$] Order By APM DESC", MyConnection)
Dim adpt = New OleDbDataAdapter(cmd)
'Here one CommandBuilder object is required.
'It will automatically generate DeleteCommand,UpdateCommand and InsertCommand for DataAdapter object
Dim builder As OleDbCommandBuilder = New OleDbCommandBuilder(adpt)
Dim DtSet2 = New DataSet()
DataGridView1.DataSource = DtSet2.Tables("Sheet1").DefaultView
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 ...
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. 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.