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(); }