我正在使用MS SQL，我想读取数据并在ListViewBuilder中显示它，但我遇到了一些困难.
我不知道如何找到itemCount(最大的问题)
我不知道怎么显示Data in ListTile
查询-"从TabelTest中 Select *"
下面我将展示部分代码，以及我希望如何在APP中显示:
// This is to get and display in terminal data from db
Future<void> read(String query) async {
var res = await SqlConn.readData(query);
debugPrint(res.toString());
}Data that I need to put in ListTile
This is how I want to show data (Red underlines are main problem)
试试这个:
FutureBuilder<List?>(
future: read("SELECT * FROM TabelTest"),
builder: (context, snapshot) {
switch (snapshot.connectionState) {
case ConnectionState.waiting:
return Text('Loading....');
default:
if (snapshot.hasError)
return Text('Error: ${snapshot.error}');
else
List data = snapshot.data ?? [];
return ListView.builder(
itemCount: data.length,
itemBuilder: (context, index) {
return Text((data[index] as Map)['name']);
});
}
})
还要更改以下内容:
Future<List?> read(String query) async {
final result = await SqlConn.readData(query);
return jsonDecode(result) as List;
}