Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DataTable schemaTable = new DataTable();
- MySqlDataReader dataReader;
- try
- {
- using (MySqlConnection connection = new MySqlConnection(conf.connection_string))
- {
- if (OpenConnection(connection))
- {
- using (MySqlCommand cmd = new MySqlCommand())
- {
- cmd.CommandText = "SELECT * FROM " + privateCustomerTablename;
- cmd.Connection = connection;
- dataReader = cmd.ExecuteReader(CommandBehavior.KeyInfo);
- schemaTable = dataReader.GetSchemaTable();
- }
- CloseConnection(connection);
- }
- }
- }
- catch (MySqlException ex)
- {
- ErrorMessage.MySql(ex.Number, ex.Message);
- }
- foreach (DataRow field in schemaTable.Rows)
- {
- if (field.Field<String>("ColumnName") != "id")
- {
- TextBox textbox = new TextBox();
- textbox.Margin = new Thickness(5);
- MaterialDesignThemes.Wpf.HintAssist.SetIsFloating(textbox, true);
- if (field.Field<Boolean>("AllowDBNull"))
- {
- MaterialDesignThemes.Wpf.HintAssist.SetHint(textbox, UppercaseFirst(field.Field<String>("ColumnName")));
- }
- else
- {
- MaterialDesignThemes.Wpf.HintAssist.SetHint(textbox, UppercaseFirst(field.Field<String>("ColumnName") + " (Required Field)"));
- Binding binding = new Binding();
- binding.UpdateSourceTrigger = UpdateSourceTrigger.PropertyChanged;
- binding.ValidatesOnDataErrors = true;
- binding.NotifyOnValidationError = true;
- binding.ValidationRules.Add(new NotEmptyValidationRule());
- textbox.SetBinding(TextBox.TextProperty, binding);
- }
- textbox.Name = field.Field<String>("ColumnName");
- textbox.Tag = field.Field<Boolean>("AllowDBNull");
- StackPanel.Children.Add(textbox);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement