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 не инициализировано."