public void Queryformoutorin(string outorin, QueryBill query)
{
using (MySqlConnection connection = Getconnection.GetConnection())
{
MySqlDataAdapter ada = new MySqlDataAdapter("select * from event where 收支方式=" + "'" + outorin + "'", connection);
DataSet da = new DataSet();
ada.Fill(da, "event");
query.dataGridView1.DataSource = da;
query.dataGridView1.DataMember = "event";
}
}
public void Queryfromdata(DateTime time, QueryBill query)
{
using (MySqlConnection connection = Getconnection.GetConnection())
{
MySqlDataAdapter ada = new MySqlDataAdapter("select * from event where 时间=" + "'" + time + "'", connection);
DataSet da = new DataSet();
ada.Fill(da, "event");
query.dataGridView1.DataSource = da;
query.dataGridView1.DataMember = "event";
}
}
private void button3_Click(object sender, EventArgs e)
{
QueryBill query = new QueryBill();
query.ShowDialog();
}