I want to add rows dynamically from database(in PDF Web) about flutter-widgets HOT 1 CLOSED

Hi rockstarvibu,

The DataTable allows only the type of List as a rows collection, but the provided code returns the MappedListIterable<Bill, DataRow>, due to this the exception occurs. So we have converted the map collection to list to overcome this issue.

Try the following solution in your side and let us know the details.

Solution 1: Convert the inerrable to list by using map().toList() method

//Create data table by using dynamic data from web.
DataTable dataTable = DataTable(
columns: const [
DataColumn(label: Text('Series From')),
DataColumn(label: Text('Series To')),
DataColumn(label: Text('No From')),
DataColumn(label: Text('No To')),
DataColumn(label: Text('QTY')),
DataColumn(label: Text('Price')),
],
rows: getBill.bill.map(
(value) => DataRow(cells: [
DataCell(Text(value.series_from.toString())),
DataCell(Text(value.series_to.toString())),
DataCell(Text(value.no_from.toString())),
DataCell(Text(value.no_to.toString())),
DataCell(Text(value.qty.toString())),
DataCell(Text(value.mrp.toString()))])).toList());
Note: MappedListIterable<K, V>.toList() used to get the List

Solution 2: Create List by iterating the bill entries by using forEach() function.

//Iterating bill object and adding the DataRow into List.
List rowCollection = [];
getBill.bill.forEach((value) => rowCollection.add(DataRow(cells: [
DataCell(Text(value.series_from.toString())),
DataCell(Text(value.series_to.toString())),
DataCell(Text(value.no_from.toString())),
DataCell(Text(value.no_to.toString())),
DataCell(Text(value.qty.toString())),
DataCell(Text(value.mrp.toString()))])));
//Create data table by using the list created.
DataTable dataTable = DataTable(
columns: const [
DataColumn(label: Text('Series From')),
DataColumn(label: Text('Series To')),
DataColumn(label: Text('No From')),
DataColumn(label: Text('No To')),
DataColumn(label: Text('QTY')),
DataColumn(label: Text('Price')),
], rows: rowCollection);
DataTable invoiceDetails = dataTable;

With Regards,
Anand Panchamoorthi

from flutter-widgets.