private void providerselect_Load(object sender, EventArgs e)
{
string query = "select idprovider as ID, nameprovider as 'Nombre' from provider";
c.load_dgv(dataGridView1, query);
}
private void load()
{
string query = "select idnote as ID, note as Nota from procedurenotes where idprocedure = '" + vn_idpro_txt.Text + "'";
c.load_dgv(dataGridView1, query);
}