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(); } }
private void insertBtn_Click(object sender, RoutedEventArgs e) { string comm = "insert into " + title.Text + "("; foreach (getField item in stackFields.Children) { comm += item.getName() + ","; } comm = comm.Substring(0, comm.Length - 1); comm += ") values ("; foreach (getField item in stackFields.Children) { comm += DBSingleton.AdaptFieldValueToSql(item.getValue()) + ","; } comm = comm.Substring(0, comm.Length - 1); comm += ")"; if (DBSingleton.InsertSql(comm)) { Close(); } }