System.InvalidOperationException: "Fill: Свойство SelectCommand.Connection не инициализировано."

        public partial class Database : Form
        {
            MySqlDataAdapter adapter = new MySqlDataAdapter();
            BindingSource source = new BindingSource();
            MySqlConnectionStringBuilder str = new MySqlConnectionStringBuilder
            {
                Server = "***********",
                Port = *****,
                Database = "*****************",
                UserID = "********************",
                Password = "***************",
                CharacterSet = "utf8"
            };
            MySqlConnection connection;
            string current;
    
            public Database()
            {
                InitializeComponent();
            }
          private void Databese_Load(Object sender, System.EventArgs e)
            {
                connection = new MySqlConnection(str.ConnectionString);
                connection.Open();
            }
            private void Gett(string str)
            {
                current = str;
                str = "`****************`." + str + ";";
                str = "SELECT * FROM " + str;
                adapter.SelectCommand = new MySqlCommand(str, connection);
                
                DataTable dataSet = new DataTable();
                adapter.Fill(dataSet); //тут ошибка  
                adapter.UpdateCommand = new MySqlCommandBuilder(adapter).GetUpdateCommand();
                source.DataSource = dataSet;
                Data.DataSource = source;
            }
        }

При попытке вывести в Datagrid

System.InvalidOperationException: "Fill: Свойство SelectCommand.Connection не инициализировано."


Ответы (0 шт):