如何在电报机器人消息中显示数据库中的数据?我正在使用 SQLite。按照代码死胡同,没有思路……我开始这样做了:
try
{
conn.Open();
SQLiteCommand command = conn.CreateCommand();
command.CommandText = "SELECT * FROM [Users]";
SQLiteDataReader reader = command.ExecuteReader();
List<string[]> data = new List<string[]>();
while (reader.Read())
{
data.Add(new string[5]);
data[data.Count - 1][0] = reader[0].ToString();
data[data.Count - 1][1] = reader[1].ToString();
data[data.Count - 1][2] = reader[2].ToString();
data[data.Count - 1][3] = reader[3].ToString();
data[data.Count - 1][4] = reader[4].ToString();
}
reader.Close();
conn.Close();
foreach (string[] s in data) {
Message message1 = await botClient.SendTextMessageAsync(
chatId: chatId,
text: ,
cancellationToken: cancellationToken);
}
}
catch (Exception ex)
{
Console.WriteLine("Error: " + ex);
}
全部!