//---------------------------------------------------------------------------------------- #region Select Function private void SelectButton_Click(object sender, EventArgs e) { if (table != null) { try { StringBuilder command = new StringBuilder(String.Format("WHERE {0} {1} ", filterBox.SelectedItem, compererBox.SelectedItem)); if (compererBox.Text == "LIKE" || compererBox.Text == "NOT LIKE") { command.AppendFormat("'%{0}%' ", filterTextBox.Text); } else { command.AppendFormat("'{0}' ", filterTextBox.Text); } for (int i = 0; i < 3; i++) { ComboBox andOrBox = null; if (this.groupBox2.Controls.Find("AddFilterBox" + i, false).Length != 0) { andOrBox = this.groupBox2.Controls.Find("AddFilterBox" + i, false)[0] as ComboBox; command.AppendFormat(" {0} ", andOrBox.Text); if (andOrBox != null && andOrBox.SelectedIndex != -1) { command.AppendFormat("{0} {1} ", this.groupBox2.Controls.Find("FilterBox" + i, false)[0].Text, this.groupBox2.Controls.Find("CompererBox" + i, false)[0].Text); if (this.groupBox2.Controls.Find("CompererBox" + i, false)[0].Text == "LIKE" || this.groupBox2.Controls.Find("CompererBox" + i, false)[0].Text == "NOT LIKE") { command.AppendFormat("'%{0}%' ", this.groupBox2.Controls.Find("FilterTextBox" + i, false)[0].Text); } else { command.AppendFormat("'{0}' ", this.groupBox2.Controls.Find("FilterTextBox" + i, false)[0].Text); } } } } dataGridView1.DataSource = TableExplorer.SelectTable(command.ToString(), "SELECT * FROM " + table.TableName); } catch (Exception ex) { MessageBox.Show("Some SELECT fields are empty or irregular! \n" + ex.Message); } } else { MessageBox.Show("There is no table selected!"); } }
private void ComplexQueryForm_Load(object sender, EventArgs e) { DataTable table = TableExplorer.SelectTable("", "SELECT DISTINCT m.MovieID, m.Title FROM Movies m RIGHT JOIN MovieActors ma ON m.MovieID = ma.MovieID"); MoviesComBox.DataSource = table; MoviesComBox.DisplayMember = "Title"; MoviesComBox.ValueMember = "MovieID"; }
private void MoviesComBox_SelectedIndexChanged(object sender, EventArgs e) { if (MoviesComBox.SelectedValue is int) { string command = String.Format( "SELECT X.ActorID, FName, LName, DateOfBirth, CountryOfBirth, CityOfBirth " + "FROM MovieActors X " + "JOIN Actors a ON a.ActorID = X.ActorID WHERE MovieID = \'{0}\'", MoviesComBox.SelectedValue); dataGridView1.DataSource = TableExplorer.SelectTable("", command); } }