RequestMyExpenses.get_Invoices Method
Returns a data table containing the following columns:
index, issuer, counterpart, issueDate, invoiceType, selfPricing
totalNetValue, totalVatAmount, totalWithheldAmount, totalFeesAmount, totalStampDutyamount,
totalOtherTaxesAmount, totalDeductionsAmount, totalGrossValue, totalEntries, mark
in that order.
DataTable dt = rme.get_Invoices();
DataGridView1.DataSource = dt; //Load DataTable directly to a DataGridView
For (var i = 0; i <= dt.Rows.Count - 1; i++) //LOOP THROUGH ALL DATATABLE ROWS
{
int index = dt.Rows(i).Item(0);
string issuer = dt.Rows(i).Item(1);
string counterpart = dt.Rows(i).Item(2);
DateTime issueDate = dt.Rows(i).Item(3);
string invoiceType = dt.Rows(i).Item(4);
Boolean selfPricing = dt.Rows(i).Item(5);
double totalNetValue = dt.Rows(i).Item(6);
double totalVatAmount = dt.Rows(i).Item(7);
double totalWithheldAmount = dt.Rows(i).Item(8);
double totalFeesAmount = dt.Rows(i).Item(9);
double totalStampDutyamount = dt.Rows(i).Item(10);
double totalOtherTaxesAmount = dt.Rows(i).Item(11);
double totalDeductionsAmount = dt.Rows(i).Item(12);
double totalGrossValue = dt.Rows(i).Item(13);
int totalEntries = dt.Rows(i).Item(14);
string mark = dt.Rows(i).Item(15);
}
This language is not supported or no code example is available.
Dim dt As DataTable = rme.get_Invoices()
DataGridView1.DataSource = dt 'Load DataTable directly to a DataGridView
For i = 0 To dt.Rows.Count - 1 'LOOP THROUGH ALL DATATABLE ROWS
DataGridView1.DataSource = dt
Dim index As Integer = dt.Rows(i).Item(0)
Dim issuer As String = dt.Rows(i).Item(1)
Dim counterpart As String = dt.Rows(i).Item(2)
Dim issueDate As DateTime = dt.Rows(i).Item(3)
Dim invoiceType As String = dt.Rows(i).Item(4)
Dim selfPricing as Boolean = dt.Rows(i).Item(5)
Dim totalNetValue As Double = dt.Rows(i).Item(6)
Dim totalVatAmount As Double = dt.Rows(i).Item(7)
Dim totalWithheldAmount As Double = dt.Rows(i).Item(8)
Dim totalFeesAmount As Double = dt.Rows(i).Item(9)
Dim totalStampDutyamount As Double = dt.Rows(i).Item(10)
Dim totalOtherTaxesAmount As Double = dt.Rows(i).Item(11)
Dim totalDeductionsAmount As Double = dt.Rows(i).Item(12)
Dim totalGrossValue As Double = dt.Rows(i).Item(13)
Dim totalEntries As Integer = dt.Rows(i).Item(14)
Dim mark As Double = dt.Rows(i).Item(15)
Next
This language is not supported or no code example is available.