public static void AddDataTablNullLine(ClassNullLine classTablPSBBAAK) { SQLiteConnection db = new SQLiteConnection("Data Source = " + Path); db.Open(); SQLiteCommand insertCommand = new SQLiteCommand(); insertCommand.Connection = db; // Use parameterized query to prevent SQL injection attacks insertCommand.CommandText = "INSERT INTO НулевыеЛинии VALUES (NULL, @ИмяПлаты, @Конал1, @Конал2, @Конал3, @Конал4, @Конал5, @Конал6, @Конал7, @Конал8, @Конал9, @Конал10, @Конал11, @Конал12);"; insertCommand.Parameters.AddWithValue("@ИмяПлаты", classTablPSBBAAK.namePSB); insertCommand.Parameters.AddWithValue("@Конал1", classTablPSBBAAK.nullLine[0]); insertCommand.Parameters.AddWithValue("@Конал2", classTablPSBBAAK.nullLine[1]); insertCommand.Parameters.AddWithValue("@Конал3", classTablPSBBAAK.nullLine[2]); insertCommand.Parameters.AddWithValue("@Конал4", classTablPSBBAAK.nullLine[3]); insertCommand.Parameters.AddWithValue("@Конал5", classTablPSBBAAK.nullLine[4]); insertCommand.Parameters.AddWithValue("@Конал6", classTablPSBBAAK.nullLine[5]); insertCommand.Parameters.AddWithValue("@Конал7", classTablPSBBAAK.nullLine[6]); insertCommand.Parameters.AddWithValue("@Конал8", classTablPSBBAAK.nullLine[7]); insertCommand.Parameters.AddWithValue("@Конал9", classTablPSBBAAK.nullLine[8]); insertCommand.Parameters.AddWithValue("@Конал10", classTablPSBBAAK.nullLine[9]); insertCommand.Parameters.AddWithValue("@Конал11", classTablPSBBAAK.nullLine[10]); insertCommand.Parameters.AddWithValue("@Конал12", classTablPSBBAAK.nullLine[11]); insertCommand.ExecuteReader(); db.Close(); }
private void Button_Click_3(object sender, RoutedEventArgs e) { ClassNullLine d = (ClassNullLine)BAAKGrid1.SelectedItem; if (d != null) { DataAccesBDBAAK.DeleteNullLine(d.namePSB); } else { System.Windows.MessageBox.Show("Выделенных строк для удаления нет", "Процесс удаления строки"); } BAAKGrid1.ItemsSource = DataAccesBDBAAK.GetDataNullLine(); }