private void RUN_Click(object sender, EventArgs e) { if (this.richTextBox1.Text.Length <= 0) { MessageBox.Show(@"QUERY IS EMPTY", @"ERROR!"); return; } if (this.m_checkPassword()) { MessageBox.Show(@"INVALID PASSWORD", @"ERROR!"); return; } using (SqlConnection connection = new SqlConnection(Proprietary.getConnectionString())) { connection.Open(); SqlDataAdapter adapter = new SqlDataAdapter(this.richTextBox1.Text, connection); DataTable dt = new DataTable(); try { adapter.Fill(dt); this.dataGridView2.DataSource = dt; } catch (Exception ex) { MessageBox.Show(ex.Message, @"MALFORMED QUERY"); } } }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { try { using (SqlConnection connection = new SqlConnection(Proprietary.getConnectionString())) { connection.Open(); string cmdstr = "SELECT * FROM " + this.comboBox1.Text; SqlDataAdapter sda = new SqlDataAdapter(cmdstr, connection); DataTable dt = new DataTable(); sda.Fill(dt); this.dataGridView1.DataSource = dt; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e) { try { using (SqlConnection connection = new SqlConnection(Proprietary.getConnectionString())) { connection.Open(); string businessQuestion = Proprietary.getQuestions()[(int.Parse(this.comboBox2.Text) - 1)]; SqlDataAdapter sda = new SqlDataAdapter(businessQuestion, connection); DataTable dt = new DataTable(); sda.Fill(dt); this.dataGridView3.DataSource = dt; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button1_Click(object sender, EventArgs e) { using (SqlConnection connection = new SqlConnection(Proprietary.getConnectionString())) { try { connection.Open(); string cmdstr = "SELECT * FROM [dbo].[" + this.comboBox1.Text + "]"; SqlDataAdapter sda = new SqlDataAdapter(cmdstr, connection); SqlCommandBuilder cmd = new SqlCommandBuilder(sda); sda.InsertCommand = cmd.GetInsertCommand(); sda.DeleteCommand = cmd.GetDeleteCommand(); sda.UpdateCommand = cmd.GetUpdateCommand(); sda.Update((DataTable)this.dataGridView1.DataSource); } catch (Exception err) { MessageBox.Show(err.ToString(), @"ERROR"); } } }
private void m_fillCombo() { const string cmdstr = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME NOT IN ('SYSDIAGRAMS')"; DataTable dt = new DataTable(); SqlDataAdapter sda = new SqlDataAdapter(cmdstr, Proprietary.getConnectionString()); try { sda.Fill(dt); foreach (DataRow row in dt.Rows) { if (row != null) { this.comboBox1.Items.Add(row["TABLE_NAME"]); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private bool m_checkPassword() { return(this.textBox1.Text != Proprietary.getPassword()); }