Beispiel #1
0
 private void ExcuteScript()
 {
     try
     {
         if (comboBox_queryType.SelectedItem.ToString() == "SelectQuery")
         {
             dataGridView_SQLResults.DataSource = proxy.ExcuteQuery(richTextBox_Query.Text, comboBox_Databases.SelectedValue.ToString(), decimal.ToInt32(numericUpDown_Records.Value), sessionID).Tables[0];
         }
         if (comboBox_queryType.SelectedItem.ToString() == "NonQuery")
         {
             DataTable dt = new DataTable();
             dt.Columns.Add("Result");
             DataRow dr = dt.Rows.Add(proxy.ExcuteNonQuery(richTextBox_Query.Text, comboBox_Databases.SelectedValue.ToString(), sessionID));
             dataGridView_SQLResults.DataSource = dt;
         }
         for (int count = 0; count < dataGridView_SQLResults.Columns.Count; count++)
         {
             dataGridView_SQLResults.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }