Am retrieving data from database to datagridview C# windows Form on form load, before it was working fine on normal retrieval, upon adding the try and catch block and await Task.Run() it display the message below... I don't know what is wrong again.
An unhandled exception of type 'System.NullReferenceException' occurred in System.Windows.Forms.dllAdditional information: Object reference not set to an instance of an object.
protected void Bind_Data()
{
try
{
Control.CheckForIllegalCrossThreadCalls = false;
connect.connect.Open();
Thread.Sleep(500);
MySqlCommand cmd = new MySqlCommand("SELECT * FROM table_A ORDER BY id ASC", connect.connect);
MySqlDataAdapter sda = new MySqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
this.Datagridview.DataSource = dt;
this.Datagridview.Columns["date_created"].Visible = false;
this.Datagridview.Columns["Time"].Visible = false;
connect.connect.Close();
count_DGV_lbl.Text = $"Total Records: {Datagridview.RowCount}";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Warning Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}