private void UpdateBtn_Click(object sender, RoutedEventArgs e) { string comm = "update " + title.Text + " set "; bool changed = false; foreach (getField item in stackFields.Children) { if (item.IsChanged()) { comm += item.getName() + "=" + DBSingleton.AdaptFieldValueToSql(item.getValue()) + ","; changed = true; } } if (!changed) { MessageBox.Show("You didn't updated anything!"); Close(); } comm = comm.Substring(0, comm.Length - 1); comm += DBSingleton.MakeWhereClause(field, values); if (DBSingleton.UpdateSql(comm)) { Close(); } }
public void DeleteRow(string tableName) { if (mainView.SelectedItem == null) { MessageBox.Show("You didn't chose any item to delete!"); return; } string sql = "delete " + tableName + DBSingleton.MakeWhereClause(mainView.Columns.Select(x => x.Header.ToString()).ToArray(), ((DataRowView)mainView.SelectedItem).Row.ItemArray.Select(x => x.ToString()).ToArray()); DBSingleton.DeleteSql(sql); RefreshView(); }