根据日期时间选取器值从 MySQL 数据库表中选择所有数据
本文关键字:数据库 选择 数据 MySQL 日期 时间 选取 | 更新日期: 2023-09-27 18:30:29
我想从表中选择所有数据,其中日期将来自DateTimePicker
。
这是我到目前为止的代码:
MySqlConnection connection = new MySqlConnection(MyConnection);
connection.Open();
MySqlCommand cmd = connection.CreateCommand();
cmd.CommandText = "SELECT * FROM income_table WHERE income_date='" +
dateShower.Value + "';";
cmd.Connection = connection;
MySqlDataReader myDataReader = cmd.ExecuteReader();
while (myDataReader.Read())
{
txtIncomeList.Text = Convert.ToString(myDataReader["income_subcategory"] +
"'t't" + myDataReader["income_amount"] + "'r'n" +
myDataReader["income_vendor"]+ "'t't" +
myDataReader["income_paidby"]+"'r'n'r'n");
}
sql 查询中的问题,您将日期时间选择器值(日期和时间)与无法检索任何数据的"income_date"字段数据匹配,您必须编辑查询以比较 2 个范围之间的日期,如下所示:
"SELECT * FROM income_table WHERE income_date > = '" + dateShower.Value.Date.ToString("yyyyMMdd") + " 00:00:00" + "' and income_date <= '" + dateShower.Value.Date.ToString("yyyyMMdd") + " 23:59:59" + "'";