private void Button1_Click(object sender, EventArgs e) { //Number of records in the table PbxLog item = comboBox1.Items[comboBox1.SelectedIndex] as PbxLog; SQL = $"SELECT COUNT(*) FROM {item.Table} WHERE extno BETWEEN '2301' and '2304' and action='Answer'"; MySqlCommand cmd = new MySqlCommand(SQL, conn); int _count = (int)(long)cmd.ExecuteScalar(); textBox1.Text = $"共{Convert.ToString(_count)}筆 "; }
private void ComboBox1_SelectedIndexChanged(object sender, EventArgs e) { PbxLog item = comboBox1.Items[comboBox1.SelectedIndex] as PbxLog; textBox1.Text = item.Calender; }