RequestInvoices.getInvoices Method
Returns a data table containing the following columns:
index, country, issuer, counterpart, issueDate, branch, invoiceType, aa, series, currency, selfPricing
totalNetValue, totalVatAmount, totalWithheldAmount, totalFeesAmount, totalStampDutyAmount,
totalOtherTaxesAmount, totalDeductionsAmount, totalGrossValue, totalEntries, mark, uid, cancellationMark
in that order.
DataTable dt = rqd.getInvoices();
DataGridView1.DataSource = dt; // Load DataTable directly to a DataGridView
For (var i = 0; i <= dt.Rows.Count - 1; i++) // GO THROUGH ALL OF THE DATABASE'S ROWS
{
int index = dt.Rows(i).Item(0);
string country = dt.Rows(i).Item(1);
string issuer = dt.Rows(i).Item(2);
string counterpart = dt.Rows(i).Item(3);
DateTime issueDate = dt.Rows(i).Item(4);
string branch = dt.Rows(i).Item(5);
string invoiceType = dt.Rows(i).Item(6);
int aa = dt.Rows(i).Item(7);
string series = dt.Rows(i).Item(8);
string currency = dt.Rows(i).Item(9);
Boolean selfPricing = dt.Rows(i).Item(10);
double totalNetValue = dt.Rows(i).Item(11);
double totalVatAmount = dt.Rows(i).Item(12);
double totalWithheldAmount = dt.Rows(i).Item(13);
double totalFeesAmount = dt.Rows(i).Item(14);
double totalStampDutyAmount = dt.Rows(i).Item(15);
double totalOtherTaxesAmount = dt.Rows(i).Item(16);
double totalDeductionsAmount = dt.Rows(i).Item(17);
double totalGrossValue = dt.Rows(i).Item(18);
int totalEntries = dt.Rows(i).Item(19);
string mark = dt.Rows(i).Item(20);
string uid = dt.Rows(i).Item(21);
string cancellationMark = dt.Rows(i).Item(22);
}
This language is not supported or no code example is available.
Dim dt As DataTable = rqd.getInvoices()
DataGridView1.DataSource = dt 'Load DataTable directly to a DataGridView
For i = 0 To dt.Rows.Count - 1 'GO THROUGH ALL OF THE DATABASE'S ROWS
DataGridView1.DataSource = dt
Dim index As Integer = dt.Rows(i).Item(0)
Dim country As String = dt.Rows(i).Item(1)
Dim issuer As String = dt.Rows(i).Item(2)
Dim counterpart As String = dt.Rows(i).Item(3)
Dim issueDate As DateTime = dt.Rows(i).Item(4)
Dim branch As String = dt.Rows(i).Item(5)
Dim invoiceType As String = dt.Rows(i).Item(6)
Dim aa As Integer = dt.Rows(i).Item(7)
Dim series As String = dt.Rows(i).Item(8)
Dim currency As String = dt.Rows(i).Item(9)
Dim selfPricing as Boolean = dt.Rows(i).Item(10);
Dim totalNetValue As Double = dt.Rows(i).Item(11)
Dim totalVatAmount As Double = dt.Rows(i).Item(12)
Dim totalWithheldAmount As Double = dt.Rows(i).Item(13)
Dim totalFeesAmount As Double = dt.Rows(i).Item(14)
Dim totalStampDutyAmount As Double = dt.Rows(i).Item(15)
Dim totalOtherTaxesAmount As Double = dt.Rows(i).Item(16)
Dim totalDeductionsAmount As Double = dt.Rows(i).Item(17)
Dim totalGrossValue As Double = dt.Rows(i).Item(18)
Dim totalEntries As Integer = dt.Rows(i).Item(19)
Dim mark As Double = dt.Rows(i).Item(20)
Dim uid As Double = dt.Rows(i).Item(21)
Dim cancellationMark As Double = dt.Rows(i).Item(22)
Next
This language is not supported or no code example is available.