Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- NameColumn.TextChanged += (sender, e) =>
- {
- db.Close();
- db.Open();
- if (NameColumn.Text.Trim() != string.Empty)
- {
- try
- {
- db.Query($"EXEC sp_rename N'{TableName + "_COPY"}.[{ColumnName}]', N'{NameColumn.Text}', 'COLUMN';");
- db.Query($"UPDATE [{"USUMODEL" + TableName + "_COPY"}] SET [Имя столбца] = N'{NameColumn.Text}' WHERE [Имя столбца] = N'{ColumnName}'");
- ColumnName = NameColumn.Text;
- NameColumn.SetValue(HintAssist.HelperTextProperty, "");
- }
- catch
- {
- NameColumn.SetValue(HintAssist.HelperTextProperty, "Столбец с таким названием уже есть");
- }
- }
- else
- {
- NameColumn.SetValue(HintAssist.HelperTextProperty, "Введите название столбца");
- }
- OK.IsEnabled = true;
- foreach (TextBox text in scrollStack.Children.Cast<Grid>().Select(b => b.Children[1]))
- {
- if (!(text.GetValue(HintAssist.HelperTextProperty) == "" || text.GetValue(HintAssist.HelperTextProperty) == null))
- {
- OK.IsEnabled = false;
- break;
- }
- }
- db.Close();
- };
Advertisement
Add Comment
Please, Sign In to add comment