private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { if (comboBox1.Text != "System.Data.DataRowView") { SqlServerFull _sqlServerSpectacle = new SqlServerFull(); DataSet _dataSetSpectacle = new DataSet(); _sqlServerSpectacle.SelectSqlCommand = "SELECT * FROM spectacle WHERE (spectacle_id = " + comboBox1.Text + ")"; if (_sqlServerSpectacle.ExecuteFill(_dataSetSpectacle, "spectacle")) { label2.Text = "(" + _dataSetSpectacle.Tables["spectacle"].Rows[0]["spectacle_name"].ToString() + ")"; } else MessageBox.Show("Произошла ошибка загрузки данных о спектаклях."); } }
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e) { if (comboBox2.Text != "System.Data.DataRowView") { SqlServerFull _sqlServerPlaces = new SqlServerFull(); DataSet _dataSetPlaces = new DataSet(); _sqlServerPlaces.SelectSqlCommand = "SELECT * FROM places WHERE (places_id = " + comboBox2.Text + ")"; if (_sqlServerPlaces.ExecuteFill(_dataSetPlaces, "places")) { label4.Text = "(Ряд: " + _dataSetPlaces.Tables["places"].Rows[0]["places_series"].ToString() + " Место: " + _dataSetPlaces.Tables["places"].Rows[0]["places_place"].ToString() + " Цена: " + _dataSetPlaces.Tables["places"].Rows[0]["places_price"].ToString() + ")"; } else MessageBox.Show("Произошла ошибка загрузки данных о местах."); } }
private void dataLoad() { SqlServerFull _sqlServerSpectacle = new SqlServerFull(); DataSet _dataSetSpectacle = new DataSet(); _sqlServerSpectacle.SelectSqlCommand = "SELECT * FROM spectacle"; if (_sqlServerSpectacle.ExecuteFill(_dataSetSpectacle, "spectacle")) { comboBox1.DataSource = _dataSetSpectacle.Tables["spectacle"]; comboBox1.DisplayMember = "spectacle_id"; } else MessageBox.Show("Произошла ошибка загрузки данных о спектаклях."); SqlServerFull _sqlServerPlaces = new SqlServerFull(); DataSet _dataSetPlaces = new DataSet(); _sqlServerPlaces.SelectSqlCommand = "SELECT * FROM places"; if (_sqlServerPlaces.ExecuteFill(_dataSetPlaces, "places")) { comboBox2.DataSource = _dataSetPlaces.Tables["places"]; comboBox2.DisplayMember = "places_id"; } else MessageBox.Show("Произошла ошибка загрузки данных о местах."); if (this.Text == "Изменить билет.") { SqlServerFull _sqlServerTicket = new SqlServerFull(); DataSet _dataSetTicket = new DataSet(); _sqlServerTicket.SelectSqlCommand = "SELECT * FROM ticket WHERE (ticket_id = " + ID.ToString() + ")"; if (_sqlServerTicket.ExecuteFill(_dataSetTicket, "ticket")) { comboBox1.Text = _dataSetTicket.Tables["ticket"].Rows[0]["ticket_spectacle"].ToString(); comboBox2.Text = _dataSetTicket.Tables["ticket"].Rows[0]["ticket_place"].ToString(); comboBox3.Text = _dataSetTicket.Tables["ticket"].Rows[0]["ticket_order"].ToString(); comboBox4.Text = _dataSetTicket.Tables["ticket"].Rows[0]["ticket_subscription"].ToString(); } else MessageBox.Show("Произошла ошибка открытия данных о выбраном билете."); } }