How to add lines manually in a datagriedview populated with Mysql data

Question

I have a Datagridview where I fill it with data from a mysql table and then need to add lines with some textbox data, when I try returns the following error: "It is not possible to add lines programmatically to the collection of Datagridview lines when the control is associated with data".

my code :

private void button1_Click(object sender, EventArgs e)     
{
    Hide();
    FormPai.dataGridView1.Rows.Add(txtCod.Text, servicosBox.Text, txtPreco.Text);
    FormPai.dataGridView1.Refresh();
}

Answer 1

You should instantiate a column before, recommend creating a function for this.

private void button1_Click(object sender, EventArgs e)
{
    Hide();
    CriarRow(/*DataSource usada*/);
    FormPai.dataGridView1.Refresh();
}

private void CriarRow(DataTable tabela)
{
    DataRow row = tabela.NewRow();
    row[0] = txtCod.Text;
    row[1] = servicosBox.Text;
    row[2] = txtPreco.Text;
    tabela.Rows.Add(row);
}