MySqlConnection myConnection;
            MySqlDataAdapter myDataAdapter;
            DataSet myDataSet;
            string strSQL;

            myConnection = new MySqlConnection("server=myServer; user id=myUser; password=myPwd; database=myDb; pooling=false;");
            strSQL = "SELECT Name_SI FROM partners where idPartner=1;";

            MySqlCommand myCommand = new MySqlCommand("update partners set Name_SI='¨' where IdPartner=1;", myConnection);
            myCommand.Connection.Open();
            myCommand.ExecuteNonQuery();

            myDataAdapter = new MySqlDataAdapter(strSQL, myConnection);
            myDataSet = new DataSet();
            myDataAdapter.Fill(myDataSet, "mytable");

            MySQLDataGrid.DataSource = myDataSet;
            MySQLDataGrid.DataBind();

        

public Partner UpdatePartner(string Name_SI, int IdPartner)
        {
       
            /* aggiorno i dati */
            using (myEntities ctx = new myEntities())
            {
                p = (from item in ctx.PartnerSet where item.IdPartner == IdPartner select item).First();
                p.Name_SI = Name_SI;

                ctx.SaveChanges();

                ctx.Detach(p);
            }

            return p;
        }