Flutter - Fetch records from database and display in ListView Builder

Question

I'm working on a Flutter project and using Sqflite database. I've managed to save data in db. Now I am trying to get list of all records from database based on table name and display them in "ListView.builder".

database_helper.dart

Future<List> getAllRecords(String dbTable) async {
    var dbClient = await db;
    var result = await dbClient.rawQuery("SELECT * FROM $dbTable");

    return result.toList();
}

employees_list.dart

import 'package:flutter/material.dart';
import 'package:flutter_with_db_single_helper/helpers/database_helper.dart';

var db = new DatabaseHelper();
Future<List> _users = db.getAllRecords("tabEmployee"); // CALLS FUTURE

class EmployeesListScreen extends StatefulWidget {
  @override
  _EmployeesListScreenState createState() => _EmployeesListScreenState();
}

class _EmployeesListScreenState extends State<EmployeesListScreen> {

  @override
  Widget build(BuildContext context) {
    return Scaffold(
      appBar: AppBar(
        title: Text('List Of Employees'),
      ),
      body: ListView.builder(
        // itemCount: _users.length,
        itemBuilder: (_, int position) {
          return Card(
            child: ListTile(
              title:
                  Text("Employee Name: "), // EMPLOYEE NAME TO BE DISPLAYED HERE
            ),
          );
        },
      ),
    );
  }
}

Where did I go wrong? What can I do to display all my db table records in list?

what's the error?

diegoveloper
– diegoveloper

2018-12-05 14:13:28 +00:00
Commented Dec 5, 2018 at 14:13 — diegoveloper
– diegoveloper, Commented Dec 5, 2018 at 14:13

Zain SMJ · Accepted Answer · 2018-12-05 14:53:04Z

11

You could use a FutureBuilder to get and display your data :

        class _EmployeesListScreenState extends State<EmployeesListScreen> {
          var db = new DatabaseHelper(); // CALLS FUTURE

          @override
          Widget build(BuildContext context) {
            return Scaffold(
              appBar: AppBar(
                title: Text('List Of Employees'),
              ),
              body: FutureBuilder<List>(
                future: db.getAllRecords("tabEmployee"),
                initialData: List(),
                builder: (context, snapshot) {
                  return snapshot.hasData
                      ? ListView.builder(
                          itemCount: snapshot.data.length,
                          itemBuilder: (_, int position) {
                            final item = snapshot.data[position];
                            //get your item data here ...
                            return Card(
                              child: ListTile(
                                title: Text(
                                    "Employee Name: " + snapshot.data[position].row[1]),
                              ),
                            );
                          },
                        )
                      : Center(
                          child: CircularProgressIndicator(),
                        );
                },
              ),
            );
          }
        }

edited Dec 5, 2018 at 14:53

Zain SMJ

1,6328 gold badges23 silver badges35 bronze badges

answered Dec 5, 2018 at 14:19

diegoveloper

104k25 gold badges253 silver badges201 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Pants Over a year ago

Great Answer, however could be simplified slightly :) "Employee Name: " + item.row[1]

ishaan · Accepted Answer · 2018-12-05 14:20:05Z

3

This might not be correct code, since I've not tested this, but this is how list view builder works and try using async await. Cleans up code quite a bit!

import 'package:flutter/material.dart';
import 'package:flutter_with_db_single_helper/helpers/database_helper.dart'

class EmployeesListScreen extends StatefulWidget {
    @override
    _EmployeesListScreenState createState() => _EmployeesListScreenState();
}

class _EmployeesListScreenState extends State<EmployeesListScreen> {

    List<String> _records;
    @override
    initState(){
        super.initState();
    }

    Future<void> _getRecords() async {
        var res = await db.getAllRecords("tabEmployee"); 
        setState((){
            _records = res;
        });
    }

    @override
    Widget build(BuildContext context) {
    return Scaffold(
        appBar: AppBar(
        title: Text('List Of Employees'),
        ),
        body: _records==null ? Container():ListView.builder(
        itemCount: _records.length,
        itemBuilder: (_, int position) {
            return Card(
            child: ListTile(
                title:
                    Text("Employee Name: ", _records[position]),
            ),
            );
        },
        ),
    );
    }
}

Or you can use a future builder, as the other answer shows. :)

answered Dec 5, 2018 at 14:20

ishaan

2,0511 gold badge20 silver badges32 bronze badges

2 Comments

Zain SMJ Over a year ago

It was a good approach. Thanx for the help. I used FutureBuilder though.

Sajidkhan Over a year ago

you solved my problem, one thing should be added, _getRecords() should be called in initState();

Collectives™ on Stack Overflow

Flutter - Fetch records from database and display in ListView Builder

2 Answers 2

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related