Ejemplo n.º 1
0
        private void ExecuteButton_Click(object sender, EventArgs e)
        {
            string _SQL = textBoxSQL.Text;

            try
            {
                if (_SQL.StartsWith("select", StringComparison.OrdinalIgnoreCase))
                {
                    ShowData(m_Manager.Select(_SQL));
                }
                else
                {
                    ClearData();
                    SQLStatusLabel.Text = string.Format("Обработано {0} записей.", m_Manager.Execute(_SQL));
                }
            }
            catch (Exception ex)
            {
                ShowErrorMessage(ex.Message, "Выполнение SQL запроса.");
                return;
            }
        }
Ejemplo n.º 2
0
        private void ExecuteButton_Click(object sender, EventArgs e)
        {
            string _SQL = textBoxSQL.Text;

            try
            {
                if (_SQL.StartsWith("select", StringComparison.OrdinalIgnoreCase))
                {
                    ShowData(m_Manager.Select(_SQL));
                }
                else
                {
                    ClearData();
                    SQLStatusLabel.Text = string.Format("{0} records selected.", m_Manager.Execute(_SQL));
                }
            }
            catch (Exception ex)
            {
                ShowErrorMessage(ex.Message, "Execute SQL query");
                return;
            }
        }