public static void executeSQL(string Code) { MainWindow.openConnection(); MainWindow.DT.Clear(); MainWindow.SQL = Code; MainWindow.cmd.CommandType = System.Data.CommandType.Text; MainWindow.cmd.CommandText = MainWindow.SQL; MainWindow.Adapter.SelectCommand = MainWindow.cmd; MainWindow.Adapter.Fill(MainWindow.DT); MainWindow.closeConnection(); }
private void Button_Click(object sender, RoutedEventArgs e) { MainWindow.openConnection(); if (MainWindow.DT.Rows.Count <= 0) { MainWindow.SQL = "USE [billing_simple.]; SELECT [payer_email], [recipient_email], [sum], [currency], [billing_date], [comment] FROM billing;"; MainWindow.cmd.CommandType = CommandType.Text; MainWindow.cmd.CommandText = MainWindow.SQL; MainWindow.Adapter.SelectCommand = MainWindow.cmd; MainWindow.Adapter.Fill(MainWindow.DT); } MainWindow.Adapter.Update(MainWindow.DT); MainWindow.closeConnection(); }
private void Window_Loaded(object Sender, RoutedEventArgs e) { MainWindow.openConnection(); MainWindow.SQL = "USE [billing_simple.]; SELECT [payer_email], [recipient_email], [sum], [currency], [billing_date], [comment] FROM billing;"; MainWindow.cmd.CommandType = CommandType.Text; MainWindow.cmd.CommandText = MainWindow.SQL; MainWindow.Adapter.SelectCommand = MainWindow.cmd; MainWindow.Adapter.Fill(MainWindow.DT); SQLGrid.ItemsSource = MainWindow.DT.DefaultView; MainWindow.closeConnection(); }
private void Button_Click(object sender, RoutedEventArgs e) { MainWindow.openConnection(); MainWindow.SQL = "use billing_simple.; insert into billing(payer_email,recipient_email,sum,currency,billing_date,comment) values ('" + payer.Text + "','" + recipient.Text + "','" + sum.Text + "','" + currency.Text + "','" + date.Text + "','" + comment.Text + "');"; MainWindow.cmd.CommandType = CommandType.Text; MainWindow.cmd.CommandText = MainWindow.SQL; int LCount = MainWindow.cmd.ExecuteNonQuery(); if (LCount > 0) { MessageBox.Show("Счет выписан!);"); } MainWindow.closeConnection(); }
private void Button_Click_1(object sender, RoutedEventArgs e) { MainWindow.openConnection(); MainWindow.SQL = "use[billing_simple.] SELECT* FROM billing WHERE sum > " + Text.Text + " and sum< " + Text2.Text + ""; MainWindow.cmd.CommandType = CommandType.Text; MainWindow.cmd.CommandText = MainWindow.SQL; try { MainWindow.SqlReader = MainWindow.cmd.ExecuteReader(); } catch (SqlException) { MessageBox.Show("Ошибка выполнения"); MainWindow.closeConnection(); return; } MainWindow.DT.Clear(); MainWindow.DT.Load(MainWindow.SqlReader); MainWindow.closeConnection(); }